i have xml source. xml source having lacks of records. i
want extract/retrive xml source data using sql query.
please tell me how to write query.

Answer Posted / naren

select e.getclobVal() from table name e;

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to select first 5 records from a table? : Sql dba

693


How do you modify a table in sql?

800


Is nosql faster than sql?

744


What is composite data type in pl sql?

764


What is a table partition?

785






What is the basic form of sql query?

679


What is db journal file?

675


How can I see all tables in sql?

727


How to add a column ‘salary’ to a table employee_details?

768


What is a sql schema used for?

726


How to call shell script from pl sql procedure?

843


What is data manipulation language?

877


What is the clause we need to add in function body to return variable?

758


How to check if a column is nullable before setting to nullable?

768


what are the nonstandard string types? : Sql dba

803