pl sql developer tutorial

structure to do a comparison, as follows: We can see that the table structure is no different, as follows: Summary: When using PL/SQL Developer to compare the table structures of different libraries and different users under the same table name, the operation is as follows: tools>compare User objects> selects a SQL

)) (Connect_data = (SERVER = dedicated) (service_name = orawin) ))Of course, copy can also be obtained from the corresponding directory of the Oracle server already installed.4. After configuring these, open PL/SQL, click Cancel to not login, directly into the interface 5. Select Tools-preferences on the menu Configure the path to the Oracle Instant Client in the lower right corner of the Options page .

click Finish button to end the configuration. Go back to the Oracle Network Manager (Oracle Net Manager) main window and save the configuration by default to locate the local Service name profile under the Oracle installation directory (Windows d:/oracle/ora92/network/ Admin/tnsnames.ora). Configure the completed local service name as shown: Service naming under the tree directory can be changed to a service name consisting of any legal character by renaming the menu in the Edit menu, note t

Tags: com mmu develop plsql lov use TNS POS ResultsDescription of the phenomenon: It is normal to compile procedure with Plsql developer connection. Once the test starts to enter debug mode, it is stuck. The initial guess is that there is no permission, but the DBA role, if not the right will directly report the error without permission. The later guess is the version of Oracle or PL

Label:s = SELECT t.* from t w = WHERE b = between and l = '% ' o = ORDER by INSW = in (SELECT a From a where a) SW = Select t.* from t WHERE t sc* = Select COUNT (*) from t st = Select t.* , T.rowid from t f = for update u = Update t SET t. WHERE t 　　1. Save the above contents as Shortcuts.txt, copy to the X:\Program files\plsql developer\plugins directory, Win7 to pay attention to the permissions2. Menu select Tools-Perferences, Editor-autorep

If you use Oracle, you may use PL/SQL Developer.When PL/SQL Developer is used, a confirmation dialog box is displayed when you right-click the Table list or other object lists and select the Drop operation.There will be a check box for Don't show this message again at the bo

PL/SQL Developer double-click table name query, pldeveloper Double-click a table. The default value is Expand/Collapse. To Expand/Collapse a table, you need to view the table data quickly. If you write select * from tab, it will be troublesome, Double-click table to perform quick query. Method:Tools-> Preferences-> User Interface-> Browser-> Object type (Table

Http://hi.baidu.com/jackyljlj/blog/item/860b020f912df6296159f37b.html PL/SQL developer: Powerful, convenient, and fast. Once used, it is absolutely inseparable! Its main strengths are as follows: 1. Edit table data (browsing table data is a natural issue) 2. Do you feel a little upset when writing long statements in SQL