I have stored procedure which executes another stored procedure several times. I need union and return data, which I have after executing second procedure.
I would like to do an INSERT / SELECT, this means INSERT in the TARGET_TABLE the records of the SOURCE_TABLE, with this assumption:
As the title suggested , I am looking for a function in pl /sqlwhich does something similar like the Date开发者_开发百科Add function.
I just wanna to change in this XML (contained in XMLTYPE variable) all nodes named \"ChildNode\" with \"Name\"=\"B\" attribute values to \"C\":
How to invoke a webservice through pl/sql block for which we know url,username and password. And how to see the response?
Any idea to run those kind of scripts from Oracle PL开发者_开发知识库/SQL? Any solution would be appreciated. Thanks!I would guess it is more often the other way around, calling the database from SAS
Hey guys, I need to figure out a way to back up and also migrate our Oracle database from our production schema to the dev schema and the other way around.
I need to pass an array from C#.net application to oracle stored procedure. 开发者_开发知识库Can anyone please let me know how to go about it?
select col1 from tab开发者_StackOverflowlename returns 2 rows, I want to concat these two data rows into a single column separated by a comma.You can write a cursor to loop through the returned rows
Most SQL developers know and 开发者_如何学编程use Narayana Vyas Kondreddi\'s sp_generate_inserts from http://vyaskn.tripod.com/code/generate_inserts.txt
加载中,请稍侯......