Sql query help required [message #2051] |
Wed, 19 June 2002 04:02 |
Sati
Messages: 3 Registered: June 2002
|
Junior Member |
|
|
I need to select a range of data, save it amend the data and then use it to run the next query.
eg
SELECT table_name,column_name
FROM user_tab_columns
WHERE nullable = 'N';
I want to save this info and edit it to remove tables that I do not require and then run a command to alter the tables so that a null can be entered. ie set nullable to Y. The bit I'm struggling with is how to save the info and run my second query from that data.
Can anyone advise me how to do all of this.
|
|
|
Re: Sql query help required [message #2198 is a reply to message #2051] |
Thu, 27 June 2002 03:46 |
Niranjan
Messages: 34 Registered: June 2001
|
Member |
|
|
before firing the upper query
type command
sql>spool yrchoice.txt
then fire your query
the o/p of your query will get stored in file yrchoice.txt
then open this file in notepad for your reference.
|
|
|