Hi members,
I just came across some PL/SQL package using some notation which I have never seen before, nor can find in PL/SQL reference. It is use of $ (In a conditional statement)
Here's an example:
SQL> create or replace procedure p as
begin
$if 1 = 1 $then
dbms_output.put_line ('Why can we use dollar sign?');
dbms_output.put_line ('And no END IF??');
$end
end p;
Procedure created.
SQL> show errors
No errors.
SQL> exec p
Why can we use dollar sign?
And no END IF??
PL/SQL procedure successfully completed.
SQL> show release
release 10.2.0.3.0
Just wondered what that really is, and why would one wanna do that? - Is it some old style Pl/SQL, or?
P.S: Package was written in 1997
Best regards
Peter