SQL statements can be generated automatically from the Database Browser, loaded from scripts, or entered manually.
To generate SQL SELECT statements from the Database Browser, do one of the following:
•Click a database object (such as a table or view), or a folder, in the Database Browser and drag it into the SQL Editor.
•Right-click a database object in the Database Browser and select Show in SQL Editor | Select.
To create SQL statements manually:
1.Start entering the SQL statement in the SQL Editor. If autocompletion is set to occur automatically, a drop-down list with suggestions appears while you enter statement.
2.Use the cursor Up and Down keys to select a suggestion, and then press Enter to insert the highlighted option (see also SQL Auto-Completion Suggestions).