Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚORACLEÍâÁ¬½Ó£¨+£©

ÏÖÔÚÓÐÒÔÏÂÁ½ÕÅ±í£º
                                              ±íA Ô±¹¤£¨EMPLOYEE£©
  
EMP_NO
EMP_NAME
JOB
DEPT_NO
1
1
HXF
PRESIDENT
2
2
2
SCOTT
CLERK
1
3
3
SMITH
SALESMAN
3
4
4
JOHN
MANAGER
¡¡
                                                       
                                              ±íB ²¿ÃÅ£¨DEPARTMENT£©
  
DEPT_NO
DEPT_NAME
LOCATION
DEL_FLG
1
1
ACCOUNTING
HANGZHOU
0
2
2
RESEARCH
BEIJING
0
3
3
OPERATIONS
SHANGHAI
1
 
ÆäÖв¿ÃűíÖÐ×Ö¶ÎDEL_FLGΪ0±íʾ¸ÃÌõ¼Ç¼ÒÑɾ³ý£¬ÊÇÎÞЧ¼Ç¼£»·´Ö®Ïà·´¡£
 
Èç¹ûÐèÒªÕÒ³ö±íAÖеÄËùÓмǼ£¬²¢¹ØÁªÉϱíBÖеÄÓÐЧ¼Ç¼£¬ÎÒÃǺܿÉÄÜ»áд³öÒÔÏÂÈýÖÖSQLÓï¾ä£º
 
    Óï¾äÒ»£º
SELECT A.EMP_NAME, A.JOB, B.*
 from EMPLOYEE A, DEPTMENT B
 WHERE A.DEPT_NO = B.DEPT_NO(+)
   AND B.DEL_FLG(+) = '0'
¸ÃÓï¾äÀûÓÃOracleµÄÍâÁ¬½Ó·ûºÅ£¬²¢ÓÃÌõ¼þB.DEL_FLG(+) = '0'ÏÞ¶¨±íBÖÖµÄÓÐЧ¼Ç¼¡£Ò²ÓÐÈË¿ÉÄÜ»áд³ÉÓï¾ä¶þ£º
     Óï¾ä¶þ£º
SELECT A.EMP_NAME, A.JOB, B.*
 from EMPLOYEE A, DEPTMENT B
 WHERE A.DEPT_NO = B.DEPT_NO(+)
   AND B.DEL_FLG = '0'
Óï¾ä¶þÖбíBÖеÄ×Ö¶ÎDEL_FlGû´øÍâÁ¬½Ó·ûºÅ¡£»¹ÓÐÖÖд·¨£¬ÈçÓï¾äÈý£º
    Óï¾äÈý£º
SELECT *
 from (SELECT A.EMP_NAME


Ïà¹ØÎĵµ£º

ORACLEº¯Êý´óÈ«

SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from ......

oracleÖµµÃ̽ÌÖµÄÎÊÌâ

¾­³£×öһЩÊý¾Ý¿â²Ù×÷£¬ÔÚ½¨Á¢±íµÄʱºò£¬Ñ¡Ôñ×Ö¶ÎÀàÐÍʱ£¬ÓйØ×Ö·û´®ÀàÐ͵ÄÑ¡Ôñ×ÜÊÇÓÐЩģºý¡£
¡£char
¡£varchar2
¡£nvarchar2
¡£nchar
¹ØÓÚÉÏÃæÁ½¸öÎÒÓеãÓ¡Ïó¡£CHARµÄ³¤¶ÈÊǹ̶¨µÄ£¬¶øVARCHAR2µÄ³¤¶ÈÊÇ¿ÉÒԱ仯µÄ£¬±ÈÈ磬´æ´¢×Ö·û´®“abc"£¬¶ÔÓÚCHAR (20)£¬±íʾÄã´æ´¢µÄ×Ö·û½«Õ¼20¸ö×Ö½Ú(°üÀ¨17¸ö¿Õ×Ö·û)£ ......

ÍêÈ«Ð¶ÔØOracle

ÍêÈ«Ð¶ÔØOracle
Èí¼þ»·¾³£º
1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORACLE
ʵÏÖ·½·¨£º
1¡¢ ¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñ
Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢ ¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle - OraHome81£­£¾Oracle Installation Products£­£¾
Universal Installer
жװËùÓÐOracle²úÆ·£¬ ......

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (ËÄ)

 1.Êý¾Ý¿â¶ÀÁ¢ÐÔ
½«Ó¦ÓôÓÊý¾Ý¿âA ÒÆÖ²µ½Êý¾Ý¿âB ʱ£¬ÎÒʱ³£Óöµ½ÕâÖÖÎÊÌ⣺ӦÓÃÔÚÊý¾Ý¿âA ÉÏÔ­±¾ÎÞи¿É»÷£¬µ½ÁË
Êý¾Ý¿âB ÉÏÈ´²»Äܹ¤×÷£¬»òÕß±íÏֵúÜÀëÆæ¡£¿´µ½ÕâÖÖÇé¿ö£¬ÎÒÃǵĵÚÒ»¸öÏë·¨ÍùÍùÊÇ£¬Êý¾Ý¿âB ÊÇÒ»¸ö
“²»ºÃµÄ”Êý¾Ý¿â¡£¶øÕæÕýµÄÔ­ÒòÆäʵÊÇÊý¾Ý¿âB µÄ¹¤×÷·½Ê½ÍêÈ«²»Í¬¡£Ã»ÓÐÄĸöÊý¾Ý¿âÊÇ´íµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ