仓酷云
标题:
MYSQL网页设计Oracle数据字典
[打印本页]
作者:
活着的死人
时间:
2015-1-16 22:38
标题:
MYSQL网页设计Oracle数据字典
也许最好的策略是以不变应万变：给客户他们所需要的，不多也不少。如果MySQL学习教程适合他们，他们就不应该买别的工具。事实上，云计算产业一直推崇自助服务，但提供这些服务的公司已经开始认识到解决方案提供商推销他们商品的价值。oracle|数据
Oracle数据字典
Oracle数据字典
以下表格中搜集了Oracle数据字典中几近一切的视图或别号，至于每一个视图或别号的字段请用‘Describe’语句来查询。
定名申明：
Oracle数据字典中，工具称号多半以"USER."，"ALL."，"DBA."为前缀"USER."视图中纪录一般纪录实行查询的帐户所具有的工具的信息，"ALL."视图中纪录包含"USER"纪录和受权至PUBLIC或用户的工具的信息，"DBA."视图包括一切数据库工具，而不论其一切者。
利用举例：
select*fromdba_data_files
查询表空间的信息(以后用户必需具有DBA脚色)
selectowner,object_name,object_typefromall_objects
查询某一用户下的一切表、历程、函数等信息
视图名形貌
ALL_CATALOGAlltables,views,synonyms,sequencesaccessibletotheuser
ALL_COL_COMMENTSCommentsoncolumnsofaccessibletablesandviews
ALL_COL_GRANTS_MADEGrantsoncolumnsforwhichtheuserisownerorgrantor
ALL_COL_GRANTS_RECDGrantsoncolumnsforwhichtheuserorPUBLICisthegrantee
ALL_COL_PRIVSGrantsoncolumnsforwhichtheuseristhegrantor,grantee,owner,oran
enabledroleorPUBLICisthegrantee
ALL_COL_PRIVS_MADEGrantsoncolumnsforwhichtheuserisownerorgrantor
ALL_COL_PRIVS_RECDGrantsoncolumnsforwhichtheuser,PUBLICorenabledroleisthegrantee
ALL_CONSTRAINTSConstraintdefinitionsonaccessibletables
ALL_CONS_COLUMNSInformationaboutaccessiblecolumnsinconstraintdefinitions
ALL_DB_LINKSDatabaselinksaccessibletotheuser
ALL_DEF_AUDIT_OPTSAuditingoptionsfornewlycreatedobjects
ALL_DEPENDENCIESDependenciestoandfromobjectsaccessibletotheuser
ALL_ERRORSCurrenterrorsonstoredobjectsthatuserisallowedtocreate
ALL_INDEXESDescriptionsofindexesontablesaccessibletotheuser
ALL_IND_COLUMNSCOLUMNscomprisingINDEXesonaccessibleTABLES
ALL_OBJECTSObjectsaccessibletotheuser
ALL_REFRESHAlltherefreshgroupsthattheusercantouch
ALL_REFRESH_CHILDRENAlltheobjectsinrefreshgroups,wheretheusercantouchthegroup
ALL_SEQUENCESDescriptionofSEQUENCEsaccessibletotheuser
ALL_SNAPSHOTSSnapshotstheusercanlookat
ALL_SOURCECurrentsourceonstoredobjectsthatuserisallowedtocreate
ALL_SYNONYMSAllsynonymsaccessibletotheuser
ALL_TABLESDescriptionoftablesaccessibletotheuser
ALL_TAB_COLUMNSColumnsofalltables,viewsandclusters
ALL_TAB_COMMENTSCommentsontablesandviewsaccessibletotheuser
ALL_TAB_GRANTS_MADEUsersgrantsandgrantsonusersobjects
ALL_TAB_GRANTS_RECDGrantsonobjectsforwhichtheuserorPUBLICisthegrantee
ALL_TAB_PRIVSGrantsonobjectsforwhichtheuseristhegrantor,grantee,owner,oran
enabledroleorPUBLICisthegrantee
ALL_TAB_PRIVS_MADEUsersgrantsandgrantsonusersobjects
ALL_TAB_PRIVS_RECDGrantsonobjectsforwhichtheuser,PUBLICorenabledroleisthegrantee
ALL_TRIGGERSTriggersaccessibletothecurrentuser
ALL_TRIGGER_COLSColumnusageinuserstriggersorintriggersonuserstables
ALL_USERSInformationaboutallusersofthedatabase
ALL_VIEWSTextofviewsaccessibletotheuser
USER_AUDIT_CONNECTAudittrailentriesforuserlogons/logoffs
USER_AUDIT_OBJECTAudittrailrecordsforstatementsconcerningobjects,specifically:table,
cluster,view,index,sequence,[public]databaselink,[public]synonym,
procedure,trigger,rollbacksegment,tablespace,role,user
USER_AUDIT_SESSION
USER_AUDIT_STATEMENTAudittrailrecordsconcerninggrant,revoke,audit,noauditandalter
system
USER_AUDIT_TRAILAudittrailentriesrelevanttotheuser
USER_CATALOGTables,Views,SynonymsandSequencesownedbytheuser
USER_CLUSTERSDescriptionsofusersownclusters
USER_CLU_COLUMNSMappingoftablecolumnstoclustercolumns
USER_COL_COMMENTSCommentsoncolumnsofuserstablesandviews
USER_COL_GRANTSGrantsoncolumnsforwhichtheuseristheowner,grantororgrantee
USER_COL_GRANTS_MADEAllgrantsoncolumnsofobjectsownedbytheuser
USER_COL_GRANTS_RECDGrantsoncolumnsforwhichtheuseristhegrantee
USER_COL_PRIVSGrantsoncolumnsforwhichtheuseristheowner,grantororgrantee
USER_COL_PRIVS_MADEAllgrantsoncolumnsofobjectsownedbytheuser
USER_COL_PRIVS_RECDGrantsoncolumnsforwhichtheuseristhegrantee
USER_CONSTRAINTSConstraintdefinitionsonusersowntables
USER_CONS_COLUMNSInformationaboutaccessiblecolumnsinconstraintdefinitions
USER_CROSS_REFSCrossreferencesforusersviewsandsynonyms
USER_DB_LINKSDatabaselinksownedbytheuser
USER_DEPENDENCIESDependenciestoandfromausersobjects
USER_ERRORSCurrenterrorsonstoredobjectsownedbytheuser
USER_EXTENTSExtentscomprisingsegmentsownedbytheuser
USER_FREE_SPACEFreeextentsintablespacesaccessibletotheuser
USER_INDEXESDescriptionoftheusersownindexes
USER_IND_COLUMNSCOLUMNscomprisingusersINDEXesoronusersTABLES
USER_JOBSAlljobsownedbythisuser
USER_OBJECTSObjectsownedbytheuser
USER_OBJECT_SIZESizes,inbytes,ofvariouspl/sqlobjects
USER_OBJ_AUDIT_OPTSAuditingoptionsforusersowntablesandviews
USER_REFRESHAlltherefreshgroups
USER_REFRESH_CHILDRENAlltheobjectsinrefreshgroups,wheretheuserownsthe
refreshgroup
USER_RESOURCE_LIMITSDisplayresourcelimitoftheuser
USER_ROLE_PRIVSRolesgrantedtocurrentuser
USER_SEGMENTSStorageallocatedforalldatabasesegments
USER_SEQUENCESDescriptionoftheusersownSEQUENCEs
USER_SNAPSHOTSSnapshotstheusercanlookat
USER_SNAPSHOT_LOGSAllsnapshotlogsownedbytheuser
USER_SOURCESourceofstoredobjectsaccessibletotheuser
USER_SYNONYMSTheusersprivatesynonyms
USER_SYS_PRIVSSystemprivilegesgrantedtocurrentuser
USER_TABLESDescriptionoftheusersowntables
USER_TABLESPACESDescriptionofaccessibletablespaces
USER_TAB_AUDIT_OPTSAuditingoptionsforusersowntablesandviews
USER_TAB_COLUMNSColumnsofuserstables,viewsandclusters
USER_TAB_COMMENTSCommentsonthetablesandviewsownedbytheuser
USER_TAB_GRANTSGrantsonobjectsforwhichtheuseristheowner,grantororgrantee
USER_TAB_GRANTS_MADEAllgrantsonobjectsownedbytheuser
USER_TAB_GRANTS_RECDGrantsonobjectsforwhichtheuseristhegrantee
USER_TAB_PRIVSGrantsonobjectsforwhichtheuseristheowner,grantororgrantee
USER_TAB_PRIVS_MADEAllgrantsonobjectsownedbytheuser
USER_TAB_PRIVS_RECDGrantsonobjectsforwhichtheuseristhegrantee
USER_TRIGGERSTriggersownedbytheuser
USER_TRIGGER_COLSColumnusageinuserstriggers
USER_TS_QUOTASTablespacequotasfortheuser
USER_USERSInformationaboutthecurrentuser
USER_VIEWSTextofviewsownedbytheuser
AUDIT_ACTIONSDescriptiontableforaudittrailactiontypecodes.Mapsactiontype
numberstoactiontypenames
COLUMN_PRIVILEGESGrantsoncolumnsforwhichtheuseristhegrantor,grantee,owner,or
anenabledroleorPUBLICisthegrantee
DICTIONARYDescriptionofdatadictionarytablesandviews
DICT_COLUMNSDescriptionofcolumnsindatadictionarytablesandviews
DUAL
GLOBAL_NAMEglobaldatabasename
INDEX_HISTOGRAMstatisticsonkeyswithrepeatcount
INDEX_STATSstatisticsontheb-tree
RESOURCE_COSTCostforeachresource
ROLE_ROLE_PRIVSRoleswhicharegrantedtoroles
ROLE_SYS_PRIVSSystemprivilegesgrantedtoroles
ROLE_TAB_PRIVSTableprivilegesgrantedtoroles
SESSION_PRIVSPrivilegeswhichtheusercurrentlyhasset
SESSION_ROLESRoleswhichtheusercurrentlyhasenabled.
TABLE_PRIVILEGESGrantsonobjectsforwhichtheuseristhegrantor,grantee,owner,or
anenabledroleorPUBLICisthegrantee
ACCESSIBLE_COLUMNSSynonymforALL_TAB_COLUMNS
ALL_COL_GRANTSSynonymforCOLUMN_PRIVILEGES
ALL_JOBSSynonymforUSER_JOBS
ALL_TAB_GRANTSSynonymforTABLE_PRIVILEGES
CATSynonymforUSER_CATALOG
CLUSynonymforUSER_CLUSTERS
COLSSynonymforUSER_TAB_COLUMNS
DBA_AUDIT_CONNECTSynonymforUSER_AUDIT_CONNECT
DBA_AUDIT_RESOURCESynonymforUSER_AUDIT_RESOURCE
DBA_REFRESH_CHILDRENSynonymforUSER_REFRESH_CHILDREN
DICTSynonymforDICTIONARY
INDSynonymforUSER_INDEXES
OBJSynonymforUSER_OBJECTS
SEQSynonymforUSER_SEQUENCES
SM$VERSIONSynonymforSM_$VERSION
SYNSynonymforUSER_SYNONYMS
TABSSynonymforUSER_TABLES
V$ACCESSSynonymforV_$ACCESS
V$ARCHIVESynonymforV_$ARCHIVE
V$BACKUPSynonymforV_$BACKUP
V$BGPROCESSSynonymforV_$BGPROCESS
V$CIRCUITSynonymforV_$CIRCUIT
V$COMPATIBILITYSynonymforV_$COMPATIBILITY
V$COMPATSEGSynonymforV_$COMPATSEG
V$CONTROLFILESynonymforV_$CONTROLFILE
V$DATABASESynonymforV_$DATABASE
V$DATAFILESynonymforV_$DATAFILE
V$DBFILESynonymforV_$DBFILE
V$DBLINKSynonymforV_$DBLINK
V$DB_OBJECT_CACHESynonymforV_$DB_OBJECT_CACHE
V$DISPATCHERSynonymforV_$DISPATCHER
V$ENABLEDPRIVSSynonymforV_$ENABLEDPRIVS
V$FILESTATSynonymforV_$FILESTAT
V$FIXED_TABLESynonymforV_$FIXED_TABLE
V$LATCHSynonymforV_$LATCH
V$LATCHHOLDERSynonymforV_$LATCHHOLDER
V$LATCHNAMESynonymforV_$LATCHNAME
V$LIBRARYCACHESynonymforV_$LIBRARYCACHE
V$LICENSESynonymforV_$LICENSE
V$LOADCSTATSynonymforV_$LOADCSTAT
V$LOADTSTATSynonymforV_$LOADTSTAT
V$LOCKSynonymforV_$LOCK
V$LOGSynonymforV_$LOG
V$LOGFILESynonymforV_$LOGFILE
V$LOGHISTSynonymforV_$LOGHIST
V$LOG_HISTORYSynonymforV_$LOG_HISTORY
V$MLS_PARAMETERSSynonymforV_$MLS_PARAMETERS
V$MTSSynonymforV_$MTS
V$NLS_PARAMETERSSynonymforV_$NLS_PARAMETERS
V$NLS_VALID_VALUESSynonymforV_$NLS_VALID_VALUES
V$OPEN_CURSORSynonymforV_$OPEN_CURSOR
V$OPTIONSynonymforV_$OPTION
V$PARAMETERSynonymforV_$PARAMETER
V$PQ_SESSTATSynonymforV_$PQ_SESSTAT
V$PQ_SLAVESynonymforV_$PQ_SLAVE
V$PQ_SYSSTATSynonymforV_$PQ_SYSSTAT
V$PROCESSSynonymforV_$PROCESS
V$QUEUESynonymforV_$QUEUE
V$RECOVERY_LOGSynonymforV_$RECOVERY_LOG
V$RECOVER_FILESynonymforV_$RECOVER_FILE
V$REQDISTSynonymforV_$REQDIST
V$RESOURCESynonymforV_$RESOURCE
V$ROLLNAMESynonymforV_$ROLLNAME
V$ROLLSTATSynonymforV_$ROLLSTAT
V$ROWCACHESynonymforV_$ROWCACHE
V$SESSIONSynonymforV_$SESSION
V$SESSION_CURSOR_CACHESynonymforV_$SESSION_CURSOR_CACHE
V$SESSION_EVENTSynonymforV_$SESSION_EVENT
V$SESSION_WAITSynonymforV_$SESSION_WAIT
V$SESSTATSynonymforV_$SESSTAT
V$SESS_IOSynonymforV_$SESS_IO
V$SGASynonymforV_$SGA
V$SGASTATSynonymforV_$SGASTAT
V$SHARED_SERVERSynonymforV_$SHARED_SERVER
V$SQLAREASynonymforV_$SQLAREA
V$STATNAMESynonymforV_$STATNAME
V$SYSSTATSynonymforV_$SYSSTAT
V$SYSTEM_CURSOR_CACHESynonymforV_$SYSTEM_CURSOR_CACHE
V$SYSTEM_EVENTSynonymforV_$SYSTEM_EVENT
V$THREADSynonymforV_$THREAD
V$TIMERSynonymforV_$TIMER
V$TRANSACTIONSynonymforV_$TRANSACTION
V$TYPE_SIZESynonymforV_$TYPE_SIZE
V$VERSIONSynonymforV_$VERSION
V$WAITSTATSynonymforV_$WAITSTAT
V$_LOCKSynonymforV_$_LOCK
一些典型的RDBMS功能并不总是在DBaaS系统中可用。例如MySQL学习教程，WindowsAzureSQLDatabase(以前的SQLAzure)是微软的DBaaS产品，提供了一个类似于SQLServer的数据库平台。
作者:
海妖
时间:
2015-1-18 09:58
无法深入到数据库系统层面去了解和探究
作者:
再现理想
时间:
2015-1-21 18:51
一个是把SQL语句写到客户端,可以使用DataSet进行加工;
作者:
灵魂腐蚀
时间:
2015-1-30 21:50
代替了原来VB式的错误判断。比Oracle高级不少。
作者:
若天明
时间:
2015-2-6 16:10
如果我们从集合论（关系代数）的角度来看，一张数据库的表就是一组数据元的关系，而每个SQL语句会改变一种或数种关系，从而产生出新的数据元的关系（即产生新的表）。
作者:
柔情似水
时间:
2015-2-17 02:49
不好!如果出了错;不好调试;不好处理!其实web开发将代码分为3层:web层;业务逻辑层和数据访问层;一般对数据库的操作都在数据访问层来做;这样便于调试和维护!而且将来如果是换了数据库的话;你只需要改数据层的代码;其他层的基本可以不变!要是你在jsp中直接调用sql数据库;那么如果换了数据库呢?岂不都要改?如果报了异常呢?怎么做异常处理?
作者:
透明
时间:
2015-3-5 14:52
其实可以做一下类比，Oracle等数据库产品老早就支持了java编程，而且提供了java池参数作为用户配置接口。但是现在有哪些系统大批使用了java存储过程？！连Oracle自己的应用都不用为什么？！
作者:
不帅
时间:
2015-3-12 08:19
我个人认为就是孜孜不懈的学习
作者:
若相依
时间:
2015-3-19 19:17
索引视图2k就有。但是2005对其效率作了一些改进但是schema.viewname的作用域真是太限制了它的应用面。还有一大堆的环境参数和种种限制都让人对它有点却步。
欢迎光临 仓酷云 (http://ckuyun.com/)
Powered by Discuz! X3.2