Recent content by Quantum

If you have a schema which has a table with the same name as the schema, then executing a procedure will fail if you qualify the procedure with the schema name. Execution is successful only after the table is dropped. This is what I get: KT@ETL> select * from tab; TNAME TABTYPE...

Both windows are Command windows (Editor tab) I just tested the behaviour between SQL Window and Command Window. It doesn't happen on the SQL Window. Only the Command Window is affected and it occurs on Editor Tab as well as Dialog Tab.

In R11 or in R13 Open 2 multi-pages scripts, side by side. Note where the cursor is in both scripts (for example line 1) While Script A has the focus, click on the title bar window of Script B. Use the mouse wheel or the vertical scroll bar to scroll several pages down (cursor is still on line...

Test 1 I set my R13 to make no connection at start up: 1 In Define Connections window (under Imported Fixed Users in my case) make sure no Connection is checked: Uncheck Connect on Startup 2 Use Log off button in Session ribbon and select All 3 Close all windows (so that they won't reopen...

In my gLogin.sql I have: SET SERVEROUTPUT ON SIZE UNLIMITED Initially (when a Command Window is opened and connected) the setting is respected, but when I disconnect and reconnect I have to manually execute the SET SERVEROUTPUT command for dbms_output to display its output. Is there a way to...

In R13 I open a window (Command, SQL Window, ...) and then I enter: SELECT owner, synonym_name, table_owner, table_name FROM dba_synonyms WHERE synonym_name IN ('v$session', 'v$sesstat', 'v$statname'); Using the mouse I select the strings 'v$session', 'v$sesstat', 'v$statname' (including the...

Given the following: Schema: KT is the owner of dB objects: TEST (Table), KT (Table), V_TBS (View), OBJ (Procedure) Schema: STUDENT is the owner of dB objects: STUDENT, COURSE, GRADE,... (all tables) I start a Command Window in R13 and login as KT. From the SQL prompt I type: SELECT COUNT (*)...