❞ كتاب عملي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);
-
من كتب أوراكل كتب قواعد البيانات - مكتبة كتب تقنية المعلومات.