Zum Inhalt wechseln
PLSQL teszt
1
SELECT   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(,,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=;
INSERT INTO tab1 VALUES (1.1, );
1
2
3
SELECT
DECODE(TO_CHAR(SYSDATE, ), ,,)
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);