Home » SQL & PL/SQL » SQL & PL/SQL » External table Definitions (Oracle 9i)
External table Definitions [message #313447] Sat, 12 April 2008 08:17 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

When I create External table, I've defined some format definitions,

e.g.
AS_OF_DATE       CHAR date_format DATE mask 'dd/mm/yyyy'


In which database object these definitions are stored (Like USER_TABLES, USER_TAB_COLS)

Regards,
Brayan.
Re: External table Definitions [message #313449 is a reply to message #313447] Sat, 12 April 2008 08:25 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SQL Experts
Advanced Oracle SQL questions - Complex queries, DML and DDL statements. Newbies should not post to this forum!
Newbies should not post to this forum!
Newbies should not post to this forum!
Newbies should not post to this forum!
Newbies should not post to this forum!


Re: External table Definitions [message #313456 is a reply to message #313447] Sat, 12 April 2008 09:38 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
user_external_tables
all_external_tables
dba_external_tables
Re: External table Definitions [message #313457 is a reply to message #313447] Sat, 12 April 2008 09:51 Go to previous message
Brayan
Messages: 315
Registered: June 2002
Senior Member

Thanks a lot Barbara.

Brayan.
Previous Topic: Help on desired output
Next Topic: Mass Insert /Update /Delete
Goto Forum:
  


Current Time: Sat Dec 10 20:51:45 CST 2016

Total time taken to generate the page: 0.08718 seconds