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 ↑