Tags: select root directory NTC Click need to restart OCI technology sharing styleRequires oracle11g installation package, PL/SQL Developer, and instantclient_11_21.oracle Click Install (need to pay attention to change the administrator password);2. Copy the network folder under the F:\app\Administrator\product\11.2.0\dbhome_1 directory to the root directory of i
Log on to PL/SQL Developer, log on to the local database, and check that the Oracle listening service is not started. Right-click to start the listening program and report an error. How can this problem be solved ?,
I. Error description
When you log on to PL/SQL
Tags: plsql installing Oracle Client InstallationDownload the 3 required packages (in order to connect the 11g database)1:oracle Client (Oracle clients)Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/112010-win64soft-086667-zhs.htmlDownload Win64_11gr2_client.zip Specific installation method can refer to Baidu2:pl/sql Developer 11.0Http
When pl/SQL developer is enabled, the NLS_LANG and Character set (Character set) problems occur. plnls_langStart pl/SQL developer and the NLS_LANG and Character set (Character set) problems occur. The company recently trained
Tags: address Oracle--variable Avoid operation connection accept promptThere is no error in the SQL statement itself, but PL /SQL Developer The resolution of the invalid statement.This prompt appears because of the following code:-- variable num: is an address value that holds the input value
at that address ' Please e
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.Developer configuration appConfigure Tools->preferences->connectionOra
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 and install the PL.SQL.Developer configura
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->connectionOracle HomeD:/instantclient_11_2OCI Libr
Compare | object | original
Pl/sql DEVELOPER 6 Object Comparison function description (original)
The Pl/sql DEVELOPER 6 object comparison function is very powerful and practical, and is a necessary tool for developers, main
suitable for importing and exporting small data volumes. Note that there cannot be large fields (blob, clob) in the table. If so, you will be prompted not to export them. You can export them in the first and third ways.
Third, export. ,. you can only use PL/SQL developer to import and export files in the format of PL
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 fou
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 followi
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
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
When you use the PL/SQL Developer tool to log on to a new user for query, the following error is reported (PL/SQL Developer version: 7.1.51403 ):Dynamic Performance Tables notAccessible,Automatic Statistics disabledFor this sessio
Plsqldev download | plsqldev download cracked version download | plsqldev download
PL/SQL developer is an integrated development environment dedicated for development, testing, debugging, and optimization of Oracle PL/SQL storage.ProgramUnits, such as triggers.
Pl/sql Developer is an integrated development environment designed to develop, test, debug, and optimize Oracle Pl/sql storage program units, such as triggers. The Pl/sql
PL/SQL Developer Usage tips (partial)
Keyword Auto capitalization
What if you want keywords to be automatically capitalized when you enter SQL statements in the SQL command window?
One-step setup can be achieved. Click Tools->preference->editor,
Oracle is the name of the manufacturer and the name of the database product. such as Sybase's Sybase database. and Microsoft's database product is called SQL Server.PL/SQL is the name of an Oracle database that is used by the language. Microsoft's SQL Server is called T, you can think of his own SQL language "nickname"
PL/SQL Developer
Remote connection to Oracle Database
I searched many methods online. This is feasible!
1. Configure the server tnsnames. ora file. If oracle is not installed on the local machine, you can copy one (tnsnames. ora file) in the specified directory, because I have installed oracle, so directly configure this file.
# Tnsnames. ora Network Configur
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.