<!-- saved from url=(0022)http://internet.e-mail --> <html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=unicode"> <title>Sailora - PL/SQL Developer Plug-Ins</title> <meta name="keywords" content="plugins, plug-ins, pl/sql developer tools"> <style> <!-- div { margin-top: 0px; margin-bottom: 0px; } .wpmd {font-size: 13px;font-family: 'Arial';font-style: normal;font-weight: normal;} .style3 { font-size: 16px; font-weight: bold; } .style6 {font-size: 12px} .style5 { font-size: 12px; font-weight: bold; } --> </style> <meta name="description" content="PlugIns for PL/SQL Developer"> </head> <body topmargin="0"> <table border="0" width="100%" id="table1" cellspacing="0" cellpadding="0"> <tr> <td width="382" align="right"> <div style="position: absolute; width: 417px; height: 69px; z-index: 1; left: 12px; top: 46px; float: left" id="layer1"> <p align="left"><b> <font size="6" face="Comic Sans MS" color="#FFFFFF">PowerBuilder Library Soft</font></b></div> <object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" id="obj1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" border="0" width="420" height="149"> <param name="movie" value="http://www.pblsoft.com/pblImages/arrowhead.swf"> <param name="quality" value="High"> <param name="menu" value="false"> <param name="wmode" value="transparent"> <param name="salign" value="TR"> <embed src="http://www.pblsoft.com/pblImages/arrowhead.swf" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj1" width="420" height="149" quality="High" menu="false" wmode="transparent" salign="TR"></object> </td> <td align="left" valign="top" width="340"> <div style="position: absolute; width: 332px; height: 70px; z-index: 2; left: 434px; top: 45px" id="layer2"> <p align="left">&nbsp;</div> <img border="0" src="http://www.pblsoft.com/pblImages/b001main_right.jpg" width="340" height="148"></td> <td align="left" valign="top" width="100%" background="http://www.pblsoft.com/pblImages/main_right_01.jpg" bgcolor="#0000FF">&nbsp;</td> </tr> </table> <table border="0" width="100%" id="table2" height="47" cellspacing="0" cellpadding="0"> <tr> <td background="http://www.pblsoft.com/pblImages/users_feedback_s.gif" width="188"> <table border="0" width="187" id="table4" cellspacing="0" cellpadding="0"> <tr> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </table> </td> <td background="http://www.pblsoft.com/pblImages/topmenu_img1.gif" width="28"> <table border="0" width="28" id="table5"> <tr> <td>&nbsp;</td> </tr> </table> </td> <td background="http://www.pblsoft.com/pblImages/products_b.gif" width="85%"> <table border="0" width="100%" id="table3"> <tr> <td width="125">&nbsp;</td> <td width="118">&nbsp;</td> <td width="119">&nbsp;</td> <td width="125">&nbsp;</td> <td width="63">&nbsp;</td> <td valign="bottom"><b>&nbsp;</b></td> </tr> </table> </td> </tr> </table> <table border="0" width="100%" id="table13" cellspacing="0" cellpadding="0" height="2918"> <tr> <td width="186" align="left" valign="top"> <table border="0" width="187" id="table17" height="297" cellspacing="0" cellpadding="0"> <tr> <td height="91" background="http://www.pblsoft.com/pblImages/new_releases_bg.gif" valign="top" width="186"> <table border="0" width="112%" id="table18"> <tr> <td height="30"><b> <span style="text-decoration: none"> <font color="#800080" face="Tahoma" size="2">About Sailora</font></span></b></td> </tr> <tr> <td height="30"><b> <span style="text-decoration: none"> <a href="#version update"> <font color="#800080" face="Tahoma" size="2"> <span style="text-decoration: none">Version update</span></font></a></span></b></td> </tr> <tr> <td height="30"><b> <span style="text-decoration: none"> <font color="#800080" face="Tahoma" size="2"> <a href="#features"><font color="#800080"> <span style="text-decoration: none">Features</span></font></a></font></span></b></td> </tr> <tr> <td height="30"><b><span style="text-decoration: none"> <font color="#800000" face="Tahoma" size="2"> <a href="mailto:singlesail@gmail.com?subject=About SailOra"> <span style="text-decoration: none"> <font color="#800080">contact</font></span></a></font></span></b></td> </tr> <tr> <td height="30"><b> <font color="#800000" face="Tahoma" size="2"> <a href="index.htm"> <span style="text-decoration: none"> <font color="#800080">Home</font></span></a></font></b></td> </tr> </table> <p>&nbsp;</td> </tr> <tr> <td background="http://www.pblsoft.com/pblImages/new_releases_s.gif" height="22"> <table border="0" width="104%" id="table19" height="28"> <tr> <td><b><font color="#800000" face="Tahoma" size="2"> <a href="index.htm"> <span style="text-decoration: none"> <font color="#800080">Menus Functions</font></span></a><font color="#800080"> Help</font></font></b></td> </tr> </table> </td> </tr> <tr> <td background="http://www.pblsoft.com/pblImages/new_releases_bg.gif" valign="top"> <table border="0" width="100%" id="table30"> <tr> <td height="30"><font face="Tahoma" size="2"> <span style="text-decoration: none"> <a href="#configure"><font color="#000000"> <span style="text-decoration: none"> <img border="0" src="http://www.pblsoft.com/sailora/smalls.jpg" width="27" height="16">Configure</span></font></a></span></font></td> </tr> <tr> <td height="30"> <a href="#savecurrent"><font color="#000000"> <span style="text-decoration: none"> <img border="0" src="sqladd.bmp" width="24" height="24"></span></font><span style="text-decoration: none"><font color="#000000" face="Tahoma" size="2">Save Current...</font></span></a></td> </tr> <tr> <td height="30"><font face="Tahoma" size="2"> <span style="text-decoration: none"> <a href="#saveallsql"><font color="#000000"> <span style="text-decoration: none"> <img border="0" src="savewins.bmp" width="24" height="24">Save All SQL in opened wins</span></font></a></span></font></td> </tr> <tr> <td height="30"><font face="Tahoma" size="2"> <span style="text-decoration: none"> <a href="#getsaved"><font color="#000000"> <span style="text-decoration: none"> <img border="0" src="sqlout.bmp" width="24" height="24">Get out SQL from saved...</span></font></a></span></font></td> </tr> <tr> <td><font face="Tahoma" size="2"> <span style="text-decoration: none"> <a href="#myfunctions"><font color="#000000"> <span style="text-decoration: none"> <img border="0" src="myfuncs.bmp" width="24" height="24">My defined functions</span></font></a></span></font></td> </tr> </table> <table border="0" width="100%" id="table20" height="135"> <tr> <td style="margin-right: 0; margin-top: 0; margin-bottom: 0"> <font face="Tahoma" size="2"> <a href="#windowslistcolor"> <span style="text-decoration: none"> <font color="#000000"> <img border="0" src="colored.bmp" width="20" height="20">Windows list color...</font></span></a></font></td> </tr> <tr> <td style="margin-right: 0; margin-top: 0; margin-bottom: 0"> <font face="Tahoma" size="2"> <a href="#cellselected"> <span style="text-decoration: none"> <font color="#000000"> <img border="0" src="cellrect.bmp" width="20" height="20">Selected cells in grid</font></span></a></font></td> </tr> <tr> <td style="margin-right: 0; margin-top: 0; margin-bottom: 0"> <font face="Tahoma" size="2"> <a href="#highlighteditor"> <span style="text-decoration: none"> <font color="#000000"> <img border="0" src="HighLight.bmp" width="20" height="20">Highlight selected in Editor</font></span></a></font></td> </tr> <tr> <td style="margin-right: 0; margin-top: 0; margin-bottom: 0"> <font face="Tahoma" size="2"> <a href="#autoselectrun"> <span style="text-decoration: none"> <font color="#000000"> <img border="0" src="selectrun.bmp" width="24" height="24">Auto select and run</font></span></a></font></td> </tr> <tr> <td><font face="Tahoma" size="2"> <a href="#callsearch"> <span style="text-decoration: none"> <font color="#000000"> <img border="0" src="FindSeled.bmp" width="20" height="20">Find current selected in Editor</font></span></a></font></td> </tr> <tr> <td><font face="Tahoma" size="2"> <a href="#closeallnoask"> <span style="text-decoration: none"> <font color="#000000"> <img border="0" src="closeall.bmp" width="24" height="24">Close all fast with no ask</font></span></a></font></td> </tr> <tr> <td><font face="Tahoma" size="2"> <a href="#fastbrowse"> <span style="text-decoration: none"> <font color="#000000"> <img border="0" src="mybrowse.bmp" width="24" height="24">Fast browse</font></span></a></font></td> </tr> <tr> <td><font face="Tahoma" size="2"> <span style="text-decoration: none"> <a href="#dataexplore"> <font color="#000000"> <img border="0" src="datafastview.bmp" width="20" height="20"> Data Explore</font></a></span></font></td> </tr> <tr> <td><font face="Tahoma" size="2"> <span style="text-decoration: none"> <a href="#fusionchart"> <font color="#000000"> <img border="0" src="dbinf.bmp" width="24" height="24">Generate FusionChart</font></a></span></font></td> </tr> <tr> <td><font face="Tahoma" size="2"> <span style="text-decoration: none"> <a href="#Field-Value_Position_"> <font color="#000000"> <img border="0" src="fieldvalue.bmp" width="24" height="24">Field&lt;-&gt;Value Position</font></a></span></font></td> </tr> <tr> <td>&nbsp;</td> </tr> <tr> <td>&nbsp;</td> </tr> </table> </td> </tr> </table> </td> <td valign="top"> <table border="1" width="100%" id="table22" height="301" bordercolor="#C0C0C0" cellpadding="0" bordercolordark="#FFFFFF" style="border-collapse: collapse"> <tr> <td width="100%"> <table border="0" width="100%" id="table23" height="2837" cellpadding="6"> <tr> <td width="870" colspan="3" height="34" background="http://www.pblsoft.com/pblImages/botmenu_bg.gif"> <a href="pblcompare/index.htm"><b> <font face="Tahoma" size="4" color="#800080"> <span style="text-decoration: none">Sailora</span></font></b></a><b><font face="Tahoma" color="#333399" size="4"><a href="pblcompare/index.htm"><span style="text-decoration: none"><font color="#800000"> </font></span></a></font> <font face="Tahoma" size="2" color="#800000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font> <font face="Tahoma" size="2" color="#800080">--PL/SQL Developer Plug-Ins</font></b></td> <td rowspan="12" width="1%">&nbsp;</td> <td rowspan="12" width="20%" valign="top"> &nbsp;</td> </tr> <tr> <td width="775" colspan="2" height="167"> <p style="margin-top: 6px">&nbsp;<p> <font face="Arial" color="#800080"><span class="style3">Description:</span></font></p> <p style="margin-top: 6px"><font face="Tahoma" size="2">SailOra is a Plug-Ins for PL/SQL Developer.</font><p style="margin-top: 6px"> <font face="Tahoma" size="2">It include IDE extends functions and special tools for developers.<br> &nbsp;</font><p style="margin-top: 6px"><font face="Tahoma" size="2">The page was in building......</font><p style="margin-top: 6px"> <font face="Tahoma" size="2">If you have any question, please contact me.</font><p style="margin-top: 6px">&nbsp;<p>&nbsp;</td> <td width="25%" height="167"> <p align="center"><font face="Tahoma" size="2"> <a href="sailora.zip"> <img border="0" src="http://www.pblsoft.com/sailora/sailm.png"></a></font><p align="center"> <font face="Tahoma" size="2"> <span style="text-decoration: none"> <a href="sailora.zip"><font color="#800080"> download free ver0.60(Beta)</font></a></span></font><p align="center"> <font face="Tahoma" size="2" color="#800080"> <a href="sailora64.zip">download free ver0.60(Beta 64Bit)</a></font><p align="center"> &nbsp;</td> </tr> <tr> <td width="999" colspan="3" height="205" valign="top"> <table border="0" width="100%" id="table32" cellspacing="0" cellpadding="0"> <tr> <td width="11">&nbsp;</td> <td><font face="Tahoma" size="2" color="#800080"><b>&nbsp;&nbsp; Features:<a name="features"></a></b></font><ul> <li><font face="Tahoma" size="2" color="#800080">The knowledge base.,Allows you to easily store and retrieve frequently used code.&nbsp; ...</font></li> <li><font face="Tahoma" size="2" color="#800080">IDE extends...</font></li> <li><font face="Tahoma" size="2" color="#800080">...</font></li> <li><font face="Tahoma" size="2" color="#800080">...</font></li> </ul> <p><font face="Tahoma" size="2" color="#800080">. <img border="0" src="screenshot.jpg" width="701" height="323"></font><p>&nbsp;</td> </tr> </table> </td> </tr> <tr> <td width="870" colspan="3" height="40" background="http://www.pblsoft.com/pblImages/botmenu_bg.gif"> <b><font color="#800080" face="Tahoma" size="2"> <span style="text-decoration: none">Version update<a name="version update"></a></span></font></b></td> </tr> <tr> <td height="78" colspan="3"> <p style="color: rgb(0, 0, 0); font-family: Simsun; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"> <font face="Tahoma" size="2"><b><font color="#800080">&nbsp;&nbsp;&nbsp; Ver0.60(Beta):</font></b></font></p> <ul style="color: rgb(0, 0, 0); font-family: Simsun; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"> <li><font face="Tahoma" size="2">Add windows 64Bit dll for plsql dev 64bit</font></li> <li><font face="Tahoma" size="2">Fixed bugs.</font></li> </ul> <p style="color: rgb(0, 0, 0); font-family: Simsun; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"> <font face="Tahoma" size="2"><b><font color="#800080">&nbsp;&nbsp;&nbsp; Ver0.59(Beta):</font></b></font></p> <ul style="color: rgb(0, 0, 0); font-family: Simsun; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"> <li><font face="Tahoma" size="2">Add function &quot;Field&lt;-&gt;Values position&quot; which can position table column name and its value in SQL like follow statement</font></li> <li><font face="Tahoma" size="2">&quot;Insert into ta(f1,f2,f3) values(&#39;a1&#39;,&#39;a2,3)&quot;</font></li> <li><font face="Tahoma" size="2">&quot;Insert into ta(f1,f2,f3) select &#39;a1&#39;,&#39;a2,3 from dual&quot;</font></li> <li><font face="Tahoma" size="2">&quot;update ta set (f1,f2,f3) = (select 1,2,3 from dual)&quot;</font></li> <li><font face="Tahoma" size="2">&quot;select f1, f2, f3 into v1, v2, v3 from ta&quot;.....</font></li> </ul> <p style="color: rgb(0, 0, 0); font-family: Simsun; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"> <font face="Tahoma" size="2"><b><font color="#800080">&nbsp;&nbsp;&nbsp; Ver0.58(Beta):</font></b></font></p> <ul style="color: rgb(0, 0, 0); font-family: Simsun; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"> <li><font face="Tahoma" size="2">Fix bug:&quot;Layout page&quot; can not add items</font></li> <li><font face="Tahoma" size="2">Fix bug:SQLBook store large text script with unexpect code in tail.</font></li> </ul> <p style="color: rgb(0, 0, 0); font-family: Simsun; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"> <font face="Tahoma" size="2"><b><font color="#800080">&nbsp;&nbsp;&nbsp; Ver0.55(Beta):</font></b></font></p> <ul style="color: rgb(0, 0, 0); font-family: Simsun; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"> <li><font face="Tahoma" size="2">Add function &quot;Generate FusionChart&quot;&nbsp;and &quot;tns_lang list set&quot;</font></li> </ul> <p><font face="Tahoma" size="2"><b><font color="#800080">&nbsp;&nbsp;&nbsp; Ver0.52(Beta):</font></b></font></p> <ul> <li><font face="Tahoma" size="2">Add function "Generate FusionChart&quot;</font></li> </ul> <p style="margin-top: 6px"> <p><font face="Tahoma" size="2"><b><font color="#800080">&nbsp;&nbsp;&nbsp; Ver0.51(Beta):</font></b></font></p> <ul> <li><font face="Tahoma" size="2">Add function "Data Explorer"</font></li> </ul> </td> </tr> <tr> <td height="78" colspan="3"> <p style="margin-top: 6px"> <p><font face="Tahoma" size="2"><b><font color="#800080">&nbsp;&nbsp;&nbsp; Ver0.5(Beta):</font></b></font></p> <ul> <li><font face="Tahoma" size="2">Release</font></li> </ul> </td> </tr> <tr> <td width="870" colspan="3" height="30" background="http://www.pblsoft.com/pblImages/botmenu_bg.gif"> <b><font face="Tahoma" size="2" color="#800080">Help Contents</font><span style="text-decoration: none"><font color="#800080" face="Tahoma" size="2"><a name="screenshot"></a></font></span></b></td> </tr> <tr> <td width="1200" colspan="3" height="1723" valign="top"> <table border="1" id="table33" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><span style="text-decoration: none"> <font face="Tahoma" size="2"> <img border="0" src="smalls.jpg" width="26" height="16"></font><span class="style3"><font face="Arial">Configure<a name="configure"></a></font></span></span></p> <p><font face="Tahoma" size="2" color="#000000"> <span style="text-decoration: none"> <img border="0" src="config.jpg" width="400" height="380"> </span></font> <img border="0" src="config1.jpg" width="400" height="382"></p> <p><b><font face="Tahoma" size="2">WindowsList Options</font></b></p> <p><font face="Tahoma" size="2">In the page [WindowsList Options], there is seven types can be colorized. Select one type, and define its font from right options.</font></p> <p><font face="Tahoma" size="2">You can define font style(bold or italic) and font color. Double click panel, it will popup color dialog to select.</font></p> <p><font face="Tahoma" size="2">Default button will set font to main font of pl/sql developer.</font></p> <p><font face="Tahoma" size="2">Advance button will call font dialog to set font properties.</font></p> <p><b><font face="Tahoma" size="2">Editor Settings</font></b><p> <font face="Tahoma" size="2"><b>HighLight Background Color</b>: You can set Highlight color by double click &quot;Double Click&quot; region.</font><p> <font face="Tahoma" size="2"><b>Enabled &quot;if then...end if&quot; checkbox</b>: If the checkbox in checked status, then after you input &quot;then&quot; in &quot;if ... then&quot; statement, Editor will auto append &quot;end if;&quot; on the next line left align with &quot;if&quot;. This is almost same like &quot;autoreplace&quot; of pl/sql developer but follow diffrent.</font><p> <font face="Tahoma" size="2">1. Start replace after &quot;if&quot; or &quot;then&quot;.</font><p><font face="Tahoma" size="2">2. Append &quot;end if;&quot; left align with &quot;if&quot; or &quot;then&quot;.</font><p> <font face="Tahoma" size="2"><b>Close all windows with Confirm</b>:If you feel anoyned with &quot;do you want save&quot; dialog when you close pl/sql developer program, you can use sailora function &quot;Close all fast&quot; to close the program. But if you want to know if it has things need to save or not, check the box will show you a dialog once to confirm if it need to save.</font><p>&nbsp;</td> </tr> </table> <table border="1" id="table34" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td valign="baseline"> <p align="left"> <img border="0" src="sqladd.bmp" width="24" height="24"><span class="style3"><font face="Arial"> Save Current <a name="savecurrent"></a> </font></span></p> <p align="left"> <img border="0" src="saveinput.jpg" width="500" height="329"><p> <font face="Tahoma" size="2">If you want to save current SQL or scripts of Editor, you can use this function.</font><p> <font face="Tahoma" size="2">The selected scripts will auto paste into the &quot;Save Input&quot; dialog. if there is no selected, then all scripts in editor will paste into the dialog.</font><p> <font face="Tahoma" size="2">Defaultly, It will save into &quot;Temp&quot; file, If you select oracle tips, then the content will save into oracle tips file.</font></td> </tr> </table> <table border="1" id="table35" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><span style="text-decoration: none"> <font face="Tahoma" size="2"> <img border="0" src="savewins.bmp" width="24" height="24"></font><span class="style3"><font face="Arial">Save All SQL in opened windows<a name="saveallsql"></a></font></span></span></p> <p align="left"> <img border="0" src="inputbox.jpg" width="246" height="147"></p> <p><font face="Tahoma" size="2">This function will auto save all opened window scripts into Temp file. The inputbox need input the title to identify this save. and the content will display in the page title when you want to get out the save(See follow Tabpage with &quot;2014-06-04,&quot;).</font></p> <p><font face="Tahoma" size="2">Defaultly, the date will auto fill the editor, you can change it to any you want.</font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table36" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><span style="text-decoration: none"> <font face="Tahoma" size="2"> <img border="0" src="sqlout.bmp" width="24" height="24"></font><span class="style3"><font face="Arial">Get out SQL from saved...<a name="getsaved"></a></font></span></span></p> <p align="left"> <img border="0" src="mybooks.jpg" width="600" height="306"></p> <p><font face="Tahoma" size="2">You can get out the saved use this function. Tips will in the first page and Temp in the second page. These two page was fixed.</font></p> <p><font face="Tahoma" size="2">If you have saved use &quot;Save all SQL&quot; function, it will in the third page or later. </font></p> <p><font face="Tahoma" size="2">You can edit the saved contents and then save it use the &quot;Save&quot; button.</font></p> <p><font face="Tahoma" size="2">&quot;Get out&quot; button will get out content in editor and paste it into the Current Editor of PL/SQL developer.</font></p> <p><font face="Tahoma" size="2">&quot;Get out in new window&quot; button like &quot;Get out&quot; button but will new a SQL window and paste the content.</font></p> <p><font face="Tahoma" size="2">&quot;Exit&quot; button just close the dialog.</font></p> <p><font face="Tahoma" size="2">You can right click the list item in left and it will popup menu let you &quot;Add new item&quot; or &quot;Delete item&quot; or &quot;Clear all item&quot;</font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table37" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><span style="text-decoration: none"> <font face="Tahoma" size="2"> <img border="0" src="myfuncs.bmp" width="24" height="24"></font><span class="style3"><font face="Arial">My defined functions<a name="myfunctions"></a></font></span></span></p> <p><font face="Tahoma" size="2"> <img border="0" src="shotmyfuncs.jpg" width="644" height="371"></font></p> <p><font face="Tahoma" size="2">This function will popup the functions list which you created.</font></p> <p><font face="Tahoma" size="2">You can right click the list to popup the menu and select what to do, Add, Edit, Delete function.</font></p> <p><font face="Tahoma" size="2">The function script is PL/SQL script, a block statement of oracle, like follow:</font></p> <p><font face="Tahoma" size="2"><font color="#FF0000"> <i>-- Created on 2014-05-15 by Sailora<br> -- aaaaa/*bbbbb*/ccccc =&gt;/*aaaaa*/bbbbb/*ccccc*/</i></font><br> <font color="#0099CC">declare</font> <br> <font color="#FF0000"><i>&nbsp; -- Local variables here</i></font><br> &nbsp; s varchar2(2000);<br> &nbsp; inum integer;<br> <font color="#0099CC">begin</font><br> &nbsp; s := :INSTR;<br> &nbsp; s := Replace(s, &#39;/*&#39;, &#39;*-/&#39;);<br> &nbsp; s := Replace(s, &#39;*/&#39;, &#39;/*&#39;);<br> &nbsp; s := Replace(s, &#39;*-/&#39;, &#39;*/&#39;);<br> &nbsp; inum := length(s)-length(lTrim(s));<br> &nbsp; s := Lpad(&#39; &#39;,inum,&#39; &#39;)||&#39;/*&#39;||lTrim(s);<br> &nbsp; inum := length(s)-length(rTrim(s));<br> &nbsp; s := rTrim(s)||&#39;*/&#39;||Lpad(&#39; &#39;,inum,&#39; &#39;);<br> &nbsp; s := Replace(s, &#39;/**/&#39;, &#39;&#39;);<br> <br> &nbsp; :OUTSTR:= s;<br> <font color="#0099CC">end</font>;</font></p> <p><font face="Tahoma" size="2">A demo to revert comments: aaaaa<font color="#FF0000"><i>/*bbbbb*/</i></font>ccccc<i><font color="#FF0000"> </font></i>=&gt;<i><font color="#FF0000">/*aaaaa*/</font></i>bbbbb<i><font color="#FF0000">/*ccccc*/</font></i><br> <br> You can edit the function in test window to make sure it is OK and then save it into sailora.</font></p> <p><font face="Tahoma" size="2">The function has two parameters <b>:instr</b> and <b>:outstr</b>, :instr is the string what you selected in the editor, and the :outstr is the result string what will paste into editor.</font></p></td> </tr> <tr> <td> &nbsp;</td> </tr> </table> <table border="1" id="table38" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><font face="Tahoma" size="2"> <img border="0" src="colored.bmp" width="20" height="20"></font><span class="style3"><font face="Arial">Windows list color...<a name="windowslistcolor"></a></font></span></p> <p> <img border="0" src="listcolor.jpg" width="464" height="160"></p> <p><font face="Tahoma" size="2">This function will call the dialog to change the font in windowslist of current window. But the change is temprory and is only affect the window.</font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table39" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><font face="Tahoma" size="2"> <img border="0" src="cellrect.bmp" width="20" height="20"></font><span class="style3"><font face="Arial">Selected cells in grid<a name="cellselected"></a></font></span></p> <p> <img border="0" src="shotcellrect.jpg" width="545" height="301"></p> <p><font face="Tahoma" size="2">The function is a fast way to make the selected value into in list sql and paste into your current editor.</font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table40" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><font face="Tahoma" size="2"> <img border="0" src="HighLight.bmp" width="20" height="20"></font><span class="style3"><font face="Arial">Highlight selected in Editor<a name="highlighteditor"></a></font></span></p> <p> <img border="0" src="myhighlight.jpg" width="522" height="261"></p> <p><font face="Tahoma" size="2">To use this function, you must select one word first, then call this function will highlight all the word in editor. to cancel the highlight, select none and call the function again.</font></p> <p><font face="Tahoma" size="2">You can use this function when you call search. The search color and this highlight will also run, you can use this to compare something with clearly tagged.</font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table41" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><font face="Tahoma" size="2"> <img border="0" src="selectrun.bmp" width="24" height="24"></font><span class="style3"><font face="Arial">Auto select and run<a name="autoselectrun"></a></font></span></p> <p> <img border="0" src="autoexec.jpg" width="351" height="181"></p> <p><font face="Tahoma" size="2">If there is many SQL statement in SQL window, You can call this function to auto select current SQL statement and run it, without set autoselect option of PL/SQL Developer.</font></p> <p><font face="Tahoma" size="2">You can call system execute to run all or call this function to run one. </font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table42" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><font face="Tahoma" size="2"> <img border="0" src="FindSeled.bmp" width="20" height="20"></font><span class="style3"><font face="Arial">Find current selected in Editor<a name="callsearch"></a></font></span></p> <p align="left"> <img border="0" src="shotsysfind.jpg" width="644" height="257"></p> <p><font face="Tahoma" size="2">To call these function, you must select one word in Editor, it will auto fill the word into system search box and call search command.</font></p> <p><font face="Tahoma" size="2">Like you input the word in Search box and click the search button.</font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table43" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><font face="Tahoma" size="2"> <img border="0" src="closeall.bmp" width="24" height="24"></font><span class="style3"><font face="Arial">Close all fast with no ask<a name="closeallnoask"></a></font></span></p> <p><font face="Tahoma" size="2">This function will close PL/SQL Developer program without save confirm. </font> </p> <p><font face="Tahoma" size="2">If you open many many windows and don&#39;t want to save them, Call this function will close the program immediate without any save confirm dialog display. </font></p> <p><font face="Tahoma" size="2">But if you checked the option of sailora, it will display one confirm message dialog. </font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table44" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><font face="Tahoma" size="2"> <img border="0" src="mybrowse.bmp" width="24" height="24"></font><span class="style3"><font face="Arial">Fast browse<a name="fastbrowse"></a></font></span></p> <p><font face="Tahoma" size="2">I don&#39;t know what reason make the system &quot;browse&quot; so slowly to locate one object in the browse tree, but use this function will do same thing much fast.</font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table45" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><font face="Tahoma" size="2"> <img border="0" src="datafastview.bmp" width="20" height="20"></font><span class="style3"><font face="Arial">Data Explore<a name="dataexplore"></a></font></span></p> <p> <img border="0" src="dataexplore.jpg" width="820" height="444"></p> <p><font face="Tahoma" size="2">DataExplore is fast mode to view table or view. Click button &quot;Data Explore&quot; to open data explore window, then select table or view from object browse left, the explore window will auto query the data and display the table propeties. </font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table46" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><font face="Tahoma" size="2"> <img border="0" src="dbinf.bmp" width="24" height="24"></font><span class="style3"><font face="Arial">Generate FusionChart<a name="fusionchart"></a></font></span></p> <p> <img border="0" src="funsionchart.jpg" width="817" height="437"></p> <p><font face="Tahoma" size="2">Select SQL window with result data, this function will generate FusionChart with wizarder director.</font></p> <p align="left">&nbsp;</td> </tr> </table> <table border="1" id="table47" bordercolor="#C0C0C0" cellspacing="0" bgcolor="#EFEFEC" cellpadding="5" style="border-collapse: collapse" width="100%"> <tr> <td> <p align="left"><font face="Tahoma" size="2"> <img border="0" src="fieldvalue.bmp" width="24" height="24"></font><span class="style3"><font face="Arial"><a name="Field-Value_Position_">Field&lt;-&gt;Value Position</a></font></span></p> <p><font face="Tahoma" size="2">When we view SQL scripts with &quot;insert into values&quot; which has much columns and values, It is difficult to see which column corresponding which value. This function can help you to position them eachother. </font></p> <p><font face="Tahoma" size="2">For example, you want to know the value belongs which column, you can position the cursor in the value, then click this function button, then the tool will postion the column name and select it. And it is work to position value from column name.</font></p> <p align="left">&nbsp;</td> </tr> </table> </td> </tr> <tr> <td width="870" colspan="3" height="39" background="http://www.pblsoft.com/pblImages/botmenu_bg.gif"> &nbsp;</td> </tr> <tr> <td width="435" height="220"> &nbsp;</td> <td width="435" colspan="2" height="220"> <p align="center">&nbsp;</p> <p align="center">&nbsp;</td> </tr> <tr> <td width="870" colspan="3" height="11"> </td> </tr> <tr> <td width="870" colspan="3" height="10"> &nbsp;</td> </tr> <tr> <td width="870" colspan="3" height="10"> </td> </tr> </table> <table border="0" width="100%" id="table28" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#C0C0C0" height="34">&nbsp;</td> </tr> <tr> <td> &nbsp;</td> </tr> <tr> <td>&nbsp;</td> </tr> </table> </td> </tr> </table> <p>&nbsp;</td> </tr> </table> <table border="0" width="100%" id="table8" height="43" cellspacing="0" cellpadding="0"> <tr> <td background="http://www.pblsoft.com/pblImages/bot1.gif" width="181"> <table border="0" width="187" id="table10"> <tr> <td align="left">&nbsp;</td> </tr> </table> </td> <td background="http://www.pblsoft.com/pblImages/bot2.gif" width="21"> <table border="0" width="27" id="table11"> <tr> <td>&nbsp;</td> </tr> </table> </td> <td background="http://www.pblsoft.com/pblImages/botmenu_bg.gif"> <table border="0" width="100%" id="table12"> <tr> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </table> </td> </tr> </table> <table border="0" width="100%" id="table9" bgcolor="#0099CC"> <tr> <td align="right"> <address align="right"> <font face="Verdana" size="1" color="#FFFFFF"> <span style="font-style: normal; font-weight: 700">Copyright (C) 2007-2013 pblSoft software, all rights reserved.</span></font></address> </td> <td align="right"> &nbsp;<a target="_blank" href="http://www.9508.com/Counter/supervise/CHA.asp?uid=pblsoftcom"> </a>&nbsp;</td> </tr> </table> <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> try { var pageTracker = _gat._getTracker("UA-8232439-1"); pageTracker._trackPageview(); } catch(err) {}</script> </body> </html>