A few questions from a newbie ...

[WorknMan]

Hello all,

Just started in a new position at work where I am brand new to it. I have a few questions for version 7.1 (we haven't upgraded to v8 yet):

- I see there is a 'commandfile' command-line switch to open up a .sql script in a command window. For my purposes, it would be more useful if I could open such a script in an SQL window. Is there a way to do this?

- Is it possible to have the object browser NOT show up when the program starts? I don't need it 98% of the time, so I close it, but when I launch the program next time, it comes back.

- If I right click on a table in the object browser and click 'View', I get a nice tabbed view of the tables properties. Is there a way I can pull this up from a SQL window, or some other way so that I don't have to drill my way down the object browser to get to the table if I already know the table name?

Any help would be appreciated

 

[Marco Kalter]

I see there is a 'commandfile' command-line switch to open up a .sql script in a command window. For my purposes, it would be more useful if I could open such a script in an SQL window. Is there a way to do this?

Yes, you can open a SQL script in the SQL Window as well (File > Open > SQL Script). Note however that the SQL Window does not support SQL*Plus commands like "describe", "prompt", and so on.

Is it possible to have the object browser NOT show up when the program starts? I don't need it 98% of the time, so I close it, but when I launch the program next time, it comes back.

You can configure the desktop layout and then go to the Window menu and select "Save Layout". You can also enable the "Autosave Desktop" option (Tools > Preferences > User Interface / Options).

If I right click on a table in the object browser and click 'View', I get a nice tabbed view of the tables properties. Is there a way I can pull this up from a SQL window, or some other way so that I don't have to drill my way down the object browser to get to the table if I already know the table name?

If you right-click on a table name in an editor you get the exact same object popup menu as from the Object Browser.

 

[WorknMan]

Yes, you can open a SQL script in the SQL Window as well (File > Open > SQL Script). Note however that the SQL Window does not support SQL*Plus commands like "describe", "prompt", and so on.

Is there any way to do that from the command-line? Eg: Pass in a sql script as a parameter when you launch the program and have it automatically open/execute in a sql window, as opposed to the command window?

Thanks, for the help, btw

 

[Marco Kalter]

There is no command-line option to open and execute a SQL Window.

However, you can edit the AfterConnect.sql file in the PL/SQL Developer installation directory to execute SQL and PL/SQL commands for each session that is created in PL/SQL Developer.