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 ...
Home/Database
Oraask Latest Questions
Question
Question
How to find the session that consuming high temp tablespace in oracle database
Question
What are normalization and denormalization and why do we need them?
Question
What is the difference between Implicit and Explicit Cursor in Oracle?
Question
What are the different types of case manipulation functions available in Oracle SQL?
Question
can someone tell me how many triggers can I create on a single table in Oracle Database?
Question
What is the difference between Rownum and Rowid in the Oracle database?
Question
Could someone please explain why do we use a nested table in Oracle?
Question
How do I find SQL server port number?
Question
How do I add a new column in Oracle SQL?