Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

how to retrive xml data for using sql query?

Question Posted / ksonga

Answer Posted / ksonga

SET VERIFY OFF
SET ECHO OFF
SET PAGES 0
SET LONG 100000
SET lONGCHUNKSIZE 10000
SET LINESIZE 200
select dbms_xmlgen.getxml('select * from emp') from dual

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Oracle

2337

What are a query and state the different types of queries and their uses?

978

What would you do with an in-doubt distributed transaction?

1949

Describe an oracle table?

1011

What are the extensions used by oracle reports?

1016

Explain about integrity constraint?

1095

Is postgres faster than oracle?

988

How to rename an index?

1029

What are the limitations oracle database 10g xe?

1002

What is instant client oracle?

994

How to create a table in a specific tablespace?

931

In oracle there is column command, how will you explain that?

1000

How to loop through data rows in the implicit cursor?

1036

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2527

What is the order of defining local variables and sub procedures/functions?

1032