oracle

Oracle SQL query – sort by Czech language

This was the best result so far that reflected czech characters and IMHO correct sorting. select * from test6 order by NLSSORT( (NAME),’NLS_SORT=Xczech‘)   46 46 d 47 47 D 134 134 dra 136 136 Dra 139 139 dráb 138…

Oracle setting – language specific search

Our R&D did struggle with Oracle setting for Czech specific search. Following might be the solution. ALTER SESSION SET NLS_COMP=ANSI;ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER;– this should be XCZECH we discussed previously First 3 screenshots are from setting up the DB where…

Oracle stop, start & restart

Po dlouhý době jsem se dokopal k prozkoumání dalších administračních úkonů v Oracle. Jak restartovat oracle na ruznych platformach … Jinak Oracle support nestoji za moc. I když s nima máme otevřeny 3 case tak se ke komunikaci moc nemaj.