كتاب عمليpl_sql

برمج تطبيقيه وكيفيه عمل الاوامر تأليف: م/همدان الرميم SQL> declare 2 x1 number; 3 x2 number(3,2):=3.14; 4 x3 char; 5 x4 varchar2(50); 6 x5 date defult sysdate; 7 x6 boolean; 8 x7 emp.sal%type; 9 x8 dept%rowtype; 10 x9 constant number:=7; 11 x10 varchar2(10) not null :=50; 12 begin 13 null; 14 end; 15 / x5 date defult sysdate; * ERROR at line 6: ORA-06550: line 6, column 11: PLS-00103: Encountered the symbol "DEFULT" when expecting one of the following: := . ( @ % ; not null range with default character The symbol ";" was substituted for "DEFULT" to continue. SQL> ed Wrote file afiedt.buf 1 declare 2 x1 number; 3 x2 number(3,2):=3.14; 4 x3 char; 5 x4 varchar2(50); 6 x5 date default sysdate; 7 x6 boolean; 8 x7 emp.sal%type; 9 x8 dept%rowtype; 10 x9 constant number:=7; 11 x10 varchar2(10) not null :=50; 12 begin 13 null; 14* end; SQL> / PL/SQL procedure successfully completed. SQL> declare 2 x number; 3 begin 4 x:=5; 5 dbms-output_line(x); 6 declare 7 x number; 8 begin 9 x:=10; 10 dbms-output.put_line(x); 2 x1 number; 3 x2 number(3,2):=3.14; 4 x3 char; 5 x4 varchar2(50); 6 x5 date default sysdate; 7 x6 boolean; 8 x7 emp.sal%type; 9 x8 dept%rowtype; 10 x9 constant number:=7; 11 x10 varchar2(10) not null :=50; 12 begin 13 null; 14* end; SQL> / PL/SQL procedure successfully completed. SQL> declare 2 x number; 3 begin 4 x:=5; 5 dbms-output_line(x); 6 declare 7 x number; 8 begin 9 x:=10; 10 dbms-output.put_line(x);
-
من كتب أوراكل كتب قواعد البيانات - مكتبة كتب تقنية المعلومات.