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

ORACLE³£¼ûÎÊÌâ1000ÎÊ(֮ʮ¶þ)

783. ALL_ALL_TABLES
Óû§¿É´æÈ¡µÄËùÓбí.
784. ALL_ARGUMENTS
Óû§¿É´æÈ¡µÄ¶ÔÏóµÄËùÓвÎÊý.
785. ALL_ASSOCIATIONS
Óû§¶¨ÒåµÄͳ¼ÆÐÅÏ¢.
786. ALL_BASE_TABLE_MVIEWS
Óû§¿É´æÈ¡µÄËùÓÐÎﻯÊÓͼÐÅÏ¢.
787. ALL_CATALOG
Óû§¿É´æÈ¡µÄÈ«²¿±í,ͬÒå´Ê,ÊÓÍÁºÍÐòÁÐ.
788. ALL_CLUSTER_HASH_EXPRESSIONS
Óû§¿É´æÈ¡µÄ¾Û¼¯µÄHASHº¯Êý.
789. ALL_CLUSTERS
Óû§¿É´æÈ¡µÄËùÓоۼ¯.
790. ALL_COL_COMMENTS
Óû§¿É´æÈ¡µÄ±í»òÊÓͼÉÏ×¢ÊÍ.
791. ALL_COL_PRIVS
ÁгöÁÐÉϵÄÊÚȨ,Óû§»òPUBLICÊÇÊÚÓèÕß.
792. ALL_COL_PRIVS_MADE
ÁгöÁÐÉϵÄÊÚȨ,Óû§ÊÇÊôÖ÷»òÊÚȨÕß.
793. ALL_COL_PRIVS_RECD
ÁгöÁÐÉϵÄÊÚȨ,Óû§»òPUBLICÊÇÊÚȨÕß.
794. ALL_COLL_TYPES
Óû§¿É´æÈ¡µÄÃüÃûµÄ¼¯ºÏÀàÐÍ.
795. ALL_CONS_COLUMNS
°üº¬ÔÚÔ¼Êø¶¨ÒåÖпɴæÈ¡ÁеÄÐÅÏ¢.
796. ALL_CONSTRAINTS
Áгö¿É´æÈ¡±íÉϵÄÔ¼Êø¶¨Òå.
797. ALL_CONTEXT
ÏÔʾ»î¶¯µÄÉÏÏÂÎÊÐÅÏ¢.
798. ALL_DB_LINKS
Óû§¿É´æÈ¡µÄÊý¾ÝÁ´.
799. ALL_DEF_AUDIT_OPTS
°üº¬ÔÚ¶ÔÏó½¨Á¢Ê±ËùÓ¦ÓõÄȱʡ¶ÔÏóÉó¼ÆÑ¡Ïî.
800. ALL_DEPENDENCIES
Óû§¿É´æÈ¡µÄµÄ¶ÔÏóÖ®¼äµÄÒÀÀµ¹ØÏµ.
801. ALL_DIM_HIERARCHIES
ÏÔʾάµÄ²ã´Î.
802. ALL_DIM_JOIN_KEY
ÃèÊöÁ½¸öά֮¼äµÄÁ¬½Ó.
803. ALL_DIM_LEVEL_KEY
ÃèÊöά¼¶µÄÁÐ.
804. ALL_DIM_LEVELS
ÃèÊöά¼¶±ð.
805. ALL_DIMENSIONS
°üº¬Î¬¶ÔÏóµÄÐÅÏ¢.
806. ALL_DIRECTORIES
Óû§¿É´æÈ¡µÄËùÓÐĿ¼ÃèÊö.
807. ALL_ERRORS
Óû§¿É´æÈ¡µÄËùÓжÔÏóÉϵĵ±Ç°´íÎó.
808. ALL_EXTERNAL_TABLES
Óû§¿É´æÈ¡µÄÍⲿ±í.
809. ALL_HISTOGRAMS
µÈÓÚALL_TAB_HISTOGRAMS±ðÃû.
810. ALL_IND_COLUMNS
Óû§¿É´æÈ¡µÄË÷ÒýÁÐ.
811. ALL_IND_EXPRESSIONS
Óû§¿É´æÈ¡µÄ±íÉϵŦÄÜË÷Òý±í´ïʽ.
812. ALL_IND_PARTITIONS
ΪË÷Òý·ÖÇø,ÃèÊö·ÖÇø¼¶µÄ·ÖÇøÐÅÏ¢.
813. ALL_IND_SUBPARTITONS
ΪË÷Òý×Ó·ÖÇø,ÃèÊö×Ó·ÖÇø¼¶µÄ·ÖÇøÐÅÏ¢.
814. ALL_INDEXES
Óû§¿É´æÈ¡µÄ±íÉϵÄË÷ÒýÃèÊö.
815. ALL_INDEXTYPE_COMMNETS
Óû§¿É´æÈ¡µÄÓû§¶¨ÒåµÄË÷ÒýÀàÐÍ.
816. ALL_INDEXTYPE_OPERATORS
ÏÔʾË÷ÒýÀàÐÍÖ§³ÖµÄËùÓвÙ×÷·û.
817. ALL_INDEXTYPES
ÏÔʾËùÓеÄË÷ÒýÀàÐÍ.
818. ALL_INTERNAL_TRIGGERS
Óû§¿É´æÈ¡µÄÄÚ²¿´¥·¢Æ÷.
819. ALL_JOBS
Êý¾Ý¿âÖеÄËùÓÐ×÷Òµ.
820. ALL_JOIN_IND_COLUMNS
ÃèÊöÄã´æÈ¡µÄλӳÉäÁ¬½ÓË÷ÒýµÄÁ¬½ÓÌõ¼þ.
821. ALL_LIBRARIES
Óû§¿É´æÈ¡µÄËùÓпâ.
822. ALL_LO


Ïà¹ØÎĵµ£º

oracleÐÐÁÐת»»

/* 
ÔÚʵ¼ÊʹÓÃsql¹¤×÷ÖÐ×Ü»áÅöµ½½«Ä³Ò»ÁеÄÖµ·Åµ½±êÌâÖÐÏÔʾ.¾ÍÊÇ×Ü˵µÄÐÐÁÐת»»»òÕß»¥»». 
±ÈÈçÓÐÈçÏÂÊý¾Ý: 
ID NAME       KECHENG              CHENGJI 
-- ---------- --------------- ......

OracleÖеĵȴýʼþÊÇʲô?ÈçºÎÀí½â²¢ÓÅ»¯Oracle

¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIXUNIXÉϵÄʵսÏê½â¡·¼¯ÖÐÌÖÂÛÖ®15   ¼ÌÐø×òÌìµÄ»°Ì⣬ÓÐÁËͳ¼Æ£¬Í³¼ÆÖÐÓкܶàÊǵȴýʼþ¡£µÈ´ýʼþÈçºÎÀí½â£¿Õâ¿ÉÄÜÊÇ´ó¼ÒÓʼþÖÐËù˵µÄÎÊÌâËùÔÚ¡£ µÈ´ýʼþ£¬ÊÇÖ¸µ±Ò»¸ö·þÎñÆ÷½ø³Ì/Ị̈߳¨Windowsƽ̨£©²»µÃ²»µÈºòijһ¸öʼþÍê³É£¬³ÆÖ®ÎªÒ»´Î¡°µÈ´ýʼþ¡±¡£µ±µÈ´ýµÄÕâ¸öʼþÍê³Éºóºñ£¬¸Ã· ......

ORACLE³£¼ûÎÊÌâ1000ÎÊ(Ö®ËÄ)

174. /*+ALL_ROWS*/
¡¡¡¡ ±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='CCBZZP';
¡¡¡¡ 175. /*+FIRST_ROWS*/
¡¡¡¡ ±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ¼ä,ʹ×ÊÔ´ÏûºÄ×îС»¯.ÀýÈç:
SEL ......

ORACLE³£¼ûÎÊÌâ1000ÎÊ(֮ʮһ)

645. USER_ALL_TABLES
°üº¬¶ÔÓû§¿ÉÓõıíµÄÃèÊö.
646. USER_ARGUMENTS
Áгö¶ÔÓû§¿É´æÈ¡µÄ¶ÔÏóÖеIJÎÊý.
647. USER_ASSOCIATIONS
µ±Ç°Óû§ËùÓµÓеÄÏà¹Ø¶ÔÏóµÄÓû§¶¨ÒåµÄͳ¼Æ.
648. USER_AUDIT_OBJECT
¹ØÓÚ¶ÔÏóµÄÓï¾äÉ󼯏ú×ټǼ.
649. USER_AUDIT_SESSION
¹ØÓÚÓû§Á¬½Ó»ò¶Ï¿ªµÄÈ«²¿É󼯏ú×ټǼ.
650. USER_AUD ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ