OK, I started out thinking that this would be easy.
What is a pure SQL solution which generates a results set
containing a list of TABLE_NAME, COLUMN_NAME for all
NOT NULL columns in a schema?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Charlie - Does this sound like what you want?
1 select table_name, column_name
2 from user_tab_columns
3* where nullable = 'Y'
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 3:55
Title: RE: List TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema
SELECT table_name,column_name
FROM user_tab_columns
WHERE nullable = 'N';
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 1:55 PM
To: Multiple
The following generates it for the entire database.
select owner, table_name, column_name
from dba_tab_columns
where nullable = 'N'
order by owner, table_name, column_id
For a single schema just add:
andowner = 'schemaname'
to the where clause. If you want change the = to in and use a