sql developer training

Before updating the table with update on a test machine, there is no commit, and there is no PL/SQL Developer.The next day, view the table on your own computer and find that the record is not updatedI want to update it with the SQL statement, the execution of more than 10 minutes has not finished.To re-update manually, prompt:At this point, the table has been found to be locked, because the previous use of

For 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 corresponding client management tools and different product version management tools may be subject to different

Here, I learned a very important thing is to use PL/SQL developer to see the execution plan of a SELECT statement, the execution plan can see the cost of this SELECT statement,I/O operation cost and other values, You can clearly see the execution efficiency of each part of the statement. When this select statement is selected, press F5 to do so. Take the following SELECT statement as an example:Take the da

Prior to the project because of the need to use the Oracle database, due to limited time to start learning from the foundation, and Oracle operation of the command interface is too unfriendly, so found the PL/SQL developer This very useful software to use the database indirectly.Here's a quick introduction to using this software to connect to an Oracle database.The first step is to install Oracle database a

PL/SQL _ Developer import official documents, pldeveloper Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright. Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/44974619 Add "official documentation" for PL/

Download PL/SQL Developer in http://download.csdn.net/download/wuqinfei_cs/7740373.1. Unzip, create a new network folder under the Instantclient_11_2 directory, and then create a new admin folder under it . Copy the Tnsnames.ora in the Oracle\product\11.2.0\dbhome_1\network\admin directory to the previously created Admin folder.2. Right-click Computer Properties, advanced system settings, environment variab

IamlaosongAlas, the real soil, used toad, has been using dbms_output.put_line debugging stored procedures, only feel inconvenient, with PL/SQL developer, or use this method, online search, just know can be single-step debugging. Learn to use PL/SQL developer debugging features for writing complex stored procedures, pac

Tags: style blog http ar using SP java on 20141. Premise: The use of Sqldeveloper is based on the premise that Oracle is installed on your machine.2. Just open SQL DeveloperLocate the directory of the JDK you installed, the path I installed is: C:\Java\jdk1.6.0\bin\java.exe or C:\Java\jre6\bin\java.exe. Note that the JDK needs to be available under version 1.6, and the above versions are also available, but errors may occur.3. The following interface

feature, because remembering passwords can give data security problems.But if it is the development of the library, the password can even be the same as the user name, each input password is really 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 developer The defau

Solution for Oracle SQL Developer Connection error (ORA-12505) (two), developerora-12505 With oracle database new connection encountered ora-12505, after the problem is resolved and ora-12519 error, depressing for half a day, after some tossing problem solution, the following small series will share my two solutions for your reference only. Solution 1: Today at work in the new connection encountered a ORA-1