1 Reply Latest reply: Nov 5, 2012 7:22 AM by Jeff Smith Sqldev Pm-Oracle RSS

    Newbie in SQL Developer: misc questions

    971909
      Hello,

      I´m new to SQL Developer, always worked with Quest´s SQL Navigator before.

      1.)
      I have a file.sql with following instructions:

      begin
      package_1.variable_1:='T';

      package_2.procedure_1;

      package_2.procedure_2;

      package_2.procedure_3;

      end;

      In Quest SQLNavigator I started this with "Run (F9".
      In SQL Developer this will not start, always telling me error, invalid numbers or some other sh*t, but nothing changed within the packages or procedures.
      With SQLNavigator everything works fine.


      2.)
      In SQLNavigator with "Quick Browse" I get the sql for a table, for example

      select a.col1, a.col2, a.col3, ...
      from quickbrowsedtable a

      How can I get this in SQL Developer ?


      3.)
      When extracting DDL in SQL Developer columns and table names are in double quotes. Can I change
      this to have no quotes at all ?



      Thank you very much for your help,
      greets,
      Frank

      Edited by: 968906 on 05.11.2012 04:49