Can I have select query with case statement in Package
Wheni run the sql query with case in normal sql editor its returning me results but when i try to add the query in Package and try to compile the [ackage its throwing error near case statement
It clearly says "The CASE expression was first added to SQL in Oracle8i. Oracle9i extends its support to PL/SQL to allow CASE to be used as an expression or statement"
Who is online
Users browsing this forum: No registered users and 2 guests