Home » SQL & PL/SQL » Client Tools » SQL * PLUS
SQL * PLUS [message #266855] Tue, 11 September 2007 15:46 Go to next message
pa1sas3
Messages: 27
Registered: June 2005
Junior Member
This is in sql * plus.
How can we view and edit a stored procedure, function or a package in SQL * PLUS. I have been using toad all along and suddenly I have to modify a stored procedure and I have ooonly sql * plus here.
Re: SQL * PLUS [message #266856 is a reply to message #266855] Tue, 11 September 2007 15:52 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

just select the content of the procedure from user_source and spool it into a file. after that edit that spool file and run the file by adding create or replace procedure name.

Cheers
Soumen
Re: SQL * PLUS [message #266857 is a reply to message #266856] Tue, 11 September 2007 16:05 Go to previous messageGo to next message
pa1sas3
Messages: 27
Registered: June 2005
Junior Member
It would be helpful if you give the commands.

The procedure I want to edit is sp_validate_file_group2

Thanks,
Re: SQL * PLUS [message #266858 is a reply to message #266855] Tue, 11 September 2007 16:18 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>It would be helpful if you give the commands.
Is this another way of saying you don't know how to compose a simple SELECT statement?
If so, perhaps you should only use GUI based s/w such as Access.
Re: SQL * PLUS [message #266860 is a reply to message #266858] Tue, 11 September 2007 17:38 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

I am just giving you the select query:
select text from user_source where name='SP_VALIDATE_FILE_GROUP2';


For other things search in google for SQL*PLUS commands and do it yourself.

Cheers
Soumen
Re: SQL * PLUS [message #267018 is a reply to message #266855] Wed, 12 September 2007 04:55 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
pa1sas3 wrote on Tue, 11 September 2007 22:46
I have been using toad all along and suddenly I have to modify a stored procedure and I have ooonly sql * plus here.

I am going to print this out, frame it and hang it in my room!
Re: SQL * PLUS [message #267023 is a reply to message #266855] Wed, 12 September 2007 05:06 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Get yourself a copy of SQL Developer and use that instead. It's free, and does most of what TOAD does.
Re: SQL * PLUS [message #267032 is a reply to message #266855] Wed, 12 September 2007 05:20 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
pa1sas3
... suddenly I have to modify a stored procedure and I have ooonly sql * plus here.

Maybe it was just a bad dream! What happened when you woke up?
Re: SQL * PLUS [message #267081 is a reply to message #267018] Wed, 12 September 2007 07:59 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Frank wrote on Wed, 12 September 2007 04:55
pa1sas3 wrote on Tue, 11 September 2007 22:46
I have been using toad all along and suddenly I have to modify a stored procedure and I have ooonly sql * plus here.

I am going to print this out, frame it and hang it in my room!


LMA0 Frank. The good old days of vi editor and sql*plus
Re: SQL * PLUS [message #267090 is a reply to message #267081] Wed, 12 September 2007 08:14 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
hehe,

not necessarily the good ol' days, but at least we learned what it was we do, instead of learning where to click
Re: SQL * PLUS [message #267156 is a reply to message #267090] Wed, 12 September 2007 10:46 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

I am little disagree with MarcL & Frank.
In our days we also learned what we are doing by using SQL*PLUS or other tools.
But it is impossible to use SQL*PLUS or Vi editor for faster productivity environment and also for RAD(Rapid Application Development) for present days senario.
Sometimes we have to do the tasks what we don't want to do..so not necessary to use SQL*PLUS always but knowing the exact syntax to complete the job if necessary is important.

Cheers
Soumen
Re: SQL * PLUS [message #267376 is a reply to message #267156] Thu, 13 September 2007 02:24 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Where do I say that we should always use sqlplus & vi?
My point is that developers should at least for a period of time use sqlplus in combination with a plain-text editor.
Once they know what it is they are doing, then it's fine to use any GUI tool they want. Heck, I use PLSQL-Developer all the time. (But I _know_ where to find sqlplus and how to use it)
Previous Topic: Toad adding the schema name in fron of the procedure name
Next Topic: scroll page-wise in SQL Plus
Goto Forum:
  


Current Time: Sat Dec 10 03:14:10 CST 2016

Total time taken to generate the page: 0.13771 seconds