《oracle語法（oracle語法）》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在工程資料-天天文庫。

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