Hi ,
i am sorry for posting such simple sql statement but i simply still dun quite get the hand of how PL/SQL works and i apprecaite ur patience
i ran this statement :
declare
mydate date ;
mydate := sysdate ;
select mydate;
the error is :
ORA-06550: line 3, column 8:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref
char time timestamp interval date binary national character
nchar
i think line 4 can be replace with --> dbms_output.put_line(mydate);
but i dun unserstand where line 3 has gone wrong
pls advise
tks & rdgs