select e.getclobVal() from table name e;

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.

Question Posted / naren

Answer Posted / naren

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to display Row Number with Records in Oracle SQL Plus?

1092

Explain the difference between rename and alias?

1063

What is delimiter sql?

1058

What programs use sql?

1085

Does sap use sql?

1039

What is forward declaration in pl sql?

1139

What is left join in sql?

1091

What is rename command in sql?

1091

explain advantages of myisam over innodb? : Sql dba

1111

Do we need commit after truncate?

1134

What is foreign key and example?

981

what is commit? : Sql dba

1121

How to get list of all tables from a database?

1209

How many databases can sql express handle?

1028

Why are aggregate functions called so?

1012