Hi All,
I need some help from you guys on overcoming the 'no rows selected' message when executing a select statement(Sql developer-->f5(Run Script)).
Below is the sample code on which resulting as no rows selected.
Scripts:-
CREATE TABLE CHECK_VAL(C_ID VARCHAR2(100),C_NAME VARCHAR2(100),STATUS VARCHAR2(100))
/
INSERT INTO CHECK_VAL VALUES('A1191','TOM WAREEN','AVAILABLE');
INSERT INTO CHECK_VAL VALUES('B1186','MADDY','OOO');
INSERT INTO CHECK_VAL VALUES('B1123','BUSHAN','BUSY');
INSERT INTO CHECK_VAL VALUES('B1192','SHIV','AVAILABLE');
COMMIT;
/
SELECT 'Employees Available' scenario,
c_id,count(1)
FROM CHECK_VAL
WHERE STATUS = 'INACTIVE'
GROUP BY c_id
/
Desired Output(if no records found):-
| Scenario | C_id | count(1) |
| Employees Available | Nil | 0 |
Someone pls help me to achieve this.
Regards,
Lazar