sql developer training

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 developer, a ora-00936 error was encountered w

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 Configuration File: D: \ Oracle11g \ product \ 11.2.0

Transferred from: http://zhengdu.net/archives/152First, see if the remote end Oracle service is startedIf it does not start, start the Oracle servicePS: Create or delete Oracle ListenerSecond, remote-side Oracle ConfigurationLISTENER_ORCL =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521))Oraclr_connection_data =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521)))(Connect_data =(SID = ORCL)(PRESENTATION = RO)))ORCL =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP

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 sessionYou can disable statistics inThe preference menu, or obtain selectPriviliges onV $ sessio

Win7 gradually became the current mainstream Windows operating system, with its 32 and 64-bit systems evenly tied. However, there is no 64-bit pl/sql developer come out, directly with 32-bit Pl/sql developer Connection Win7 (64-bit) as Oracle of the server, there is always such a mistake, through online data and their

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 developer; can't use the editor to view, efficiency don't know how PS: Only the

Win64-bit Oracle_11gR2 database installation + PL \ SQL Developer, win64oracle_11gr2 Download required software: Oracle_11gR2 and instantclient-basic-nt-11.2.0.3.0 and plsqldev9 Download link: http://pan.baidu.com/s/1gdH53IN Step 1: Install Oracle_11gR2 In the displayed "configuration Security Update" window, cancel "I want to accept security updates through My Oracle Support" and click "Next ":In the "Ins

(password: change_on_install) when the modifications are complete, click OK. In the Finish window, click Close. Step two: Decompression instantclient-basic-nt-11.2.0.3.0 to the installation directory I put it under the F:\Oracl\product directory. Step Three: Install and configure Plsql Developer Plsql Developer Normal next installation can be. The configuration is as follows: After the installation

When you create a new connection with an Oracle database, you encounter ora-12505, this problem is resolved and ora-12519 error, depressed for a half-day, after a toss problem solved, the following small series of my two solutions to share to you, for reference only. Solution One: Today when you work in a new connection to encounter ORA-12505, resolved and encountered ORA-12519 error. ORA-12505: There is no problem with using Pl/sql

Recently, because of the job needs, the boss asked the Oracle database on the server to migrate data to another server, I am not very familiar with Oracle, the migration of the database This is a matter of time spent, but also on the internet to inquire a lot of information. All kinds of moves are exhausted or not successfully migrated.Finally, the spirit of the dead horse as a live horse doctor, the Oracle SQL De