Tag: databases

NULL

0

Results in a compilation error

An exception will be raised

SELECT name FROM USER_DEPENDENCIES WHERE referenced_name = 'DBMS_OUTPUT.PUT_LINE'

SELECT name from ALL_SOURCE WHERE owner = USER AND name = 'DBMS_OUTPUT.PUT_LINE'

SELECT DISTINCT name from ALL_SOURCE WHERE INSTR (text, 'DBMS_OUTPUT.PUT_LINE') > 0

SELECT DISTINCT name from USER_SOURCE WHERE INSTR (UPPER (text), 'DBMS_OUTPUT.PUT_LINE') > 0

When a SELECT statement returns no rows

When a SELECT statement returns more than one row

When the datatypes of SELECT clause and INTO clause do not match

When INTO statement is missing in the SELECT statement

TRUE

FALSE

UNDEFINED

NULL

Header

Declarative

Executable

Exception

Begin null; end;

Declare x varchar2(100); begin dbms_output.put_line(x); end;

Begin .. statement1; exception ... end;

Begin dbms_output.put_line(sysdate); end;;

192

255

249

300

1

31

16

255

8

1

31

32

255

600

256

32