Worksheet enables you to create a worksheet, open or delete an existing worksheet, and save a worksheet. The SQL Worksheet toolbar contains icons for the following operations: When you hover over it, you see a pop-up displaying possible fixes for resolving the error.ĭescription of the illustration error_wrksheet.png Also, you can select multiple options in the list using Ctrl+Click.ĭescription of the illustration autocomplete_wrksheet.pngĪn error in the code is signified by a red dot or squiggle line. This list is based on the code context at the insertion point. If you press Ctrl+Space, the worksheet provides you with a list of possible completions at the insertion point that you can use to autocomplete code that you are editing. SQL keywords are automaticallyįor SQL*Plus and SQLcl statements supported in the worksheet, see Supported SQL*Plus and SQLcl Commands. Terminated with a slash (/) on a new line. Semicolon or (on a new line) a slash (/), and each PL/SQL statement must be Statements, each non-PL/SQL statement must be terminated with either a Inserting data, selecting data or deleting data from a table. You can use SQL and PL/SQL statements to specify actions such as creating a table, I am expecting here an option list of table names after I am type three or four letter of a table name.The SQL worksheet editor enables you to enter the SQL statements that However I am getting auto complete on table columns after I am using a "." following table name.ġ1. Run ALTER SESSION SET CURRENT_SCHEMA = ABC from XYZġ0.Follow step (7) and the intended output of step(7) is not getting from the IDE. I start typing emp (first 3 letter) and then IDE brings the rest in the option list and I can see EMP_TEST name in the option list and I can choose it from there.ĩ. I login PL/SQL with ABC credentials again and launch SQL windowħ. I grant all the privileges to XYZ of table EMP_TEST.Ħ. After creation I just run the select query multiple times on the same session (SELECT * FROM EMP_TEST)Ĥ. I created a table EMP_TEST on ABC schemaģ. My issue here is different,I will try to explain it through the simulation steps here,ġ. student ( I guess this is a user with a user icon to its left) TGT.student ( TGT is just another schema in my dB which has a table named student)ģ. STUDENT.student ( note that it shows me the schema name in upper case)Ģ. However, if I just type the schema name STUDENT (without the dot) then its Coding Assistant displays:ġ. The above test (altering session test) against Oracle's SQL*Developer: The Coding Assistant does not pop up after the dot. Inside the FROM clause the object preceding the dot is a schema not a table. The Coding Assistant pops up and correctly displays the objects belonging to KT schema.Īfter the dot, the Coding Assistant pops up and offers me a selection of column names of the table STUDENT. I issue the following command: ALTER SESSION SET CURRENT_SCHEMA = STUDENT In R13: From the SQL prompt I type: SELECT COUNT (*) FROM STUDENT.Īfter the dot, the Coding Assistant pops up and offers me a selection of dB objects belonging to schema STUDENT. The above test against Oracle's SQL*Developer: after the dot, the coding assistant shows all 4 objects (TEST, KT, OBJ and V_TBS) This time, the Coding Assistant pops up and offers me the selection: TEST, V_TBS and OBJ I start a Command Window in R13 and login as KT.įrom the SQL prompt I type: SELECT COUNT (*) FROM KT.Īfter the dot, the Coding Assistant does not pop up. Schema: STUDENT is the owner of dB objects: STUDENT, COURSE, GRADE. Schema: KT is the owner of dB objects: TEST (Table), KT (Table), V_TBS (View), OBJ (Procedure)
0 Comments
Leave a Reply. |