oracleÖÐselect 1ºÍselect *µÄÇø±ð
´´½¨myt±í²¢²åÈëÊý¾Ý£¬ÈçÏ£º
create table myt(name varchar2,create_time date)
insert into myt values('john',to_date(sysdate,'DD-MON-YY'));
insert into myt values('tom',to_date(sysdate,'DD-MON-YY'));
insert into myt values('lili',to_date(sysdate,'DD-MON-YY'));
ÔÚsql*plusÖÐÏÔʾÈçÏ£º
SQL> select * from myt;
NAME CREATE_TIME
---------- -----------
john 2010-5-19
tom 2010-5-19
lili 2010-5-19
SQL> select 1 from myt;
1
----------
1
1
1
SQL> select 0 from myt;
0
----------
0
0
0
´ÓÒÔÉϽá¹û ¿ÉÒÔ¿´µ½£¬select constant fromtable ¶ÔËùÓÐÐзµ»Ø¶ÔÓ¦µÄ³£Á¿Öµ£¨¾ßÌåÓ¦ÓüûÏÂÃ棩£¬
¶øselect * from tableÔò·µ»ØËùÓÐÐжÔÓ¦µÄËùÓÐÁС£
select 1³£ÓÃÔÚexists×Ó¾äÖУ¬¼ì²â·ûºÏÌõ¼þ¼Ç¼ÊÇ·ñ´æÔÚ¡£
Èçselect * from T1 where exists(select 1 from T2 where T1.a=T2.a) ;
T1Êý¾ÝÁ¿Ð¡¶øT2Êý¾ÝÁ¿·Ç³£´óʱ£¬T1<<T2 ʱ£¬1) µÄ²éѯЧÂʸߡ£
“select 1”ÕâÀïµÄ “1”ÆäʵÊÇÎ޹ؽôÒªµÄ£¬»»³É“*”ҲûÎÊÌ⣬ËüÖ»ÔÚºõÀ¨ºÅÀïµÄÊý¾ÝÄܲ»ÄܲéÕÒ³öÀ´£¬ÊÇ·ñ´æÔÚÕâÑùµÄ¼Ç¼£¬Èç¹û´æÔÚwhere Ìõ¼þ³ÉÁ¢¡£
ÈçÏÂʾÀý£º
SQL> select 1/0 from dual;
select 1/0 from dual
ORA-01476: ³ýÊýΪ 0
SQL> select * from myt where exists(select 1/0 from dual);
NAME CREATE_TIME
---------- -----------
john 2010-5-19
tom 2010-5-19
lili &nbs
Ïà¹ØÎĵµ£º
Èç¹û²éѯÕû¿âµÄ»°µÃÒÔDBAȨÏÞ²éѯÊý¾Ý×Öµädba_tab_columns
·ÇDBAÓû§Ö»Äܲ鿴×Ô¼ºÓжÁȡȨÏ޵ıí
¿ÉÒÔÕâÑùд²éѯ
select owner, table_name
from dba_tab_columns
where lower(column_name)='firstname';
²éѯ³öÄÄЩ±í°üº¬firstname×Ö¶ÎÒÔ¼°ÕâЩ±íÊôÓÚÄĸöÓû§
×¢£ºdba_tab_columnsÊÇÒ»¸öÊôÓÚSYSÓû§µÄÒ»¸öView ......
1. OracleÄÚ´æ½á¹¹¼ò½é
OracleÔÚÄÚ´æÖд洢ÒÔÏÂÐÅÏ¢£º
¡£³ÌÐò´úÂë
¡£ÒÔÁ¬½ÓµÄ»á»°ÐÅÏ¢£¬°üÀ¨µ±Ç°»î¶¯µÄ¼°·Ç»î¶¯µÄ»á»°
¡£³ÌÐòÖ´Ðйý³ÌÖÐËùÐèµÄÐÅÏ¢
¡£ÐèÒªÔÚOracle½ø³Ì¼ä¹²Ïí²¢½øÐÐͨÐŵĵÄÐÅÏ¢
¡£Êý¾ÝÎļþÄÚÊý¾ÝµÄ»º´æ£¨ÈçÊý¾Ý¿é¼°ÖØ×öÈÕÖ¾ÌõÄ¿£©
Oracle ÖеĻù±¾ÄÚ´æ½á¹¹°üÀ¨£º
¡£ÏµÍ³È«¾ÖÇø(SGA):´ËÇøÓòÓÉËùÓÐµÄ ......
1.translate
Óï·¨£ºTRANSLATE(char, from, to)
Ó÷¨£º·µ»Ø½«³öÏÖÔÚfromÖеÄÿ¸ö×Ö·ûÌ滻ΪtoÖеÄÏàÓ¦×Ö·ûÒÔºóµÄ×Ö·û´®¡£
Èôfrom±Èto×Ö·û´®³¤£¬ÄÇôÔÚfromÖбÈtoÖжà³öµÄ×Ö·û½«»á±»É¾³ý¡£
&nbs ......
1¡¢±à³ÌÓïÑÔÓëOracleÊý¾Ý¿â
1.1¡¢´æ´¢µÄÓëÄäÃûµÄPL/SQL³ÌÐò¿é
Óë´æ´¢µÄPL/SQL³ÌÐò¿éÏà±È£¬ÄäÃûµÄPL/SQL³ÌÐò¿éЧÂʽϵͣ¬´ËÍâÓÉÓÚ¿ÉÄÜÔÚ¶ą̀»úÆ÷Öй«²¼Ô´´úÂ룬»¹»áÒý·¢¹ÜÀíÎÊÌâ¡£
1.2¡¢PL/SQL¶ÔÏó
PL/SQL¶ÔÏó¾ßÓÐÏÂÁÐ5ÖÖÀàÐÍ£º
¹ý³Ì
º¯Êý
³ÌÐò°ü
³ÌÐò°üÖ÷Ìå
´¥·¢Æ÷
2¡¢¹ý³Ì¡¢º¯ÊýÒÔ¼°³ÌÐò°ü
2.1¡¢¹ý³ÌÓëº¯Ê ......
¹ØÓÚOracle Job ²»Ö´ÐÐ
2008-11-11 19:48
ÎÒÃÇÓõÄÉú²ú»·¾³JobÊÇ¿ÉÒÔÕý³£Ö´ÐеÄ,µ«ÊÇÔÚ²âÊÔ»·¾³ÊDz»¿ÉÒÔÖ´ÐеÄ
ÔÚÍøÉϲéÁËÒ»ÏÂÔÒòÈçÏÂ
SQL> show parameter job
NAME   ......