Home » SQL & PL/SQL » SQL & PL/SQL » Print code for a query
Print code for a query [message #257409] Wed, 08 August 2007 05:17 Go to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
Could anyone help me out on this?

I wish to know how to display the code that I have written for creating tables, its indexes etc.

for e.g.

I have created a table path with tables
TC_COMPANY_ID
PATH_SET_ID
PATH_ID
IS_BASE_PATH
IS_MAIN_LEG
DOW_BITS

Now I wish to see the below code after running the required query.

CREATE TABLE PATH
(
TC_COMPANY_ID NUMBER(8),
PATH_SET_ID NUMBER(8) NOT NULL,
PATH_ID NUMBER(8) NOT NULL,
IS_BASE_PATH NUMBER(1),
IS_MAIN_LEG NUMBER(1),
DOW_BITS NUMBER(4) NOT NULL
);

Would really appreciate help out on this...

Thanks...

[Updated on: Wed, 08 August 2007 08:11] by Moderator

Report message to a moderator

Re: Print code for a query [message #257412 is a reply to message #257409] Wed, 08 August 2007 05:23 Go to previous messageGo to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
please ignore the smileys...
Re: Print code for a query [message #257427 is a reply to message #257409] Wed, 08 August 2007 06:10 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
look at dbms_metadata.get_ddl
Previous Topic: Finding database objects
Next Topic: connect by query
Goto Forum:
  


Current Time: Wed Dec 07 18:18:58 CST 2016

Total time taken to generate the page: 0.08022 seconds