Recent content by ILoveOracle

  1. I

    Switch between Editor and Dialog does not work anymore

    Hi, Go to: Tools > Preferences > Key Configuration, then select item "Edit / Next Tab Page" and press ALT-D (or ALT-E). Now you can switch between the Editor and the Dialog tabs with one single handy key combination!
  2. I

    Query Related to Describe table

    Hi, DESC [TABLE] is a SQL*Plus command and only works as a command in the Command Window, not in the SQL Window.
  3. I

    Compile Script packages

    I see. Well then I'm not sure that there is a solution in current version of PL/SQL Developer.
  4. I

    Compile Script packages

    Hi, You can use macros or template files (have a look into PL/SQL Developer's template subdirectory).
  5. I

    TermOut setting in Command Windows bug???

    Could you give an example of such a command file? Maybe I still don't understand, but if I run following command file: set termout off conn userX/passX@dbX set termout on select * from tableX; I get the expected result in PL/SQL Developer's command window v6.0.2 (as in SQLPlus): only the...
  6. I

    TermOut setting in Command Windows bug???

    Hi, According to the SQLPlus documentation : TERM[OUT] {OFF|ON} OFF suppresses the display of output from a command file ON displays the output. TERMOUT OFF does not affect the output from commands entered interactively. The command window too works exactly like this.
  7. I

    Forum search

    Hi, To save a query as a standard, click on the disk icon above the result pane of the SQL Window. When you then right-click on the table name in the editor a "Standard Query" menu option will show up in the contextual menu.
  8. I

    Bug ? Edit filemenu

    Hi, Go to menu option Tools / Preferences / User Interface / Key Configuration to configure the key shortcuts assignments
  9. I

    Upgrade Download

    Hi, Have a look here
  10. I

    How to manage Standard queries?

    Hi, You can delete/rename the files .[TABLE]..sq in the directory where standard queries are stored (see Files section in Preferences).
  11. I

    Export Data in Fixed Width Format

    Hi, Use the built-in RPAD Oracle function: select RPAD(firstname, 10, ' ') || RPAD(lastname, 10, ' ') || RPAD(dob, 10, ' ') from contact For syntax, see http://www.csee.umbc.edu/help/oracle8/server.815/a67779/function.htm#1025045
  12. I

    Wish list for Dev 6.0

    Yes, please leave the * ! Another means to get the list of all columns: drag and drop a table from the Object Browser into the SQL text pane and in the popup menu which then appears select option "Select". Regards
See more
Back
Top