代码搜索结果

SELECT employee_id FROM employee WHERE salary = 10000; DECLARE TYPE employee_aat IS TABLE OF employee.employee_id%TYPE INDEX BY PLS_INTEGER; l_employees employee_aat;

DROP TABLE favorites; CREATE TABLE favorites ( flavor VARCHAR2(100), NAME VARCHAR2(100)); DECLARE TYPE favorites_tt IS TABLE OF favorites%ROWTYPE INDEX BY PLS_INTEGER; T

DECLARE PROCEDURE bpl (val IN BOOLEAN, str IN VARCHAR2) IS BEGIN IF val THEN DBMS_OUTPUT.put_line (str || '-TRUE'); ELSIF NOT val THEN DBMS_

SELECT employee_id FROM employee WHERE salary = 10000; DECLARE TYPE employee_aat IS TABLE OF employee.employee_id%TYPE INDEX BY PLS_INTEGER; l_employees employee_aat;

CREATE OR REPLACE PACKAGE authors_pkg IS steven_authors strings_nt := strings_nt ('ROBIN HOBB' , 'ROBERT HARRIS' , 'DAVID BRIN'

CREATE OR REPLACE PACKAGE authors_pkg IS steven_authors strings_nt := strings_nt ('ROBIN HOBB' , 'ROBERT HARRIS' , 'DAVID BRIN'

DECLARE TYPE nested_type IS TABLE OF NUMBER; nt1 nested_type := nested_type(1,2,3); nt2 nested_type := nested_type(3,2,1); nt3 nested_type := nested_type(2,3,1,3); nt4 nested_

DECLARE our_authors strings_nt := strings_nt(); BEGIN our_authors := authors_pkg.steven_authors MULTISET UNION authors_pkg.veva_authors; authors_pkg.show_authors

alter session set plsql_warnings='ENABLE:ALL'