sql server developer edition

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

Get ready: PL/SQL Developer: I'm using plsqldev1005 (32-bit) Win32_11gr2_client: Remember that it must be 32-bit, because PL/SQL developer only recognize 32-bit After the installation is successful, you need to configure the environment variables:Tns_admin environment variable, similar to: C:\app\Lzj\

Tags: PL/SQL developer do not install client connection to remote Oracle databasePL/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

database. 3. Connect to the database using PL/SQL developerThe database is populated with the service_name of the remote databases ,Note: According to the actual user name, password and database:User name: Gateway Password: Gateway database: ORCL 4, after the connection in the PL/SQL developer operation of the remote database, create a new

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

Pl/SQL developer open the table garbled. In pl/SQL developer, view the table structure. The table structure comments are all ???, It is normal to view the table structure directly in the cmd window, which indicates that it is a problem with pl/SQL

Install Oracle database management software SQL Developer in Ubuntu 14.04 This is the second article about building Oracle Development Environment logs. Article 1: Build a PHP5 + Apache2 + Oracle environment in Ubuntu 14.04 This article will install the Oracle database management software SQL Developer on Ubuntu 14.04.

After Oracle 10 Gb is installed, a table is created to write Chinese data. It is found that the PL/SQL developer tool cannot display Chinese normally. To display Chinese characters properly, the server must be consistent with the client encoding. Therefore, check. 1. Check the server code: Execute

When you use PL/SQL developer 7 to connect to a newly installed Oracle database server, ORA-01460 errors always occur frequently: type conversion errors. Only PL/SQL developer has this problem. The suspect is a character set problem. I checked a lot of information and fo

Label: 1, PL/SQL Developer Text field display garbled Reason: Because the database number format and the PL/SQL Developer encoding format is not unified.2, PL/SQL Developer Encoding Format Setup detailed solution is as follows:Fir

you created the soft link through the command line 3.checking Oracle Instant Client SDK Header directory ... configure:error:Oracle Instant Client SDK header files not Foun DWhether your SDK folder is located in the Instantclient directory. 4.ERROR: '/tmp/pear/temp/oci8/configure--with-oci8=instantclient,/usr/local/lib/instantclient ' failedThe path followed by the--with-oci8 is correct and should be the last directory we copied. Ubuntu 14.04 Install Oracle database management software

Skype for business feature Prerequisites for in-place upgrade:List of all prerequisites mentioned here: Installation Prerequisites Ensure that the entire Lync Server 2013 environment is installed with CU5 (Lync Server Cumulative Update KB 2809243): http://www.microsoft.com/en-us/download/ details.aspx?id=36820 Local SQL Express must have at lea

Normally, connecting Oracle with PL/SQL developer requires the installation of Oracle client software, which means that your hard drive will take up about 1g-2g of space, and you will have some more boot-enabled services for the Windows operating system. Of course, for most people, you don't apply the database you create on your own machine, but just want to connect to the database on the

Comparison:Plsqldev: Third-party, fast startup software, slow execution of SQL queriesSqldeveloper:oracle company, slow startup software, fast execution of SQL queriesObjective:To connect a local Oracle Server service-side instance using SqldeveloperUsing Sqldeveloper to connect to a remote Oracle client instanceEnvironment:Oracle 11gOracleClient 11g ODACOracle

1, error 1: initialization error could not initializeThe computer was originally equipped with Oracle 11g 64-bit, but PL/SQL is not connected, reported " initialization Error "The mistake of collecting data to find the cause of the original PL/SQL is a 32-bit of, and Oracle Client is 64 bits (originally installed from the server side) , they are incompatible