Skip to Content
PLSQL teszt
1
SELECT '6 * 6' "Area" FROM REGIONS;
1
2
3
4
WHERE COMMISSION_PCT IS NULL
WHERE COMMISSION_PCT = NULL
WHERE COMMISSION_PCT IN (NULL)
WHERE NOT(COMMISSION_PCT IS NOT NULL)
1
2
SELECT INSTR('How_long_is_a_piece_of_string?','_',5,3)
FROM DUAL;
1
2
SELECT JOB_ID, MAX_SALARY FROM JOBS
GROUP BY MAX_SALARY;
1
2
3
CREATE TABLE tab1 (c1 NUMBER(1), c2 DATE);
ALTER SESSION SET nls_date_format='dd-mm-yy';
INSERT INTO tab1 VALUES (1.1, '31-01-07');
1
2
3
SELECT
DECODE(TO_CHAR(SYSDATE, 'MM'), '02','TAXDUE','PARTY')
FROM DUAL;
1
2
SELECT E.JOB_ID, J.JOB_ID FROM EMPLOYEES E
JOIN JOBS ON (E.SALARY < J.MAX_SALARY);
1
2
3
4
5
6
7
8
9
DECLARE a number;
PROCEDURE squareNum(x IN OUT number) IS BEGIN
        x := x * x;
END;
BEGIN
        a := 5;
        squareNum(a);
        dbms_output.put_line(a);
END;
1
2
3
4
5
CREATE SEQUENCE MY_SEQ;
SELECT MY_SEQ.NEXTVAL FROM DUAL;
SELECT MY_SEQ.NEXTVAL FROM DUAL;
ROLLBACK;
SELECT MY_SEQ.NEXTVAL FROM DUAL;
1
CREATE INDEX emp_indx ON employee (empno);