Saturday, January 22, 2011

ORACLE Part 3

GUIDELINES FOR WRITING SQL STATEMENTS
1. SQL STATEMENTS ARE NOT CASE SENSATIVE
2. SQL STATEMENTS CAN BE SPLIT INTO MANY LINES

FOR DOING ARITHMETIC EXPRESSION

SELECT 2+3 FROM DEPT;
SELECT 3+3/3*3-3 FROM DUAL;
SELECT ENAME, JOB, SAL , SAL+1000 FROM EMP;
SELECT SAL, SAL/30 FROM EMP;

DUAL IS THE DUMMY TABLE IN THE DATABASE.

No comments:

Post a Comment