This discussion is archived
1 Reply Latest reply: Nov 5, 2012 5:22 AM by Jeff Smith SQLDev PM RSS

Newbie in SQL Developer: misc questions

971909 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points