Oracle SQL: LAG Oracle 11g is analytic function

Very usefully new features in Oracle 11g is analytic function LAG Query This code find change in address post code in journal table Test data Result site_number jn_datetime adr_postcode prev_adr_postcode 20001 2017-08-01 15:01:31 00-001 10-001 20002 2017-04-20 11:59:29 00-001 20-002 20003 2017-06-15 04:02:41 00-001 30-003   http://sqlfiddle.com/#!4/57db1f/2/0

PLSQL corner

PLSQL loop inexed by letters

But this is not portable across character sets. I think a better solution is to declare up front your index variables like this:

That way if you change character sets (e.g. to utf8) you are not reliant on a collating sequence that doesn't match your char set.

Narzędzia to projektowania baz danych

GNU-GPL OpenSystemArchitect http://www.codebydesign.com/ Power*Architect http://code.google.com/p/power-architect/ Druid http://druid.sourceforge.net/ ERW http://erw.dsi.unimi.it/ Dia http://live.gnome.org/Dia XML to DDL (python scripts) http://xml2ddl.berlios.de/ Graphiz - I believe I've read of people using it to reverse engineer from DDL http://graphviz.org/ Multiple versions/licenses (each has a "free" and a "not-free" version) DBVisualizer Toad http://www.toadsoft.com/ Not-free Microsoft Visio - (If you already have it,... Continue Reading →

Generic DataSource on CDHDR and CDPOS Tables

http://www.docfoc.com/generic-datasource-on-cdhdr-and-cdpos-tables

Pomiar wydajności bazy danych

Przy wyborze hostingu warto sprawdzić jak prezentuje się wydajność zakupionych serwerów może w tym pomóc skrypt http://www.linux.pl Po przeróbkach skryptu zainstalowałem go na serwerze http://ultimasolution.pl/projects/bechmark_phpmysql/?iterations=50000&tabletype=MYISAM i oto co wyszło: Testing a(n) MYISAM table using 50000 rows. Successfully created database speedtestdb Sucessfully created table speedtesttable This MySQL instance does NOT support MYISAM tables Table Type Verified:... Continue Reading →

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑