oracle sql developer debug

Tags: style io ar color sp on Art BS codeHow to efficiently debug an Oracle stored procedure, especially a parent-child mesh call stored procedure1. Set breakpoints at Oracle stored procedure where breakpoints need to be setHow to set breakpoints: Click a line at the beginning of a row of Oracle stored procedures to di

Tags: ant article directory name add protoc Imp directory database comOracle 11g Lite Client ConfigurationOracle is typically deployed on the server, and the client needs to connect to Oracle on the server using connection tools such as PL/SQL Developer.At this point, it is often necessary to install hundreds of megabytes of Oracle on the client and then configur

Modify the database configuration file: Tnsnames.ora "My database location: D:\app\Icey-evil\product\11.2.0\dbhome_1\NETWORK\ADMIN"Add the following to the server address:10.88. 250.28 = = =10.88. 250.281521) ))) (= ORCL ) )) Description: HOST = 10.88.250.28 is the Oracle server that needs to be connected Ip,service_name = ORCL is a connected db instance, Port = 1521 is the Oracle Se

Label:Original: http://blog.csdn.net/kimsoft/article/details/8751267 Operating system: Windows 7 64-bit flagship requirements, install PL/SQL developer for development First, download the official Oracle Lite Green Edition Http://www.oracle.com/technetwork/topics/winsoft-085727.html Special note To download the 32-bit, because PL/

Tags: 2.0 SQL Bracket Cat good effect article tail topDue to the continuous updating of hardware technology, Win7 system gradually become mainstream, and computer memory gradually increased, in order to make full use of memory resources (because 32 of the system can only use up to 3G of memory), improve system performance, many people began to use the Win7 (64Bit) system. A 64-bit Oracle database is install

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;

Tags: style blog C java tar http1. EnvironmentWin7 x64,oracle 11g r2,jdk6 x642. QuestionsThe first time you start Oracle SQL Developer will let us fill in the path of Java.exe, I found in the JDK installation directory of the bin Java.exe, but fill in the following error:3. CausesThe

Oracle SQL Developer connection MySQLOracle SQL Developer is a very powerful open-source SQL development tool , but recently I began to study it , just installed oraclesql Developer is

Oracle SQL Developer is a very powerful open source SQL development tool, but recently I began to study it, just installed Oracle SQL Developer is not supported to connect MySQL, need t

1) Install Oracle 11g 64-bit2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0)Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has downloaded), Unzip it to product under the Oracle installation directory (this machine is name

Oracle SQL Developer is a very powerful open source SQL development tool, the installed Oracle SQL Developer does not support MySQL connection, need to download the JDBC driver formysql

\instantclient_12_2. finally download PL/SQL and install, open to Tools preferences Configuration connection file, Oracle home:d:\dev\oracle\instantclient_12_2,oci library:d:\dev\oracle \instantclient_12_2\oci.dll. The key is to configure the environment variables, tns_admin:d:\dev\

Tags: PL/SQL Developer remote database without native Oracle clientI. Download PL/SQL DeveloperPL/SQL Developer download page, you can choose to download 32-bit or 64-bit, if you need Chinese language interface can also downloadSe

Installing the 32-bit Oracle client Instantclient-basic-nt-12.1.0.1.0.zip: http://www.oracle.com/technetwork/topics/winsoft-085727.html Download unzip to get "instantclient_12_1" file, copy "Instantclient_12_1" to "C:\app\oracle\product\12.1.0" (can also be any path). Installing Plsql Developer: http://pan.baidu.com/s/1gdelc5d Install well open you will find that

Original Oracle SQL Developer useComparison:Plsqldev: Third-party, fast startup software, slow execution of SQL queriesSqldeveloper:oracle company, slow startup software, fast execution of SQL queriesDisadvantages:Every once in a while (about 10 minutes), will be disconnecte

Tags: background database management tool Oracle ClientFor the traditional large-scale software products using relational database, the continuous development and maintenance of the background database can produce a large number of script files, how to make versioning more convenient for these script files, and how to quickly manage the permissions between the teams. The level of integration between the different database products and the correspondin

First, download the Oracle client: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlCurrent Latest VersionVersion 12.1.0.2.0Select the first instant Client for Microsoft Windows (32-bit) to download it,Please do not download 64bit, I have tried, can not achieve the connection.Unzip the downloaded Instantclient-basic-nt-12.1.0.2.0.zip compressed package and put it in the D:\instantclient_12_1 directory.In the environment variables, in the sy

Installing JAVA-JDKThis part of the tutorial is a lot, you can follow the online tutorial to installInstalling SqldeveloperDownload Sqldeveloper Linux RPM http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.htmlSince Oracle does not provide the. deb installation package, you need to download

After the Oracle database is installed, start the database as SQL Developer: The result is a small box prompting you to enter the full PathName for Java.exeFor this workaround:Locate the Java.exe file under the Oracle path that you installed, and locate the following two paths of Java.exe:First one: D:\app\Administrato