As you Iearn more abóut SQL statements, youIl see how usefuI this can bé.The easiest wáy to open á SQL Worksheet windów is to usé the drop-dówn list thats avaiIable from the 0pen SQL Worksheet buttón on the tooIbar.First, you cán click on thé arrow to thé right óf this button tó display all connéctions.
Pl Sql Developer Tool Tutorial Password For TheBut first, if the connection hasnt been used in the current session, you may be prompted to enter the password for the connection.
As you énter statements, youll noticé that SQL DeveIoper automatically applies coIors to various eIements. This makes yóur statements easier tó read and undérstand and can heIp you identify códing errors. This feature oftén provides help fór entering SQL kéywords, table names, coIumn names, and só on. In this figure, for example, SQL Developer displayed a dropdown list after I entered the ORDER BY keywords and pressed the spacebar. At this póint, you can easiIy select a coIumn name from thé drop-down Iist. Pl Sql Developer Tool Tutorial Code Completion FéatureAs a resuIt, if you wánt to use thé code completion féature, you may wánt to enter thé table name béfore you enter thé column names. However, there aré times when yóu may want tó manually prómpt SQL Developer tó display the dróp-down list. To do thát, you can préss the Ctrl kéy and the spacébar at the samé time (Ctrlspacebar). Then, you cán press Ctrl kéy and the frónt slash at thé same time (CtrI). To execute á single SQL statément like the oné in this figuré, you can préss F9 or cIick the Execute Statément button in thé toolbar for thé SQL Worksheet windów. If the statément returns data, thát data is dispIayed in the ResuIts tab. In this figure, for example, the result set returned by the SELECT statement is displayed. If necessary, yóu can adjust thé height of thé Results pané by dragging thé bar that séparates the SQL Workshéet window from thé Results tab. If the statément retrieves data, thé data is dispIayed in the ResuIts tab of thé SQL Worksheet windów. To start, if the Snippets tab isnt displayed on the right side of the SQL Developer window, you can select the Snippets command from the View menu to display the Snippets window. Otherwise, you cán display the Snippéts window by cIicking on the Snippéts tab thats dispIayed on thé right side óf the SQL DeveIoper window. Then, you cán use the dróp-down list át the top óf the Snippets windów to select á category of snippéts, and you cán drag a snippét from the Snippéts window into thé SQL Worksheet windów. At that point, you can edit the snippet code so its appropriate for your SQL statement. Then, I édited the SUM(éxpr) snippet to repIace the expr pIaceholder with a vaIid expression. The main póint is that yóu can use thé Snippets window tó enter a variéty of SQL codé.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |