Oracle ÏÔʽÓαê
--------------------ÏÔʽÓαê
--²éѯÊý¾Ý
select * from employees;
--¶¨Ò岿·Ö
declare
--ÉùÃ÷Óαê
cursor mycur is select * from employees where employee_id<120;
--¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓڴ洢ij¸ö±íµÄÒ»Ìõ¼Ç¼
rowdata employees%rowtype;
--Ö´Ðв¿·Ö
begin
--´ò¿ªÓαê
open mycur;
loop
--ÔÚÑ»·ÖÐÓÃfetchÌáÈ¡¼Ç¼
fetch mycur into rowdata;
dbms_output.put_line('salary:'||rowdata.salary||' '||'hire_date:'||rowdata.hire_date||' '||'first_name:'||rowdata.first_name);
--ÓÃ%notfoundÊôÐÔ¼ì²âÊÇ·ñµ½×îºóÒ»Ìõ¼Ç¼
exit when mycur%notfound;
end loop;
--Ìá½»ÊÂÎñ;
commit;
--¹Ø±ÕÓαê
close mycur;
--Òì³£²¿·Ö
exception
--ÓÐÒì³£Ôò»Ø¹ö
when others then
rollback;
end;
/
--------------------²ÎÊýÓαê
--²éѯÊý¾Ý
select * from employees where salary<=10000;
--¶¨Ò岿·Ö
declare
--¶¨ÒåÓαꣻעÒ⣺²ÎÊýÀàÐÍ(input_salary)²»ÐèÒªÖ¸¶¨¾«¶È
cursor mycur(input_salary number) is select * from employees where salary<input_salary;
--¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓÚ´æ´¢Ä
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
¶ÔÿһÐÐÊäÈëÖµ½øÐмÆË㣬µÃµ½ÏàÓ¦µÄ¼ÆËã½á¹û£¬·µ»Ø¸øÓû§£¬Ò²¾ÍÊÇ˵£¬Ã¿ÐÐ×÷Ϊһ¸öÊäÈë²ÎÊý£¬¾¹ýº¯Êý¼ÆËãµÃµ½Ã¿ÐеļÆËã½á¹ûÊǵ¥Ðк¯Êý¡£
Ò»¡¢×Ö·ûº¯Êý
1¡¢×Ö·û´®´óСдת»»
(1)LOWER (strexp) ·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·ûСд
(2)UPPER (strexp) ·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ× ......
PL/SQL µÄÒì³£(Ô¤¶¨ÒåÒì³£)
2009-08-13 20:24
Òì³£Ãû³Æ & ......
Ò»¡¢oracleµ¼³öexcel
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨---Óù¤¾ßplsql dev
Ö´ÐÐFile =>new Report Window ¡£ÔÚsql±êÇ©ÖÐдÈëÐèÒªµÄsql£¬µã»÷Ö´Ðлò°´¿ì½Ý¼üF8£¬»áÏȳԳö²éѯ½á¹û¡£ÔÚÓҲ๤¾ßÀ¸£¬¿ÉÒÔÑ¡Ôñ°´Å¥Áí´æÎªhtml¡¢copy as html¡¢export results£¬ÆäÖÐexport results°´Å¥ÖоͿÉÒÔµ¼³öexcelÎļþ¡¢csvÎļþ¡¢tsvÎļþ¡¢xmlÎļþ¡ ......
Éó¼ÆÊÓͼ
STMT_AUDIT_OPTION_MAP -- Éó¼ÆÑ¡ÏîÀàÐÍ´úÂë
AUDIT_ACTIONS -- action´úÂë
ALL_DEF_AUDIT_OPTS -- ¶ÔÏó´´½¨Ê±Ä¬ÈϵĶÔÏóÉó¼ÆÑ¡Ïî
DBA_STMT_AUDIT_OPTS -- µ±Ç°Êý¾Ý¿âϵͳÉó¼ÆÑ¡Ïî
DBA_PRIV_AUDIT_OPTS -- ȨÏÞÉó ......