oracle sql developer 11g

The source of this article, in order to facilitate direct copy over. If there is infringement, please inform, thank youhttp://blog.csdn.net/chiclewu/article/details/14646687An Oracle 11g 64-bit version was installed in the virtual machine today, and when connected with PL/SQL developer, it was found that there was no d

Oracle's official SQL Developer comes with Oracle migration Workbench. What is Oracle SQL Developer? On the official page, this is how it is presented: Oracle

directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/SQL Developer in non-logon mode, designate the

directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/SQL Developer in non-logon mode, designate the

Tnsnames.ora file can also be copied from the Network\admin directory of the Oracle database home directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/

home directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/SQL Developer in non-logon mode, designate the

directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/SQL Developer in non-logon mode, designate the

to the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin4. Set the language of Oracle, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * fr

name after the hostname)2. Oracle Home and OCI libaray configured with PL/SQL developerEnter the PL/SQL Developer in non-logon mode, designate the Oracle home path as the Oracle Client directory (C:\instantclient_11_2), and the O

Tags: des style blog tar width get1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL developer, and note that when you install the PL/SQL developer software, do not install in the pro

Tags: blog http ar sp for file Art logOperating system Environment: WINDOWS8.1Tools: Oracle 11g-r2 SQL DeveloperNetwork resources: http://sourceforge.net/project/showfiles.php?group_id=33291package_id=25350release_id=534076Login above address select Jtds-1.2.2-dist.zip to download, drawings:When the download is complete, open the unpacking package and find the Jt

Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5. Download and

machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * from Nls_instance_parameters;View the value of N

variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5. Download and install the PL.SQL.Developer configuration appConfigure Tools->preferences->conne

settingsTools-Preferences:Oracle Home directory Name: D:\app\admin\product\11.2.0\dbhome_1OCI Library: D:\app\admin\product\11.2.0\Instantclient_11_2\oci.dll2, Error 2:ORA-12541:TNS: no listening programOpen Command Console, enter command: LSNRCTL status to view listener status;No boot listener, enter command: Lsnrctl start, if not successfully started, check that the listener's profile Listener.ora is configured correctly:# Listener.ora Network Configuration File:d:\app\admin\product\11.2.0\db

click on the number of buttons: Start debugger or press F9;3), Last click: RUN or Ctrl+r.debugging shortcut keysToggle Breakpoint: Ctrl+bStart: F9Run: Ctrl+rSingle Step Into: Ctrl + NStep Skip: Ctrl+oSingle Step exit: Ctrl+tRun to Exception: Ctrl+y8. Template shortcut keys9. My Objects is automatically selected by default after loginBy default, after Plsql developer is logged in, Brower will select all objects, and if you are logged on as a DBA, you

My environment is like this: Win7 64-bit + Oracle 11g + PL/SQL 9.04 Since PL/SQL does not support 64-bit data at the moment, only Oracle client 32-bit data can be used, so you need to download it from the official website: Remember: you must download a 32-bit package) Http:/

Tnsnames.ora file can also be copied from the Network\admin directory of the Oracle database home directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname) 3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/

of the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * from N

example, my machine is: d:/instantclient_11_2/network/admin4. Set the Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;