Satish Shrikhande

Greenhorn
+ Follow
since Jul 27, 2006
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Satish Shrikhande

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:7490088329317

Check the link .
For Oracle 9i
select dbms_metadata.get_ddl( 'TABLE', 'EMP' ) from dual;
For Oracle 8 .. you have to use export , import utility to get the structure and its pain in ass .

I suggest you to use PLSQL Developer third party to make your job easy .
17 years ago