10 types of Java developers often encounter errors when writing SQL statements, and 10 types of java developer SQL
The degree to which Java developers can coordinate object-oriented programming thinking and command line programming thinking depends on their ability:
Tips (anyone can write code in the command line format)Dogma (some people use the "mode-mode" meth
different Object types.
4. All SQL statement characters are in uppercase I think this is a good habit. The core of the information system is the database. When the system goes wrong, the first query is the SQL statement, how to quickly find the SQL statement in the vast log is quite painful.SQL statements in uppercase cannot completely solve this problem, but it
Http://hi.baidu.com/yunfanleo/blog/item/fa65fcfd91916346d7887d25.html
PL/SQL developer
PL/SQL developer is an integrated development environment dedicated to the development of Oracle database storage program units. Nowadays, more and more business logic and application logic are turning to Oracl
out, I use the database named Tcm,so ... Then install the PL/SQL Developer, the process is fool-style. After you enter PL/SQL (you will be asked to log in to the database when you enter, but now PL/SQL cannot find your Oracle client now, so login is not successful, but you can enter the software), select Tools->prefe
......
Later I found that many machines in the lab were installed with Oracle clients, but ms was installed with genuine installation cds when the database was built in the lab, I have a physiological fear for such a bloated client, so I still use the original method for my own development.
One day, I saw 10 Gb green simple client on the official Oracle website ......
Http://www.oracle.com/technology/tech/oci/instantclient/index.html
To download software from the official Oracle website, you ne
different Object types.
4. All SQL statement characters are in uppercase I think this is a good habit. The core of the information system is the database. When the system goes wrong, the first query is the SQL statement, how to quickly find the SQL statement in the vast log is quite painful.SQL statements in uppercase cannot completely solve this problem, but it
passwords can be a problem for data security.But if it is the development of the library, the password can even be the same as the user name, each time to enter a password is meaningless, you can consider let Plsql developer remember the password.Location: Tools menu--preferences--oracle--logon history--store with password3, double-click to display table dataPlsql developer The default response when you do
Specific: Appid: wx... nickname: XXX time: 2015-01-20:07:19 content: the server has timed out when connecting to the public account developer server. Timeout time: 3 seconds: 5 minutes, 39 errors. Example: [ip202.108.5.20.] [MsgText] sae Sina ECs excuse me... details:
Appid: wx...
Nickname: XXX
Time: 22:07:19
Content: a timeout occurs when the
Specific:
Appid:wx ...
Nickname: XXX
Time: 2015-01-20-22:07:19
Content: A timeout occurs when the server connects to the public developer server with a time-out of 3 seconds
Number of times: 5 minutes 39 times
Error example: [Ip=202.108.5.133][msg=text]
SAE Sina Cloud Server
May I ask what are the possible causes? T
The source of this article, in order to facilitate direct copy over. If there is infringement, please inform, thank youhttp://blog.csdn.net/chiclewu/article/details/14646687An Oracle 11g 64-bit version was installed in the virtual machine today, and when connected with PL/SQL developer, it was found that there was no database connection to TNS.It is considered that the PL/
database. Wait a moment and prompt that the export is complete. Then run the following command to import data:
>oracle_ctl[oracleusername][password]
You do not need to specify the database name or the like here, because it has already been specified in the script.
Wait for a moment after the import is complete.
At this point, the knowledge about migrating SQL to Oracle by SQL
The following tips only apply to PL/SQL developer 6 and later versions. Version 5 only has some features.1. Right-click the menuRight-click an object name in each text editing window in PL/SQL developer (PLD), such as SQL window, command window, And porgram window, A menu co
MySQL, MariaDB, SQL Server, SQLite, Oracle, and PostgreSQL databases in a single program. The official website is: Http://www.navicat.com.cn/products/navicat-premium. Since this machine is a 64-bit operating system, download the latest 11.1.10 64-bit version. 3, Pl\sql Developer 10.0.5.1710 PL/
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/
PL/SQL Deleloper does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client. 2. Install Oracle ClinetOracle client must be 32-bit only, the installation process is omitted .... After installation, create the Network/admin in the client's home directory, and then new the Tnsnames.ora file under the ADMIN subdirector
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/
Tags: des style blog tar width get1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL developer, and note that when you install the PL/SQL developer software, do not install in the program Files (x86) directory, or PL/
Instant-client (Database Instant client)Official note: The instant client is available under a separate OTN development and distribution license for Instant client, which allows the majority of licenses to be downloaded, redistributed, and deployed to the production environment at no charge.Why use Instant-client
No need to install, decompression is good;
Free.
Download instant-clientAddress: http://www.oracle.com/technetwork/cn/data
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.