This feature often provides help for entering SQL keywords, table names, column names, and so on. When you enter SQL statements, you'll notice that SQL Developer automatically displays a drop-down list that helps you enter SQL statements. This makes your statements easier to read and understand and can help you identify coding errors. For example, keywords are displayed in blue. As you enter statements, you'll notice that SQL Developer automatically applies colors to various elements.
Once you open a SQL Worksheet, you can use standard techniques to enter or edit a SQL statement. But first, if the connection hasn't been used in the current session, you may be prompted to enter the password for the connection. This opens a Worksheet for that connection. Then, you can select the connection you want to use. First, you can click on the arrow to the right of this button to display all connections. The easiest way to open a SQL Worksheet window is to use the drop-down list that's available from the Open SQL Worksheet button on the toolbar.
How to enter and execute a SQL statementįigure 2-8 shows how to use the SQL Worksheet window to enter and execute a SQL statement.
How to use the Oracle Database SQL Reference manualīesides letting you review the design of a database, SQL Developer is a great tool for entering and running SQL statements.How to use SQL Developer to run SQL statements.How to view and edit table column definitions.How to use SQL Developer to work with an Oracle database.How to work with an Oracle database home page.