ORACLE ÔÚWHERE×Ó¾äÖÐÒýÓÃÁбðÃûµÄÎÊÌâ
SQL> select sal,comm from emp
2 where sal<2000;
SAL COMM
---------- ----------
800
1600 300
1250 500
1250 1400
1500 0
1100
950
1300
8 rows selected.
SQL> select sal as salary,comm as commission from emp
2 where salary<2000;
where salary<2000
*
ERROR at line 2:
ORA-00904: "SALARY": invalid identifier
SQL> select * from
2 (
3 select sal as salary,comm as commission from emp
4 ) x
5 where salary<2000;
SALARY COMMISSION
---------- ----------
800
1600 300
1250 500
1250 1400
1500 0
1100
950
1300
8 rows selected.
½«È¡±ðÃûµÄ²éѯ×÷ΪÄÚÁªÊÓͼ£¬±ã¿ÉÒÔÔÚÍⲿ²éѯÖÐÒýÓÃÆäÖеıðÃûÁС£ÎªÊ²Ã´ÒªÕâô×öÄØ£¿WHERE×Ó¾äÊÇÔÚSELECT֮ǰ½øÐд¦ÀíµÄ£¬ÕâÑù£¬ÔÚ´¦ÀíÇó½â“ÎÊÌ┲éѯµÄWHERE×Ó¾ä֮ǰ£¬SALARYºÍCOMMISSION²¢²»´æÔÚ£¬Òªµ½WHERE×Ӿ䴦ÀíÍê³ÉÖ®ºó£¬±ðÃû²ÅÉúЧ¡£È»¶ø£¬from×Ó¾äÊÇÔÚWHERE֮ǰ´¦ÀíµÄ¡£½«Ô²éѯ·ÅÔÚfrom×Ó¾äÖУ¬ÄÇô£¬ÔÚ×îÍâ²ãµÄWHERE×Ó¾ä֮ǰ£¬ÒÔ¼°×îÍâ²ãµÄWHERE×Ӿ䓿´µ½”±ðÃû֮ǰ£¬¾ÍÒѾÉú³ÉÁ˲éѯ½á¹û¡£
Ïà¹ØÎĵµ£º
declare
v_isexist number(3,0):=0;
begin
select count(1) into v_isexist from sys.all_objects where owner = 'TEST' and object_type = 'TABLE' and object_name = 'TAB1';
if v_isexist>0 ......
Ä¿±ê£ºÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£¬Ö»Òª»á¼òµ¥µÄlinuxÃüÁî¾ÍÄÜʵÏÖoracle expµÄ×Ô¶¯±¸·Ý
»·¾³£ºlinux as3+oracle9i
¾ßÌåµÄ²½Ö裺
1.ÓʼþÉèÖÃ
[root@sxapp1 mail]# cd /etc/mail
[root@sxapp1 mail]# mv submit.cf submit.cfbak
[root@sxapp1 spool]# chmod a+wrx mqueue/
[root@sxapp1 mail]# echo "sdsd ......
Ç°ÃæдÁ˶à·ÝºìÆìDC 4.1ºÍ5.0ÉÏ°²×°Oracle 9i/10gµÄÎĵµ£¬µ«Ò»Ö±Ã»ÓÐÕûÀíDC 5.0ÉÏ°²×°Oracle 10gµ¥»ú·þÎñÆ÷µÄ×ÊÁÏ£¬ÔÒòÊǸùý³Ì·Ç³£¼òµ¥¡£µ«×î½üÏîÄ¿ÖУ¬»¹ÊÇÓÐÓû§Óöµ½Ð©ÎÊÌ⣬½ñÌì¾Í°ÑһЩÐèҪעÒâµÄµØ·½ÕûÀíһϣ¬ÏêϸµÄ¹ý³Ì¾Í²»ÃèÊöÁË¡£
Ò»¡¢ÏµÍ³»·¾³
²Ù×÷ϵͳ£ººìÆì DC 5.0 for x86 »ò x86_64
Ó²¼þ»·¾ ......
×î¼òµ¥µÄÊÇʹÓÃ
/* Formatted on 2009/12/02 16:01 (Formatter Plus v4.8.8) */
SELECT TO_CHAR (TO_DATE ('2009-12-02', 'YYYY-MM-DD'), 'WW')
from DUAL;
²»¹ýto_char()º¯ÊýÔÚ¼ÆËãÒ»ÄêÖеڼ¸ÖÜÊÇ´Ó¸ÃÄêµÄ1ÔÂ1ÈÕ¿ªÊ¼µÄ¡£
ÒÔÏÂSQL Äܵõ½ÕýÈ·µÄ×ÔÈ»ÖÜÊý.
/* Formatted ......
oracle Óû§ÃÜÂëºÍ×ÊÔ´¹ÜÀí
oracleÖÐʹÓÃprofile¶ÔÓû§ÃÜÂëºÍ×ÊÔ´½øÐйÜÀí¡£
SQL> select * from dba_profiles order by resource_name;
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
------------------------------ -------------------------------- ------- ......