oracle sql developer debug

Label: Log in to the database you need to back up using PL/SQL developer; Select Tools, export user objects; Select the object in the object list that needs to be backed up, then select an output file of SQL type, click "Export", this is just the export data structure; Select tools, export tables; Select the table in the list where you want to e

\tnsnames.ora or write one of their own content as follows:# Generated by Oracle configuration tools.ORCL =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 10.5.10.252) (PORT = 1521)))(Connect_data =(service_name = ORCL)))The above three must pay attention to, in addition some Windows version of the tnsnames.ora.txt behind the txt to be removed;4, double hit open plsql point cancel650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/

Tags: Oracle Developer650) this.width=650; "Width=" 501 "height=" 228 "title=" Od.png "style=" width:648px;height:321px; "alt=" wKiom1mC49_ Ijp8gaacllfoyuec759.png-wh_50 "src=" Https://s1.51cto.com/wyfs02/M02/9D/A1/wKiom1mC49_ijP8gAACLLFoyUEc759.png-wh _500x0-wm_3-wmp_4-s_211760162.png "/>If a ORA-12514 error occurs, you need to locate the file F:\app\khe\product\11.2.0\dbhome_3\NETWORK\ADMIN\listener.ora==============================Open the file and

* FROM FOR UPDATECor = CREATE OR REPLACEP = PROCEDUREFn = FUNCTIONT = TIGGERV = VIEWSso = SET serveroutput ON; Set the shortcut key (setting method: menu Tools> Preferences> User Interface> key configuration)New SQL window: ctrl + shift + sNew command window: ctrl + shift + cNew Test window: ctrl + shift + tPL/SQL Developer beautify: ctrl + shift + fRedo: ctrl +

Label:Today, to connect to the Oracle database, the Plsql Developer is downloaded, but the installation prompts the Oracle client to install incorrectly.Then Baidu data found that through the Plsql developer connection to the Oracle database, you need to install

tool to configure a remote database Method 3: Enter the username and password in the logon window of plsql developer. Enter the database IP/SID. Plsql Route 8 how to connect to a remote database 1. Oracle downloads the Package software named Instant Client. You need to install and unzip the directory. In this example, the local machine decompress E: \ OracleClient. In fact, the

[PLSQL Developer] PLSQL Developer SQL Editor garbled, plsqldeveloper[Problem] We often write various statements in the SQL window of PLSQL Developer. To save these statements, you can save them as a text file or copy them and paste them into a Word file, the advantage of sto

SQL Window of PL/SQL Developer, press F8. By default, PL/SQL Developer executes all SQL statements in the Window and must be set to the SQL statement where the mouse is located, execut

the SQL Window of PL/SQL Developer, press F8. By default, PL/SQL Developer executes all SQL statements in the Window and must be set to the SQL statement where the mouse is located, ex

passwords can be a problem for data security.But if it is the development of the library, the password can even be the same as the user name, each time to enter a password is meaningless, you can consider let Plsql developer remember the password.Location: Tools menu--preferences--oracle--logon history--store with password3, double-click to display table dataPlsql deve