Extra Query's
1) SELECT * FROM DUAL;
2) DESC DUAL;
3) SELECT 2*2 FROM DUAL;
4) SELECT SYSDATE FROM DUAL;
5) SELECT SUM(AMOUNT) FROM DEPOSIT;
6) SELECT AVG(AMOUNT) FROM DEPOSIT;
7) SELECT ABS(-15) "ABSOLUTE" FROM DUAL;
8) SELECT POWER (2,5) "POWER" FROM DUAL;
9) SELECT SQRT(9) "SQUARE ROOT" FROM DUAL;
10) SELECT FLOOR (15.66) "FLOOR VALUE" FROM DUAL;
11)SELECT CEIL (15.66) "CEILING VALUE" FROM DUAL;
12) SELECT ASCII ('A') FROM DUAL;
13) SELECT ASCII ('a') FROM DUAL;
14) SELECT LOWER ('CESPU') FROM DUAL;
15) SELECT UPPER ('cespu') FROM DUAL;
16) SELECT INITCAP ('CESPU') FROM DUAL;
17) SELECT LENGTH ('CESPU') FROM DUAL;
18) SELECT SUBSTR ('SECURE',3,4) FROM DUAL;
19) SELECT INSTR ('DBMS PQR','D') FROM DUAL;
20) SELECT EXTRACT (MONTH FROM SYSDATE) "MONTH" FROM DUAL;
21) SELECT EXTRACT (YEAR FROM SYSDATE) "YEAR" FROM DUAL;
22) SELECT LAST_DAY(SYSDATE) "LD" FROM DUAL;
23) SELECT SYSDATE FROM DUAL;
24) SELECT TO_CHAR (SYSDATE,'DD-MM-YYYY') FROM DUAL;
25) SELECT TO_DATE ('06/07/01','DD-MM-YYYY') FROM DUAL;
26) SELECT TO_CHAR (SYSDATE , 'DDSP') FROM DUAL;
27) SELECT TO_CHAR (SYSDATE,'DDSPTH') FROM DUAL;
28) SELECT * FROM DEPT ORDER BY DNAME DESC;
29) SELECT * FROM DEPT ORDER BY DNAME;
2) DESC DUAL;
3) SELECT 2*2 FROM DUAL;
4) SELECT SYSDATE FROM DUAL;
5) SELECT SUM(AMOUNT) FROM DEPOSIT;
6) SELECT AVG(AMOUNT) FROM DEPOSIT;
7) SELECT ABS(-15) "ABSOLUTE" FROM DUAL;
8) SELECT POWER (2,5) "POWER" FROM DUAL;
9) SELECT SQRT(9) "SQUARE ROOT" FROM DUAL;
10) SELECT FLOOR (15.66) "FLOOR VALUE" FROM DUAL;
11)SELECT CEIL (15.66) "CEILING VALUE" FROM DUAL;
12) SELECT ASCII ('A') FROM DUAL;
13) SELECT ASCII ('a') FROM DUAL;
14) SELECT LOWER ('CESPU') FROM DUAL;
15) SELECT UPPER ('cespu') FROM DUAL;
16) SELECT INITCAP ('CESPU') FROM DUAL;
17) SELECT LENGTH ('CESPU') FROM DUAL;
18) SELECT SUBSTR ('SECURE',3,4) FROM DUAL;
19) SELECT INSTR ('DBMS PQR','D') FROM DUAL;
20) SELECT EXTRACT (MONTH FROM SYSDATE) "MONTH" FROM DUAL;
21) SELECT EXTRACT (YEAR FROM SYSDATE) "YEAR" FROM DUAL;
22) SELECT LAST_DAY(SYSDATE) "LD" FROM DUAL;
23) SELECT SYSDATE FROM DUAL;
24) SELECT TO_CHAR (SYSDATE,'DD-MM-YYYY') FROM DUAL;
25) SELECT TO_DATE ('06/07/01','DD-MM-YYYY') FROM DUAL;
26) SELECT TO_CHAR (SYSDATE , 'DDSP') FROM DUAL;
27) SELECT TO_CHAR (SYSDATE,'DDSPTH') FROM DUAL;
28) SELECT * FROM DEPT ORDER BY DNAME DESC;
29) SELECT * FROM DEPT ORDER BY DNAME;