i want know querys of third party software executed in my oracl开发者_StackOverflow中文版e server, anybody know how i can do that?i will use one time, can be trial software or script anything..thxoras
Does SQLPlus provide the help pages for its commands? Is there a way to access the help text from the 开发者_C百科SQLPlus prompt, like this text for STARTUP?
I have a VB.Net application that populates an Oracle 11g global temporary table. I can see data in the temporary table by loading it into a grid and everything looks correct.
There are parameterized error messages in Oracle database. For example, there is 01919, 00000, \"role \'%s\' does not exist\" in oraus.msg.
I have registered one XSD in ora开发者_如何学JAVAcle XMLDB. Also I have annotated one element as a CLOB as shown below.
When this code is executed in SQL Developer against Oracle 11g I get an error, begin dbms_scheduler.create_job(
we have a dot net application and it connecting to Oracle and fet开发者_运维知识库ching data and moving to SQL server. it was working very fine. just started giving error ORA-12560: TNS:protocol adapt
In my DB, I store various version numbers, like the following : OBJNAME Fix_6.0.0a.1 Fix_6.0.0a.2 I would like to sort them not according to last version element (the number behind the last . chara
I may be asking something silly but I don\'t see any sql*plus or any GUI kind of interface to connect my Oracle server remotely. I tried SQL Pl开发者_如何学JAVAus but it\'s a command line interface, d
In Oracle how do I convert a \"timestamp with time zone\" to the current time zone of the server? I need to dynamically figure out what the current time zo开发者_如何学JAVAne of the server is.