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
Ïà¹ØÎĵµ£º
ÔÚOracle8i»òÒÔÉϰ汾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
&nbs ......
oracle cast() º¯ÊýÎÊÌâ
SQL> create table t1(a varchar(10));
Table created.
SQL> insert into t1 values ('12.3456');
1 row created.
SQL> select round(a) from t1;
ROUND(A)
----------
12
SQL> select round(a,3) from t1;
ROUND(A,3)
- ......
1.translate
Óï·¨£ºTRANSLATE(char, from, to)
Ó÷¨£º·µ»Ø½«³öÏÖÔÚfromÖеÄÿ¸ö×Ö·ûÌæ»»ÎªtoÖеÄÏàÓ¦×Ö·ûÒÔºóµÄ×Ö·û´®¡£
Èôfrom±Èto×Ö·û´®³¤£¬ÄÇôÔÚfromÖбÈtoÖжà³öµÄ×Ö·û½«»á±»É¾³ý¡£
&nbs ......
µ±³õʼ»¯²ÎÊýREMOTE_LOGIN_PASSWORDFILEÉèÖÃΪEXCLUSIVEʱ£¬ÏµÍ³ÔÊÐí³ýINTERNAL/SYSÒÔÍâµÄÆäËûÓû§ÒÔ¹ÜÀíÔ±Éí·Ý´ÓÔ¶¶Ë»ò±¾»úµÇ¼µ½OracleÊý¾Ý¿âϵͳ£¬Ö´ÐÐÊý¾Ý¿â¹ÜÀí¹¤×÷;ÕâЩÓû§Ãû±ØÐë´æÔÚÓÚÃÜÂëÎļþÖУ¬ÏµÍ³²ÅÄÜʶ±ðËûÃÇ¡£ÓÉÓÚ²»¹ÜÊÇÔÚ´´½¨Êý¾Ý¿âʵÀýʱ×Ô¶¯´´½¨µÄÃÜÂëÎļþ£¬»¹ÊÇʹÓù¤¾ßORAPWD.EXEÊÖ¹¤´´½¨µÄÃÜÂëÎļþ£¬¶ ......
1. ²é¿´ÃÜÂëÎļþÖеijÉÔ±£º
¿ÉÒÔͨ¹ý²éѯÊÓͼV$PWFILE_USERSÀ´»ñȡӵÓÐSYSOPER/SYSDBAϵͳȨÏÞµÄÓû§µÄÐÅÏ¢£¬±íÖÐSYSOPER/SYSDBAÁеÄȡֵTRUE/FALSE±íʾ´ËÓû§ÊÇ·ñÓµÓÐÏàÓ¦µÄȨÏÞ¡£ÕâЩÓû§Ò²¾ÍÊÇÏàÓ¦µØ´æÔÚÓÚÃÜÂëÎļþÖеijÉÔ±¡£
2. À©Õ¹ÃÜÂëÎļþµÄÓû§ÊýÁ¿£º
µ±ÏòOracleÊý¾Ý¿âÃÜÂëÎļþÌí¼ÓµÄÕʺÅÊýÄ¿³¬¹ý´´½¨ÃÜÂëÎļþʱ ......