sql script [message #1365] |
Wed, 24 April 2002 07:42 |
Mufaddal
Messages: 4 Registered: March 2002
|
Junior Member |
|
|
I want to know how to write sql scripts
please give full details
|
|
|
Re: sql script [message #1371 is a reply to message #1365] |
Wed, 24 April 2002 08:00 |
motiram
Messages: 21 Registered: January 2001
|
Junior Member |
|
|
SQL script is anything that you write in a .sql file.
For example if you want to do
select * from abc_table where abc = xyz;
If you are using unix machine, you can say
vi abc.sql or emacs abc.sql
set head off
set linesize 80
select * from abc_table where abc = xyz;
If you want output of this sql into a file..you can do:
set head off
set linesize 80
spool abc.lst
select * from abc_table where abc = xyz;
spool off
|
|
|
Re: sql script [message #1373 is a reply to message #1365] |
Wed, 24 April 2002 08:02 |
motiram
Messages: 21 Registered: January 2001
|
Junior Member |
|
|
SQL script is anything that you write in a .sql file.
For example if you want to do
select * from abc_table where abc = xyz;
If you are using unix machine, you can say
vi abc.sql or emacs abc.sql
set head off
set linesize 80
select * from abc_table where abc = xyz;
If you want output of this sql into a file..you can do:
set head off
set linesize 80
spool abc.lst
select * from abc_table where abc = xyz;
spool off
|
|
|