Backup | templates | original
Pl/sql DEVELOPER 6 template using series documents (iii)
Pl/sql DEVELOPER 6 template Backup and migration
It's too easy, but it doesn't seem like anything, nail, open your pl/sql DEVELOPER
;
Decompression Instantclient-basic-win32-11.2.0.1.0.zip to D:\Oracle\instantclient_11_2;
Configure environment variables;
Variable name
Value
Note
Nls_lang
Simplified Chinese_china. Zhs16gbk
set up the necessary Oracle Global Language environment variables, Nls_lang the corresponding character set in Chinese is simplified Chinese_china. ZHS16GBK
Configuring PL/SQ
PL/SQL Developer functions of various windows, pldeveloper
Understanding the functions of each window is the primary condition for the correct use of PL/SQL Developer. The following briefly describes the functions of PL/SQL Developer
Pl/sql developer is the most frequent Oracle client GUI program I use to manage Oracle databases.
Currently the latest version is: 6.0.4
January 5, 2005-version 6.0.4 releasedenhancements Package bodies, type bodies, and materialized views would disappear F ROM User defined folders Opening a user defined folder when disconnected would leads to ' not logged on ' Messages me Nu did not show directories with
Tags: share development client Analytics admin hint Dev Oracle strConfiguring the Environment Oracle Service SideOracle_winx64_12c_database.iso Oracle ClientInstantclient-basiclite-nt-12.1.0.1.0.zip Integrated development EnvironmentPL/SQL Developer 10.0.5.1710 Configuration steps Make sure that Oracle has completed the configuration and can use SQL Plus to log o
PL/SQL Developer log on to Oracle 12c
After Oracle 12c is installed, PL/SQL Developer cannot connect to Oracle 12c. Search online and follow the instructions in fcflying, so take a note:
1) install Oracle 12c 64-bit
: Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html? SsSourceSiteId
Problem Description:Oracle uses PL/SQL developer to export data to CSV format, VARCHAR2 Type field if the value (for example, 3307830000004059) is too long, the CSV file is represented in scientific notation, even if the column is selected, click Data--. > columns, fixed width, column data format select text, and the last one will still be set to 0.Workaround:Oracle uses PL/
Unable to start. After "unable to create an instance..." is downloaded, run the following message:
---------------------------Unable to create an instance of the Java Virtual MachineLocated at path:---------------------------
The reason is that the JVM parameter settings are incorrect. There are two solutions:
Solution 1:
Modify the file and set the "addvmoption-xmx" parameter as follows:Addvmoption-xmx256mThen it starts up normally.
Solution 2:The setting is different, and the principle is the
I uninstalled PL/SQL Developer and compared it with Toad for Oracle.
Previously, PL/SQL Developer was used to manage Oracle, which was inconvenient to use. It is very difficult to open, and there is always an extra box in the upper left corner of the interface. It cannot be set to hide it by default.
The only thing t
How to install PL/SQL developer on Linux工欲善其事 its prerequisite, PL/SQL and Toad are important tools for Oracle practitioners, but none of these tools have a Linux distribution, and if you want to use these tools on Linux, you needWine or crossover This Windows application Simulator, crossover is wine's enhanced version, nonsense said, the following starts to demo
PL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. Now that more and more business logic and application logic has shifted to Oracle Server, PL/SQL programming has become an important part of the entire development process. PL/SQL
Tags: Files menu--option Add LAN add modify properties DevelopToday when you use Oracle SQL Developer to do tuning recommendations when you find the suggestions shown as garbled, I SQL developer for the Chinese version, modified to the English version after the problem solved.View the Properties tab in the Help menu,Us
Label:Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html SQL DeveloperDownloadsLicense AgreementThank for accepting the OTN License Agreement; Download this software. To learn more about our development tools, join us every Wednesday for a free Webinar on Database development tools.
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 enter a number ';There is no error in the prog
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
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"
Background:On the local machine (Win7 64-bit flagship Edition) Install the Oracle 11g Client32-bit ORACLE clientIf the 64-bit ORACLE client is installed, you cannot enter the sqlplus/nolog command in the CMD command, that is, the command cannot be identified.) After setting the corresponding local service, the following error is prompted with PL/SQL Developer:"Cocould not load "...... \ Bin \ oci. dll"" Thi
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.