资源描述:
《toad tips and tricks sql editor外语英文电子书》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、TOADTipsandTricks–SQLEditorDate:Monday,October4,1999Author:SteveC.Chapman,TOADDevelopmentTeam,QuestSoftware,Inc.MoreInfo:www.toadsoft.comorwww.quest.comTABLEOFCONTENTSIsthereawaytohaveTOADlookuptablecolumnsasIconstructaquery?2HowcanIcopytablenamesintotheSQLeditor?3HowcanIcopytablecolumnnamesintot
2、heSQLeditor?3Isthereashortcutkeytopresentthecontextrightmouseclickmenu?4HowcanIgetadescriptionofanobjectwhentypingintheSQLeditor?5HowcanIuseTOADtodumpsomeOracletabledatatoanotherWindowsapplication?6CanyoulistallofthewaystogetcodeintotheSQLeditor?99“TOADTipsandTricksSQLEditor”copyright©1999byQuest
3、Software,Inc.www.toadsoft.comandwww.quest.comIsthereawaytohaveTOADlookuptablecolumnsasIconstructaquery?Yes.Whentypingatablenameorviewnameandtheperiod,pause(orpressT)togetalistofcolumnsinadropdownlist.ThisappliestoANYtableorviewthattheuserhasaccessto,includingobjectsfromotherschemas,SYS,SYST
4、EM,etc.Oncethelistappears,clickclicktomultiselectitems,thenpress.TOADwillplacethoseselectedcolumnsintotheSQLeditortobuildyourquery.selecttable_privileges.TABLE_NAME,TABLE_PRIVILEGES.SELECT_PRIV,TABLE_PRIVILEGES.INSERT_PRIVAfteraqueryhaspopulatedtheSQLResultsgrid,pressingTwillpr
5、esentadropdownlistofthecolumnsfromtheSQLResultsgrid.9“TOADTipsandTricksSQLEditor”copyright©1999byQuestSoftware,Inc.www.toadsoft.comandwww.quest.comHowcanIcopytablenamesintotheSQLeditor?YoucancopytheTable,View,orSynonymnamesfromtheTableSelectdialogtotheSQLEditorviadraganddropormultiselectlistcopy<
6、CTRL>CandpasteV.HowcanIcopytablecolumnnamesintotheSQLeditor?YoucancopycolumnnamesfromtheColumnNameSelectdialogviadraganddropormultiselectlistcopyCandpasteV.9“TOADTipsandTricksSQLEditor”copyright©1999byQuestSoftware,Inc.www.toadsoft.comandwww.quest.comIsthereashortcutkeytopresent
7、thecontextrightmouseclickmenu?Yes.PressingdisplaystherightclickmousemenuforeithertheSQLeditorortheSQLresultsgrid.9“TOADTipsandTricksSQLEditor”copyright©1999byQuestSoftware,Inc.www.toadsoft.comandwww.quest.comHowca