pl sql developer tutorial

. Setup method: Right- --special copy 6. Custom shortcut keys Plsql developer has a lot of keys reserved for users to customize, which is very hight thing. Unlike the overbearing Word, basically all the keys have been pre-defined features, the change is very headache. Usually, after opening plsqldeveloper, the most frequently done thing is to open Sqlwindow and CommandWindow, the two operations have defined shortcut keys,alt+s and ALT + C, So take t

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 C

Reason: Because the database number format and PL/SQL Developer encoding format is not unified.Second, view and modify the Oracle database character set:Select Userenv (' language ') from dual;Query Result:American_america. Zhs16gbk--Modifying the Oracle Database Character set: (In SQL Plus)

Pl/sql developer-newsseptember 2004-version 6.0.2 releasedenhancements Partitioned tables were not detected Corre ctly on Oracle8i Partitions tab page is visible when viewing a non-partitioned table Code Assistant did not describe mate Rialized views Code Assistant did not describe record types declared in another package Code Assistant could remove spaces Typed

PL/SQL Developer experience with oaracle11g64-bit systems in Windows7 64-bit SystemsI. Problem phenomena and solving methodsPhenomenon:1.pl/sql cannot log on to a 64-bit database2. Enter Chinese in PL/

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 corresponding client management tools and different produ

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 Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5. Download

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;View the value of Nls_languageNls_languageNls_territory5. Download and install the PL.SQL.

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 system variables, add: Oracle_ho

Nls_languageNls_languageNls_territory6. Download and install the PL.SQL.Developer configuration appConfigure Tools->preferences->connectionOracle HomeD:/instantclient_11_2OCI LibraryD:/instantclient_11_2/oci.dllThe PL/SQL developer in Chinese isTools--Preferences--ConnectOracle Home DirectoryD:/instantclient_11_2OCI LibraryD:/instantclient_11_2/oci.dll 7, restar

Tags: plsql developer ora-12154 TNS cannot resolve the specified connection identifierBackground:On this machine (Win7 64-bit flagship edition ), install the Oracle 11g Client ( 32-bit Oracle client installed, if the 64-bit Oracle client is installed, in the cmd command, enter Sqlplus/nolog command is unrecognized, that is, unrecognized), and after setting the appropriate local service, use PL/

Original Pl/sql DEVELOPER 6 Session Management Pl/sql DEVELOPER 6 has excellent session management capabilities, and can perform all common session management functions, including: Query Session list information End S

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 configure the completion of

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 named: instantclient_11_2): D:\Oracle\app\YM\product\instantclient_11_2.Copy a directory under the root directory of the database installation D:\Oracle\app\YM\product\11.2.0\dbhome_1\

1. Create a new table, business_copy, and copy the data from the Bisiness tableCREATE TABLE business_copyAsSELECT * from business;NOTE: This SQL statement simply creates the table and replicates the table's data, but does not copy the constraints of the table.2. Delete the table in PL/SQL developerFor example, delete a table business, perform a operation,1) DROP

Resources:Plsql Expiration resolutionPlsql Permanent registration code for each versionMethod One:1. First, landed PL/SQL Developer,pl/sql Developer to expire.2. Enter the command "regedit" to open the registry,3. Then, in the reg

\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\oracle\instantclient_12_2, and then add in path: D:\Dev\oracle\instantclient_12_2. After the installation of Oracle in the D:\D

Resolved in three steps:1. Check the server code:Execute SQL Syntax: SELECT * FROM V$nls_parameters;2. Set the local client code:Enter My computer, properties, advanced, environment variables, add 2 items: LANG=ZH_CN. GBK and nls_lang= "simplified Chinese_china. ZHS16GBK "Note: Nls_lang is determined by the value of step 1 {nls_language}_{nls_characterset} (different Oracle server settings, different values)3. PL