Difference between revisions of "SQLDeveloper stuff"

From The University of Akron Support Wiki
Jump to: navigation, search
(Thing 2)
(SQL Developer Stuff)
Line 1: Line 1:
== SQL Developer Stuff ==
+
== Preferences ==
  
=== Thing 1 ===
+
=== Setting line numbers ===
 +
You can have Oracle SQL*Developer display a line number beside all SQL statements. Click on TOOLS>PREFERENCES, then expand CODE EDITOR and then select LINE GUTTER. You can check SHOW LINE NUMBERS and voila you have line numbers beside your SQL and you no longer have to count the line numbers to find the SQL in error.
  
=== Thing 2 ===
+
=== Setting Date/Time Parameters ===
 +
You can set how you want to view date and time information by
 +
# clicking on Tools | Preferences
 +
# Open the Database Tree
 +
# select NLS parameters
 +
If you want dates to display like you're used to in DB2, enter YYYY-MM-DD-HH24.MI.SS for the date format
 +
 
 +
=== Auto commit ===
 +
You can set how you want to view date and time information by
 +
# clicking on Tools | Preferences
 +
# Open the Database Tree
 +
# select Worksheet parameters
 +
# Check on the Autocommit in SQL Worksheet box
  
 
[[Category:PSV9]]
 
[[Category:PSV9]]

Revision as of 20:35, 9 April 2008

Preferences

Setting line numbers

You can have Oracle SQL*Developer display a line number beside all SQL statements. Click on TOOLS>PREFERENCES, then expand CODE EDITOR and then select LINE GUTTER. You can check SHOW LINE NUMBERS and voila you have line numbers beside your SQL and you no longer have to count the line numbers to find the SQL in error.

Setting Date/Time Parameters

You can set how you want to view date and time information by

  1. clicking on Tools | Preferences
  2. Open the Database Tree
  3. select NLS parameters

If you want dates to display like you're used to in DB2, enter YYYY-MM-DD-HH24.MI.SS for the date format

Auto commit

You can set how you want to view date and time information by

  1. clicking on Tools | Preferences
  2. Open the Database Tree
  3. select Worksheet parameters
  4. Check on the Autocommit in SQL Worksheet box