how to load query

[bhavin12300]

hi i am new suer of this forum.
i need your help.
i want to load query which is written in notepad in to oracle 8i.
how to do that please help throughtout this

 

[KenCunningham]

Can you give us the OS details, please? Could the query be ftp'd to the server as query.sql and run from a sqlplus prompt? More details please.

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[LKBrwnDBA]

Start>All Programs>Oracle8i>Application Development>SQL*Plus

Login to database.

Copy and paste query from Notepad into SQL*Plus

Then from SQL*Plus you can save the query.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[ddiamond]

What exactly do you mean "load" your query into oracle? If you simply want to run it from oracle, SQL*Plus is a good option as mentioned by Ken and LKBrown. If you actually want to store your query on oracle itself, then you must inbed it in a view or stored procedure.

 

[SantaMufasa]

BHavin,

You mentioned that the query is in Notepad. So, in Notepad, you click File -> Exit -> Save As "C:\MyScripts\BHavin.sql". Then, from SQL*Plus, at the SQL> prompt, you can say:

SQL> @c:\myscripts\BHavin

The above will execute the commands that appear in your file "BHavin.sql" that resides in the folder C:\myscripts.

Let us know if this resolves your need.



Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[bhavin12300]

thansk you so much guys .
i really appericiate you my problem is sloved thank youuuuuuuuuuuuuuuu