Home » SQL & PL/SQL » SQL & PL/SQL » How to know the datatype?
How to know the datatype? [message #19889] Tue, 16 April 2002 12:25 Go to next message
Arnab Dey
Messages: 6
Registered: April 2002
Junior Member
How can I know the datatype from the data itself? Is there any built in function with SQL itself?

Report message to a moderator

Re: How to know the datatype? [message #19890 is a reply to message #19889] Tue, 16 April 2002 17:43 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The datatype can only be obtained from the data dictionary (user_tab_columns or the dba or all equivalents).

Report message to a moderator

Previous Topic: Urgent: Deleting using joins on 2 tables
Next Topic: Using DBMS_SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 21:05:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.