Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] how to list all user's table content use dbms_metadata.get_ddl???

RE: [Q] how to list all user's table content use dbms_metadata.get_ddl???

From: Ian Cary (C) <Ian.Cary_at_ordnancesurvey.co.uk>
Date: Thu, 31 Mar 2005 15:30:11 +0100
Message-ID: <AB4FD5014A06414688019F9244194C66A5448B@EXCHMSA.ordsvy.gov.uk>


select dbms_metadata.get_ddl('TABLE',table_name,owner) from dba_tables
where owner =3D 'USER1'

This email is only intended for the person to whom it is addressed and may =
contain confidential information. If you have received this email in error,=
 please notify the sender and delete this email which must not be copied, d=
istributed or disclosed to any other person.
Unless stated otherwise, the contents of this email are personal to the wri=
ter and do not represent the official view of Ordnance Survey. Nor can any =
contract be formed on Ordnance Survey's behalf via email. We reserve the ri=
ght to monitor emails and attachments without prior notice.

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 31 2005 - 09:34:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US