Link to home
Create AccountLog in
Avatar of gram77
gram77Flag for India

asked on

Accessing sql*plus in oracle sql developer.

How can i access, sql*plus from oracle sql developer.

You can do this in pl/sql developer.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

I do not think you can.

SQL Developer has a SQL worksheet that sort of emulates sqlplus but I do not think you can 'shell out' and execute sqlplus.
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of gram77

ASKER

Many times i need to email the query used along with the results.

Sql*Plus gives a very good format of the query and it's results.

I can't copy the query from from worksheet and then copy data from the grid to do this.

So, i have to start a sql*plus session from command prompt to do the same which is combersome
I believe the sql worksheet will accept most, if not all, sqlplus commands.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of gram77

ASKER

good idea