How to open PL/SQL editor ???

Go down

How to open PL/SQL editor ???

Post by praveen on Tue Mar 23, 2010 5:42 pm

Hello Everyone.....

Cab anyone tell me , How to work on PL SQL ... hw to open the editor or where to type the prog ?????

can we do that in Putty ???????


Thanx in advance
avatar
praveen

Posts : 7
Points : 13
Join date : 2010-03-03
Age : 30
Location : Haldia

View user profile http://www.praveenbob.blogspot.com

Back to top Go down

Re: How to open PL/SQL editor ???

Post by abhisheksingh on Tue Mar 23, 2010 6:29 pm

use the following command

define_editor=vi (press enter)

ed file_name.sql;

now u can edit it as in UNIX..
avatar
abhisheksingh

Posts : 10
Points : 117
Join date : 2010-03-09
Age : 31
Location : Haldia

View user profile

Back to top Go down

hw to run it

Post by praveen on Wed Mar 24, 2010 11:11 am

Dude....

hw to run the prog ..???
avatar
praveen

Posts : 7
Points : 13
Join date : 2010-03-03
Age : 30
Location : Haldia

View user profile http://www.praveenbob.blogspot.com

Back to top Go down

Re: How to open PL/SQL editor ???

Post by Christopher on Wed Mar 24, 2010 11:14 am

at the end of the file, append '/'. then to run the procedure, use "@<filename>" in sql prompt.
avatar
Christopher
Admin

Posts : 240
Points : 429
Join date : 2010-02-26
Age : 30

View user profile http://unixcpp.forumotion.com

Back to top Go down

Re: How to open PL/SQL editor ???

Post by praveen on Wed Mar 24, 2010 12:00 pm

Dude.. It is working ....

but

it is nt working fr

dbms_output.put_line....

any idea abt this ???
avatar
praveen

Posts : 7
Points : 13
Join date : 2010-03-03
Age : 30
Location : Haldia

View user profile http://www.praveenbob.blogspot.com

Back to top Go down

Re: How to open PL/SQL editor ???

Post by abhisheksingh on Wed Mar 24, 2010 12:08 pm

at the begining of ur prog add the follwing

set serveroutput on;

or just type this command at the terminal.
avatar
abhisheksingh

Posts : 10
Points : 117
Join date : 2010-03-09
Age : 31
Location : Haldia

View user profile

Back to top Go down

Re: How to open PL/SQL editor ???

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum