![]() ![]() The / is mainly required in order to run statements that have embedded like CREATE PROCEDURE, CREATE FUNCTION, CREATE PACKAGE statements and for any BEGIN.END blocks. DBMSOUTPUT in Oracles SQL Developer In the tab Dbms Output choose: dbms-out-console-enable Chose the connection: dbms-out-select-connection Running a small. In this case one actually notices the error.īut assuming there is a SQL script like this: drop table foo Īnd this is run from within SQL*Plus then this will be very confusing: SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 18 12:38:05 2012 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production Can GPT 4 Prompt Itself MemoryGPT, AutoGPT, Jarvis, Claude-Next 10x GPT 4 and more.explain, run script) will be performed only for the selection. You can easily see that using a / after running a statement: SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 18 12:37:20 2012Ĭopyright (c) 1982, 2010, Oracle. I confirm that in Tools->Tool Properties, select the General->SQL Editor->Statement Delimiters > SQL Block Identifiers: Begin and End identifiers are -/ and. SQL Queries and PL/SQL with Oracle SQL Developer. So when you use a and a / the statement is actually executed twice. Same code also works in SQLDeveloper 4.0.3 and 4.1. Symptoms Below anonymous block fails on SQL Developer and SQLcl 17.2 and 4.2 whereas it is working fine on sqlplus. The ends a SQL statement, whereas the / executes whatever is in the current "buffer". Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Information in this document applies to any platform. ![]() I’m guessing your scripts are going to be a bit more complicated than mine, but this serves as a decent example to get you started. There is a huge difference in SQL*Plus between the meaning of a / and a because they work differently. The Anonymous Block is opened in a new SQL Dev page You can now step through the block, using watches and breakpoints as expected. Because of this reason PL/SQL anonymous blocks are useful for. I know this is an old thread, but I just stumbled upon it and I feel this has not been explained completely. We cannot save on the oracle database server due to this reason it is just for one-time use. ![]()
0 Comments
Leave a Reply. |