Help to write SQL scripts please. [message #10839] |
Thu, 19 February 2004 17:04 |
mmm101
Messages: 5 Registered: February 2004
|
Junior Member |
|
|
Hi,
I have a good knowledge of Oracle SQL Plus and I want to start writing SQL scripts. But I couldn't find any tutorial for writing SQL scripts. I want to know the step by step instructions/commands of how to write, execute/run the scripts. Please I need the info ASAP. Please help....
|
|
|
|
Re: Help to write SQL scripts please. [message #10858 is a reply to message #10840] |
Fri, 20 February 2004 08:38 |
mmm101
Messages: 5 Registered: February 2004
|
Junior Member |
|
|
Hi,
Thanks for the informations. I tried to open the editor by typing ed filename in the sqlplus worksheet, but nothing happened. Could you please tell me where should I give the command? But I could run the file from SQLplus worksheet by giving @ filename. Thanks.
|
|
|
|
Re: Help to write SQL scripts please. [message #10874 is a reply to message #10862] |
Sat, 21 February 2004 07:35 |
mmm101
Messages: 5 Registered: February 2004
|
Junior Member |
|
|
Yes. It might sound funny to you. I have learnt Sql plus from the books and known almost all the statements and functions...But I don't have any realtime experience. That's why I didn't know the commands. Now I got them. Sorry if it bothered you....
|
|
|
|
Re: Help to write SQL scripts please. [message #10876 is a reply to message #10874] |
Sat, 21 February 2004 08:21 |
William Robertson
Messages: 1643 Registered: August 2003 Location: London, UK
|
Senior Member |
|
|
mmm01,
I wasn't laughing at you, and I apologise if it sounded that way. I just wasn't sure what you meant. SQL is a language for expressing database queries; SQL*Plus is a text browser application, which can be used for scripting. Sometimes people know SQL but are not familiar with SQL*Plus. However it sounds like you are teaching yourself about SQL*Plus but need more information about writing and running scripts.
|
|
|
Re: Help to write SQL scripts please. [message #10877 is a reply to message #10876] |
Sat, 21 February 2004 09:21 |
mmm101
Messages: 5 Registered: February 2004
|
Junior Member |
|
|
Hi William,
Now only I realize that I confused SQL and SQL plus in my question. The one you've specified as "you are teaching yourself about SQL*Plus but need more information about writing and running scripts" is correct and I am comfortable with SQL and SQL plus which I learnt in my college a few years ago. So, I forgot quite a lot of commands in SQLPLUS and I needed some informations from any websites to brush up my mind and also about the SQL scripts. Thanks a lot for cosidering my question.
|
|
|