oracle pl sql questions

3.1 using DML in PL/SQLIn the PL/SQL block, the two variables are assigned the value of a. : = Initialize. B. The SELECT INTO syntax, the declaration portion of a PL/SQL block is declared, and later can be assigned using a SELECT statement.3.1.1 Variable initialization using

Tags: prot cal appears application Evel directory name connect directory ZHS16GBKFirst, on the official website to download the corresponding version of PL SQL, the machine is 64-bit download 64-bit, URL: Https://www.allroundautomations.com/downloads.html#PLSClick the application. exe file to install.Installation is successful, open, there will be a need to register the pop-up window, enter the following re

I. PL/SQL tools for Oracle data export1. Data Object ExportTools, export user objects, pop up the following interface:Select the user, select the path of the export file, name the export file name (. sql), and click Export.Note: This method can only export data objects, cannot export data stored in tables,650) this.wid

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

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

No way, only their own research, after about a day, or do a good job, write a summary. There are probably several solutions for this problem: 1. Insufficient permissions, resulting in pop-up empty bar prompt box. (directly on the link) Http://jingyan.baidu.com/article/066074d6760959c3c21cb0d6.html Right-click on the Pl/sql icon---properties---compatibility--Administrator to run this program on the h

First, go to Oracle's website to download an Oracle 11g Client (My 11g Oracle), but you need to apply for an Oracle account before you can download it.Current: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlThis is a green version of Oracle Client, so as long as it needs to be decompressed, it can be. Unzi

Environment:Win7 64bit Ultimate Oracle 11gRequired Software and:Oracle 64bit ClientHttp://www.oracle.com/technetwork/topics/winx64soft-089540.htmlPL/SQL DEVhttp://www.plsqldev.com/Configuring Tnsnames.ora file Instances#tnsnames. oranetworkconfigurationfile:f:\oracle\product\11.2.0\client_1\network\admin\tnsnames.ora# Generated byOracle configuration Tools. Loca

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->conne

what is PL/SQLPL/SQL is a process-procedural language (LANGUAGE/SQL). PL/SQL is an extension of the Oracle database to the statement. In the use of ordinary SQL statements to add the ch

advantages of PL/SQL are also:? Support SQLSQL is the standard language to access the database, and with SQL commands, users can manipulate the data in the database. PL/SQLSupports all SQL data manipulation commands, cursor control commands, transaction control commands,

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 crea