I have written PL/SQL code to store XML into cursor. Refer the below code Requirement: As of line at line 83, I am inserting the result into another table (XML_GEN) as XMLTYPE datatype. Line: insert into xml_gen (fxdoc) values (i.FXML); But ...
Oraask Latest Questions
How to know the queries running for x minutes or y seconds in Oracle database
How to find the session that consuming high temp tablespace in oracle database
Which one is better to use?? Blob or directory and bfile in Oracle for storing images
I have a table "Orders" and needs to retrieve all it's column names using an sql query. I know how to describe a table but i don't want it from describe I want to list them using SQL ...
What are normalization and denormalization and why do we need them?
What is the difference between Implicit and Explicit Cursor in Oracle?
What are the different types of case manipulation functions available in Oracle SQL?
What is the use of ADD, DROP and MODIFY Commands?
What are the differences between SQL and PL/SQL in Oracle?