oracleÖÐÖ±½ÓÐ޸ıíÁеÄÃû³ÆºÍ˳Ðò
µ¼ÈëÊý¾ÝµÃʱºò£¬Óöµ½Ò»¸öÎÊÌ⣬Ïë°ÑÁÐÃû˳Ðò¸Ä±äһϡ£ÔÚÍøÉÏËÑË÷µ½ÕâÆªÎÄÕ£¬Ã»È¥ÊÔÑé¡£ÌùÉÏÀ´£¬ÒÔºóÓлú»áÊÔÑéÏ¡£
£¨http://www.im80hou.com/html/oracle/2009/0710/712.html£©
°´ÕÕ¹ØÏµÊý¾Ý¿âµÄÀíÂÛ£¬ÐÐÓëÁж¼ÊÇÎÞÐòµÄ£¬µ«ÔÚʵ¼ÊÓ¦ÓÃÖÐÓÐʱÐèҪȷ¶¨ÁеÄ˳Ðò¡£µ«ÔÚOracleÖУ¬Ò»µ©±í¶¨ÒåºÃ£¬ÔÙÏëÐÞ¸ÄÁеÄ˳Ðò¿É²»Ì«ÈÝÒ×
¡¡¡¡
1£®ÒÔinternalÓû§ÃûµÇ¼OracleÊý¾Ý¿â£¬²¢´´½¨Ò»²âÊÔ±í¡£
SQL>CREATE TABLE SCOTT.TEST AS SELECT EMPNO,
ENAME from SCOTT.EMP;
SQL>DESC SCOTT.TEST
Name Type Nullable Default Comments
------- ------------ -------
EMPNO NUMBER(4) Y
ENAME VARCHAR2(10) Y
ÏÂÃæÎÒÃÇÒª°ÑSCOTT.TEST±íÖÐEMPNOºÍENAMEÁ½Áе÷»»Ë³Ðò£¬²¢°ÑENAMEÁиüÃûΪEMP_NAME£¬EMPNO¸ÄΪEMP_NO¡£
2£®²éѯ±íÖÐÁеÄʵ¼Ê´æ´¢Î»Öûò±í¡£
SQL>SET LONG 9999£¬ÓÉÓÚTEXTÁÐÊÇLONGÀàÐÍ£¬Ö»ÓГSET”Ö®ºó²ÅÄÜÍêÈ«ÏÔʾ¡£
SQL>SELECT TEXT from ALL_VIEWS WHERE VIEW_NAME = ‘USER_TAB_COLUMNS’;
Êý¾Ý×ÖµäÊÓͼUSER_TAB_COLUMNSÖд洢ÓбíÁе͍ÒåÐÅÏ¢£¬´Ó¸ÃÓï¾äµÄ²éѯ½á¹û¿ÉÒÔ¿´³ö£¬Áж¨ÒåÐÅÏ¢ÊÇ´æ´¢ÔÚ±íSYS.COL$Öе쬼´Èç¹ûÐ޸ıíÖÐÁе͍Ò壬Ӧ¸ÃÔÚSYS.COL$±íÖÐÐ޸ġ£
3£®´ÓÊý¾Ý×ÖµäÊÓͼALL_OBJECTSÖвéÕÒ¶ÔÏóSCOTT.TEST¶ÔÏóID¡£
SQL> SELECT * from ALL_OBJECTS WHERE OWNER =‘SCOTT’ AND OBJECT_NAME=‘TEST’;
4£®¸ù¾ÝSCOTT.TEST¶ÔÏóµÄID£¬´ÓSYS.COL$¼ìË÷³ö±íÖÐÁе͍ÒåÐÅÏ¢¡£
SQL> SELECT OBJ#,COL#,NAME from SYS.COL$ WHERE OBJ# =13888;
OBJ# COL# NAME
---------- ---------- -------
13888 1 EMPNO
&n
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
oracle ÖÐ TO_DATE º¯ÊýµÄʱ¼ä¸ñʽ£¬ÒÔ 2008-09-10 23:45:56 ΪÀý
¸ñʽ
˵Ã÷
ÏÔʾֵ
±¸×¢
Year(Äê):
yy
two digits(Á½Î»Äê)
08
yyy
three digits(ÈýλÄê)
008
yyyy
four digits(ËÄλÄê)
2008
Month(ÔÂ):
mm
number(Á½Î»ÔÂ)
09
mon
abbre ......
1.ÊÂÎñ¸ÅÊö
ÊÂÎñ£¨Transaction£©ÊÇÊý¾Ý¿âÇø±ðÓÚÎļþϵͳµÄÌØÐÔÖ®Ò»¡£ÔÚÎļþϵͳÖУ¬Èç¹ûÄãÕý°ÑÎļþдµ½Ò»
°ë£¬²Ù×÷ϵͳͻȻ±ÀÀ£ÁË£¬Õâ¸öÎļþ¾ÍºÜ¿ÉÄÜ»á±»ÆÆ»µ¡£²»´í£¬È·Êµ»¹ÓÐһЩ“ÈÕ±¨Ê½”£¨journaled£©Ö®
ÀàµÄÎļþϵͳ£¬ËüÃÇÄܰÑÎļþ»Ö¸´µ½Ä³¸öʱ¼äµã¡£²»¹ý£¬Èç¹ûÐèÒª±£Ö¤Á½¸öÎļþͬ²½£¬ÕâЩÎļþϵͳ ......
1¡¢SQL Óï¾ä»ù´¡
ÏÂÃæ¸ø³öSQLÓï¾äµÄ»ù±¾½éÉÜ¡£
1.1¡¢SQLÓï¾äËùÓ÷ûºÅ
²Ù×÷·û ÓÃ; Àý×Ó
+ - ±íʾÕýÊý»ò¸ºÊý£¬ÕýÊý¿Éʡȥ + -1234.56
+ ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà¼Ó A=c+b
- ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà¼õ 34-12
* ½«Á½¸öÊý»ò±í´ïʽ½øÐÐÏà³Ë 12*34
/ ³ýÒÔÒ»¸öÊý»ò±í´ïʽ 18*11
NULL ¿ÕÖµÅÐ¶Ï Where name is null;
......