COMMAND LINE for generating script for oracle table

[Mai Phuong]

Hi all,

I am using Oracle_OraClien t11g and PL/SQL developer. I am finding a COMMAND LINE of DOS to generate a script.sql. That means the COMMAND LINE will be sth as following:

_ Input: name of table

_ Output: file sql.script

I think I can find such a COMMAND LINE like that in "..\product\11. 1.0\client_1\BI N" or "\product\11.1. 0\client_1\LIB" . However, I have not found anything like that.

Have you got any suggestion for me?

Thank you so much!

[magicwand]

set heading  off
set showmode off
set feedback off
set define   on
set verify   off

set long 1000000
set pagesize 9999
set linesize 150

undefine TNAME
undefine FNAME

accept TNAME prompt "Enter table name : "
accept FNAME prompt "Enter file name  : "

spool &FNAME
select dbms_metadata.get_ddl('TABLE',upper('&TNAME')) "CREATE Statement" from dual;
spool off
exit

Save the script as i.e. cr_tbl.sql an run as:

sqlplus -s <username>/<pwd>@<dbconn > @cr_tbl

[Mai Phuong]

thank you. I did it.