Thanks David, worked just fine :-)
I have update the block and it's compiling just fine, but the output is still not correct, appreciate any help
I am trying to write a if-else sql block as below :
SELECT TO_CHAR(SYSDATE,'DAY') INTO...
I tried using below case statement, but it isn't working :
when to_char(sysdate,'DAY') in ('SUNDAY','THURSDAY') then 'select...
Thanks for the post, but my requirement is slightly different (apologies for not providing enough clarity on the first post), the...
I have this requirement where I have to execute a sql query based on output of another query, something like given in example below :...
Thank you Guys.
Just one more thing.
Is this rule confined to query with "Exist" condition only or it's SQL standard.
Yes it does have, both outer and inner query is alias of same table i.e "emp"
Below query is working just fine :
I am trying to write a query to display information about employees who have one or more coworker in their departments with later...
Thanks, it's now fine.
This seems to be pretty simple but I don't know what am I doing wrong as I am not getting correct output.
Name sex age...