Tags: character plsql developer Character Set Nls_langOpen PL/SQL developer Nls_lang and character set (Character set) issues the company recently trained PL/SQL, I opened it after installation and encountered a problem.PS: My ope
Normally, connecting Oracle with PL/SQL developer requires the installation of Oracle client software, which means that your hard drive will take up about 1g-2g of space, and you will have some more boot-enabled services for the Windows operating system. Of course, for most people, you don't apply the database you create on your own machine, but just want to conn
Pl SQL Developer client connects to the server, pldeveloper
After installing Oracle and PLSQL, open the listener on the server.
Right-click a computer, choose management> services and applications> services> open services starting with Oracle, especially listening. This is the most important and specific.
(1) configure the listening location
Start-all programs-
I. PL/SQL Developer data ImportTools->import TablesThe corresponding path is the path of the Sqlplus.exe, in general, in the \app\admin\product\11.2.0\client_1\bin\sqlplus.exe.The imported path is the path of the SQL file that you need to import, click Import to implement the import operation.Ii.
Tags: plsql developer ora-00936Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.The blog:http://blog.csdn.net/huangyanlong/article/details/49897839 of Blue Some time ago, when attempting to extract data using PL/SQL develope
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 nls_lang=simplified Chinese_china. Zhs16gbk3. PL/SQL Developer set up and reconnect:In the
database. 3. Connect to the database using PL/SQL developerThe database is populated with the service_name of the remote databases ,Note: According to the actual user name, password and database:User name: Gateway Password: Gateway database: ORCL 4, after the connection in the PL/SQL
the table, and if you do, you will be prompted not to export, which is the first and third way to export. The third type is exported to. Pde format, the. PDE is PL/SQL developer own file format, can only be imported and exported by PL/SQL
Label:Do not install Oracle client program locally, connect to remote database directly using PL/SQL developerGiven the limited resources of the machine itself, a client consumes a lot of resources and attempts to connect remotely using a method that does not install the client.Software required: instantclient-basic-win32-10.2.0.5.zip, PL/
Original: 17th-Configuring SQL Server (2)-memory configuration in 32-bit and 64-bit systemsObjective:This article covers memory configurations in 32-bit and 64-bit systems, where DBAs o
Pl/SQL developer open the table garbled. In pl/SQL developer, view the table structure. The table structure comments are all ???, It is normal to view the table structure directly in the cmd window, which indicates that it is a pr
PL/SQL Developer Quick action: show invisible characters Display historical SQL statements copy entire statements of the Windows to a new SQL windowDisplay invisible characters: You can display the blank space, carriage return;Show History
if not yet.4, sometimes may appear the client to the Chinese support bad question, may refer to the following third article environment variable setting:On the desktop, right-click My Computer, select Properties, select Environment variables in the Advanced page, and in the system variables, increase:1) variable name: oracle_homeVariable Value: E:\instantclient_11_22) variable name: tns_adminVariable Value: E:\instantclient_11_23) variable name: Nls_langVariable value: Simplified Chinese_china.
After Oracle 10 Gb is installed, a table is created to write Chinese data. It is found that the PL/SQL developer tool cannot display Chinese normally.
To display Chinese characters properly, the server must be consistent with the client encoding. Therefore, check.
1. Check the server code:
Execute SQL Syntax:
Selec
Tags: Oracle Toad database ManagementUsing PL/SQL developer to manage Oracle in the past has found it inconvenient to use. Open very card, and the upper left corner of the interface is always more out of that box, how can not be set by default hidden away.The only thing that is worth it is that there is a beautification tool, but later found that Toad actually al
Templates | original
Pl/sql DEVELOPER 6 template using a series of documents (i)
Getting Started with Pl/sql DEVELOPER 6 templates
Working with templates
A: Right-click the pop-up shortcut menu at the edit place, sele
When you use PL/SQL developer 7 to connect to a newly installed Oracle database server, ORA-01460 errors always occur frequently: type conversion errors.
Only PL/SQL developer has this problem.
The suspect is a character set p
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.