oracle语法（oracle语法）

《oracle语法（oracle语法）》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、oracle语法（oracle语法）BasicconceptsDDLdatadefinitionlanguage-buildingdatabaseobjectsCreate/alter/drop/truncateDMLdatamanipulationlanguage-dataviewandmaintenanceSelect/insert/delete/updateTCLtransactioncontrollanguage-whetherdataissavedtothedatabaseCommit/rollbac

2、k/savepointDCLdatacontrollanguage--viewthepermissionsofobjectsGrant/revokeDatabasedesignCompositionofrelationaldatamodelOneormoresheetsTableindexviewtriggerTherelationbetweentableandtableDatabaseSchemaConceptually:agroupofDDLPhysical:anamespacethatcontainsta

3、bles,processes,viewscollectionsCommoncommandsConnectusername/passwordconnectedtothespecifieduserThestructureofdesctab_nameviewtabletab_nameQuit/exitexitClearscreenclearscreenSetlinesize200setsonelineanddisplays200charactersSetPageSize20sets20linesperpageDbms

4、_output.put_line()print,similartoSystem.out.println();Setserveroutputonopenstheserveroutput,otherwisetheaboveprintstatementiswrongEditeditsthestatementsinthecacheExecutethelaststatementblock/repeatableexecution@sqlpathexecutesaSQLfile@@sqlfileimplementationo

5、fthesqlpathenvironmentvariablefileSpoolfileprintlogtotextfileSpooloffstopprintingIntheprocessof#entertheSQLstatementinthetemporaryfirstrunasql*pluscommandLookatthesizeoftheshortcharactersSELECTDBMS_LOB.GETLENGTH(MYCLOB)FROMATTACHMENT;//MYCLOBiscolumnname,and

6、ATTACHMENTistablenameSELECTDBMS_LOB.GETLENGTH(MYBLOB)FROMATTACHMENT;CommontablesUser_constraintsuserconstraintsUser_tablesusertableAll_all_tablesallusertablesAll_constraintsallconstraintsUser_cons_columnsconstraintcolumnAll_cons_columnsallconstraintcolumnsNl

7、s_session_parameterscurrentsessioninformationV$nls_parameterssystemparametersdatatypeCharacterCharmaximum2000bytesfixedlengthVARCHAR2maximum4000byteslongerNumerictypeThe-38secondorderofnumber10to10ofthe38canrepresentdecimal,alsocanrepresentintegerDate,Dateco

8、ntainsthedateandtimeeveryminute7bytesLargeobjectCLOBcharacterlargeobject>4000bytemaximum4GBlobbinarylargeobjectimage/sound4GPseudotype%typecanrefertothetypeofacolumn%rowtypecanrefertoatableasaty