sql2 1502

PROCEDURĘ get_happy (ename_in IN VARCHAR2)• IS

hiredate DATĘ;    •

BEGIN

hiredate := SYSDATE - 2;

INSERT INTO employee (emp_name, hiredate)

VALUES (ename_in, hiredate);

EXCEPTION

WHEN DUP_VAL_IN_INDEX THEN

DBMS_OUTPUT.PUT_LINE ('Cannot insert.');

END;

Wyszukiwarka

Podobne podstrony:
sql2 1505 PROCEDURĘ get_happy IS BEGIN DECLARE hiredate DATĘ; BEGIN END; END get_happy;
sql2 1602 PACKAGE BODY sp_timer IS last_timing NUMBER := NULL; PROCEDURĘ capture (context_in IN VARC
dodaj goscia create orreplace procedurę DODAJ_GOSCLAl( IM VARCKAR2, NAZW VARCHAR2, DAT AUR DATĘ, ADR
sql2 1511 Procedurę Header: PROCEDURĘ calc_all (idjn IN INTEGER. totaLout OUT NUMBER) Procedurę Cali
sql2 1507 PROCEDURĘ update_management (company_id_in IN NUMBER) IS BEGIN BEGIN ____ UPDATE employee
sql2 0402 BEGIN DECLARE emp_id emp.empno%TYPE; new_emp emp_id%TYPE; Data Dictionary EMP Tabie -
sql2 1506 DECLARE CURSOR emp_cur IS ...; BEGIN DECLARE total_sales NUMBER; BEGIN DECLARE hiredate DA
sql2 1507 PROCEDURĘ update_management (company_id_in IN NUMBER) IS BEGIN BEGIN ____ UPDATE employee
sql2 1508 DECLARE hiredate DATĘ; BEGIN DECLARE    •- total_sales NUMBER;
sql2 1601 PACKAGE sp_timer IS PROCEDURĘ capture (context_in IN VARCHAR2) PROCEDURĘ show_e1apsed; END
f4 1 f£B & a Sax Software Corporation Welcome toSax Software 16-bit Webster Now get web power in
00154 pad31fa20becbd2e123a5d60e7c069f 155Optimization and Sensitiyity Analysis procedures. With a s
jow09 03 Son whr.t you hnwo to get dcrwn pat In your arlnd ls tho proooaaoa of breath-ln#, wMch you
24ddg23 Source Codę Control Options Get latest checked in versions of project files when opening a p

więcej podobnych podstron