Home » SQL & PL/SQL » SQL & PL/SQL » Finding out if column has default value associated
Finding out if column has default value associated [message #211] Mon, 28 January 2002 23:44 Go to next message
Mihir D. Gore
Messages: 1
Registered: January 2002
Junior Member
How can you find out if a column has a default value associated with it? I am using oracle 8i, and by using the DBA studio i am able to get this information, but how can i get this info at the SQL prompt?

Report message to a moderator

Re: Finding out if column has default value associated [message #212 is a reply to message #211] Tue, 29 January 2002 01:17 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

try this

select table_name,column_name
from user_tab_columns
where data_default is not null;

Hope it helps!!!

cheers
pratap

Report message to a moderator

Previous Topic: group error
Next Topic: Plz tell the way to find/monitor open cursors on Oracle8/8i.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

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