In the previous Java Development, PLSQL developer was used all the time. Search objects (tables, triggers, db_links, synonyms, sequences) were all used in the Object Browser:
Toad was not used until recently when C was used for background service-level development (UNIX). Similar to the above, Toad has a schema Brower. First of all, I have to say, the function is indeed more powerful:
Users can be cle
Solve the problem that PLSQL Developer cannot be used to connect to Oracle DB in Windows x64bit environment, x64bitplsql
This article is an original article. For more information, see the source:
Http://blog.csdn.net/msdnchina/article/details/46416455
Solve the problem that PLSQL Developer cannot be used to connec
ORA-12541: TNS: No listener
Since PLSQL developer was unable to log on to Oracle, it was long before people wanted to study this database, but they had no time to study it.
I used to use the client PLSQL developer, there is no problem, but today when starting PLSQL
Export data to an Excel file: select the data table -- query data -- select the data to be exported -- Right-click Copy to excel to import data to the database: 1. Prepare the data to be imported in Excel. Specific Operation: In Excel, set the first column as an empty column. The columns after the second column should correspond to the fields of the data table to be imported. 2. log on to PLSQL developer, f
Add environment variables before installing Oracle 10gVariable name: tns_adminVariable Value: D:\oracleclient\instantclient_11_2This will generate three files under this file after Oracle installation: Listener.ora, Sqlnet.ora, Tnsnames.oraMove these three files to D:\oracleclient\instantclient_11_2\NETWORK\ADMIN, the folder is built by itself.Then extract the Instantclient package downloaded from the Internet, the default is the Instantclient_11_2 file, copy the files in this folder to D:\oracl
Remote connection to Oracle is troublesome. It usually takes the oracle client to be installed. You can use instantclient to easily connect to a remote Oracle database.
1. Create a Directory D: \ Oracle_Cleint to store related files. Create a Directory D: \ Oracle_Cleint \ NETWORK \ ADMIN to store tnsnames files.2. Download the corresponding version and the system's instantclient compressed package, decompress the package to obtain the instantclient
ora file, which is easy to write by yourself, can be found in the Oracle Installation Directory (like our data center is D:/oral0instanceclient ), copy the file to the decompressed directory (H:/program files/sqlplus) and modify the file according to the preceding configuration. If this file is copied, you only need to change the IP address of the host to the server address!
Enter sqlplus username/password @ orcl in cmd, where orcl is the database instance when we install oracle! After comple
Use PLSQL Developer to remotely log on to oracle, and web management to log on to PLSQL Developer only after installation, you can access the local oracle, but there are some problems in accessing the remote server oracle or the oracle of the Virtual Machine. First, I will describe the configuration steps as follows: 1
"Problem phenomenon"Received Maintenance group complaint ticket, the user uplink SMS to 10086 SMS processing business failure, the results of query data display is empty.Under normal circumstances, the system will be empty text messages filtered out, the user's uplink SMS has entered the business engine storage.Maintenance with Plsql Developer View SMS field display blank, click Details also no content can
, number of rows, trigger.Note: If the table contains Clob or NCLOB fields, it can only be imported in the DMP format, and if it is a small number of tables, it is possible to insert it in SQL.When restoring, be aware that you need to restore the DMP file first.3 table data Restore.A. If the DMP file, then in the PL/SQL Developer menu tools (Tools) + Import table out a dialog box interfaceYou can select the account you are logged in to at the "to User
Label:1, first download PL/SQL, installation, cracking;2, download the Oracle INSTANCT client base version of the file, if the system is 32-bit download 32-bit, 64-bit download 64-bit;3, decompression instanct client to any disk, such as (D:\instanctClent), in the decompression file under the path of a new file network
Scene: Recently in the statistics of overtime records, mainly statistics Excel table time, because I am not very familiar with Excel table operation, so I think of the table data import into the database, through the scripting language to statistics, it is very convenient! But for the time being, I have not finished the final statistics, just import the data in Excel into the database, so not to be continued!The recent process of importing Excel data into Oracle is much more. Previously, it was
Set the SQL writing format of PLSQL developer
The PLSQL version I use is 7.1.4.
Setting method:
PL/SQL developer-> Tools-> preferences-> PLSQL beautifier-> rules File
Click Edit. In the window that appears, modify the items in sequence, modify the items, and click Sa
default English version is PLSQL developer. the font of the SQL code is Courier New. After the Chinese Language Pack is installed, it becomes ,. If you read the code for a long time, of course, it is not as good as the English font (SQL is English ). You can set it as follows:
From: http://www.cnblogs.com/william-lee/archive/2010/12/08/1900176.html
1. You have written Multiple SQL statements in the
Tags: path run password picture registration \ nthe software share selObjectivePlsql developer software and required configuration Link: https://pan.baidu.com/s/1xHdAl1RAgtQb-oDHPah19w Password: x41k1 installationUnzip the two compressed packages Open first Folder Double-click Run Plsqldev906.exe There is no space in the installation path with Chinese, the other is the next step. Plsql
imported in the DMP format, and if it is a small number of tables, it is possible to insert it in SQL.When restoring, be aware that you need to restore the DMP file first.3 table data Restore.A. If the DMP file, then in the PL/SQL Developer menu tools (Tools) + Import table out a dialog box interfaceYou can select the account you are logged in to at the "to User" section.b if it's a SQL format file, create a new command window in
Requirements Description:When using Plsql developer, there is too much history when you log in, and you want to get rid of these login histories,Under this record.Operation Process :1. Log in to Plsql Developer (or cancel when you log in Plsql Main Page also appears)2. Tools
Tags: Record line details font style SQ use picture accessPlsql developer has too many historical records in the store, so it is very troublesome to find, so it is necessary to delete some unnecessary records:1. Locate the Plsql Developer installation directory:2. Search User.prefs file, locate Logonhistory in file , It would be nice to delete the 277645384452452
Plsql Developer Error message display garbled problemConnection environment:Win 7Database version number:Oracle 11gSimulate an error, check the error prompt to show "????" "Garbled problems, such as the following:Check:1, V$nls_parametersIn order to display Chinese, nls_language should be Simplified Chinese2. Enter the registration form to see the languageIn the "Start " menu of the computer, find " execut
Tags: style blog http color ar file SP art
Download instantclient-basic-nt-11.2.0.2.0 -bit client, post-pressurized storage, such as F:\instantclient_11_2
Copy the Oracle 11.2G Msvcr80.dll and Tnsnames.ora to the extracted instantclient_32-bit client root directory, where they are:D:\home\product\11.2.0\dbhome_1\BIN and D:\home\product\11.2.0\dbhome_1\NETWORK\ADMIN
Set up the Oracle_home and OCI Library in
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.