Hi,
Im getting the rest of line ignored error while deploying the script in SQL plus. I have post a sample query as below.
Query:-
select
a.first_name,
a.last_name,
a.emailid,
b.depatno,
b.deptname
from employees a,
department b
/*where clause*/
where a.deptid = b.deptid
and length(a.first_name) > 10;
Error :-
02:18:18|INFO> SP2-0734: unknown command beginning "where a.deptid..." - rest of line ignored.
02:18:18|INFO> SP2-0734: unknown command beginning "and length(a.fi..." - rest of line ignored.
02:18:18|INFO> SP2-0044: For a list of known commands enter HELP
02:18:18|INFO> and to leave enter EXIT.
Is this occuring because of blank lines in between the SQL query or due the comment lines in between the query ????
Please advise.
DB : Oracle 12C