Hi
How can I make NULLs come first in query output?
Oracle puts'em to the end of the list, I need
right opposite. I don't want to use NVL since it
will affect performance.
Neither I can use DESC since I need regular sorting
order for non-NULLs.
Any ideas?
Thanks a lot
Dmitri Issanov
Hi
I have troubles putting Oracle MTS (Multi-Thread
server mode) to work with MS Transaction Server.
I run Oracle 8.1.6 on Solaris 7, Oracle Services
for MTS 8.1.6.1 (patched). When Oracle runs in
dedicated mode, thins go fine. Once I set it to
shared server mode, all distributed transactions...
Hi
I have an application working with Oracle database,
and I don't have access to source code.
Some transactions fail but this app doesn't generate
any logs.
How can I trace errors occuring while executing
SQL statements, session initialization, etc?
All I need is to get ORA error number and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.