RE: sql developer vs sqlplus sql and plsql syntax
Date: Mon, 14 Dec 2020 05:41:01 -0800 (PST)
Message-ID: <7728fb4e-f80a-49e9-bf22-a75db65539e2_at_default>
I would like to know why SQL Developer allow people to execute SQL code without semicolon and PLSQL code with backslash? (OK TOAD does the same thing but it is not made by Oracle)
For example code such as this works in SQL developer
- semicolon missing
select * from dba_users
- backslash missing
declare
l_a number;
begin
select 1 into l_a from dual;
end;
- backslash missing
create or replace procedure p_test
is
l_a number;
begin
select 1 into l_a from dual;
end;
This is causing some serious conflicts between DBA team and the developers because the developers write codes in SQL developer then they upload them as script for the DBA to run in the test/prod environment which all fails (and plsql objects not created) obecause DBA's uses SQLPLUS and because most SQL execution request are batched with SQLPLUS.
The developers claim if the code runs in SQL developer it must run in SQLPLUS because it is a tool from Oracle. Is there a way to configure SQL Developer so it can have the same behaviour as SQLPLUS?
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 14 2020 - 14:41:01 CET