Home » SQL & PL/SQL » SQL & PL/SQL » Data dictionary into a temp table
Data dictionary into a temp table [message #19288] Fri, 08 March 2002 10:19 Go to next message
eviloutsider
Messages: 1
Registered: March 2002
Junior Member
How would I write a single query that will create a temp table that is a duplicate of the FieldDefinitions table?

Report message to a moderator

Re: Data dictionary into a temp table [message #19291 is a reply to message #19288] Sat, 09 March 2002 04:56 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
create table field_definition as
select * from all_tab_columns;

Report message to a moderator

Previous Topic: import data in excel sheet to oracle
Next Topic: import data in excel sheet to oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 14:24:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.