OraFAQ Forum: SQL & PL/SQL » How to create scripts and run

Home » SQL & PL/SQL » SQL & PL/SQL » How to create scripts and run

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to create scripts and run [message #1056]

Tue, 26 March 2002 01:41

Mufaddal
Messages: 4
Registered: March 2002

Junior Member

I want to know , How to create scripts in oracle

Report message to a moderator

Re: How to create scripts and run [message #1058 is a reply to message #1056]

Tue, 26 March 2002 04:19

Epe
Messages: 99
Registered: March 2002

Member

Hello,

you need to make a script in PL/SQL.

(If you don't know PL/SQL : it can be written in any editor (even notepad). For PL/SQL syntax, check the Oracle Manuals (http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/toc.htm) or buy a book. Don't worry, PL/SQL is really not that difficult)

Once the script is written, you can execute it in SQL+ by typing :
SQL> @directory-path/scriptname

Report message to a moderator

Previous Topic:	change to a different line using chr(10) when "select"
Next Topic:	date calculations

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 16:09:23 CDT 2024