![]() If there are more thanĬreate a PL/SQL object type. ![]() The SQL toolbar contains icons for the following operations: Size, Word wrap, Ruler, Line numbers and so on. Some of the code editor options that you can customizeĪre Theme (Light, Dark and High contrast dark), Font size and family, Tab Preferences option available in the top-right ![]() You can set code editor preferences using the This feature is available only if you have theĭescription of the illustration error_sql_worksheet.png The values in the drop-down list match the database services available whenĬonnecting to the database. For more details,įor SQL*Plus and SQLcl statements supported in the worksheet, see Supported SQL*Plus and SQLcl Commands.ĭrop-down list to select the consumer group to run your SQL or PL/SQL code. Multilingual Engine syntax in Oracle Database release 21c. The JavaScript worksheet mode supports the Is detected, along with a link to go to the relevant position in the code Output includes details such as the specific line and column where the error ![]() ThisĮditor helps you detect errors in your PL/SQL code during compilation. The following object types: Functions, Procedures, Packages and Types. The PL/SQL editor is triggered when opening Each PL/SQL statement with a slash (/) on a new line.Each non-PL/SQL statement with either a semicolon ( ) or a slash (/) on.SQL keywordsĪre automatically highlighted. Inserting data, selecting data, or deleting data from a table. You can enter SQL and PL/SQL statements to specify actions such as creating a table, The main features include in-context codeĬompletion, syntax highlighting, and error debugging. The code editor in the SQL page enables you to run SQL statements,
0 Comments
Leave a Reply. |