Tns_admin and the value is the path to the Tnsnames.ora file, for example: E:\oracleclient\instantclient_11_24.After installing Plsql, start, Cancel, and click Tools->preferences->connection:Oracle home=e:\oracleclient\instantclient_11_2OCI Library=e:\oracleclient\instantclient_11_2\oci.dllRestart Plsql, enter the user name, password, select the PL/SQL instance name to enter the database5.The initial login
Label:I. PL/SQL Developer Development ToolsPL/SQL Developer is an integrated development environment (IDE) for developing PL/SQL blocks, which is a standalone product, not a companion to Oracle. Second,
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
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
Many people, especially those who do not like Oracle, must learn from Oracle and think that Oracle occupies a lot of memory.I really don't like installing oracle on a physical machine. Most of them are Windows users, and most of them are developers.Based on the above requirements, I provide a solution:Attach an
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
implement complex functions, you may need to pl/ Additional PL/SQL blocks are nested within the block.Six, block structureA PL/SQL block consists of three parts: the definition section, the execution section, and the Exception handling section.As shown below:Declare/* Defin
Original article: http://www.bootad.cn/post/185.html
As we all know, to connect to Oracle using PL/SQL, you need to install the Oracle client software. Have you ever wondered whether to directly connect to Oracle without installing the
VARCHAR2) isBeginINSERT into EMP (empno,ename) values (in_no,in_name);EndThe out parameter represents the user's outputProgram Demo:Create or Replace procedure My_pro (In_no in Number,out_name out varchar2,out_sal off number) isBeginSelect Ename,sal to Out_name,out_sal from EMP where empno=in_no;Endin Sqlplus, you want the value after the process with the output has finished executingMethod 1: Write anonymous blocksDeclareV_name Emp.ename%type;V_sal Emp.sal%type;BeginMy_pro (7369,v_name,v_sal);
Oracle pl/SQL programming the use of SQL statements select must have a return record, do not report an error saying that no data is found and must have an into select statement to return one and only one record cannot be written as where deptno = 10 because multiple records will be returned. Of course, the record menti
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
Original Title: Oracle and PL/SQL recipes: a problem-solution approach Author: (US) Josh Juneau Matt arena Translator: Political Commissar Name: turing Program Design Series Press: People's post and telecommunications Press ISBN: 9787115320766 Release Date: June 2013 publication date: 16 open pages: 376 versions: 1-1 category: computer> database>
a sub-block, the variables defined in the sub-block are used. The variables defined in the Child block cannot be referenced by the parent block. Similarly, the GOTO statement cannot jump from the parent block to the sub-block. Otherwise, it is legal.Outer BlockDeclareA_number integer;B _number integer;Begin-- A_number and B _number are available hereDeclareC_number integerB _number number (20)BeginC_number: = a_number;C_number = outer_block. B _number;End sub_block;End out_block;SummaryThis art
The ORACLE tutorial is: Oracle uses PL/SQL to operate COM objects. PL/SQL is a specialized language for programming in Oracle databases. It is a third-generation procedural programming
Chinese_china. ZHS16GBK ", (American_america. US7ASCII is an ASCII encoding type, other types can go to the server to look at it or find it online (this step to do right, if the code is wrong, will produce garbled) ④ download and install plsql Developer Configuration Application: Open plsqldeveloper, Login interface point Cancel, enter after the menu bar tools->preferences->connection settings: Oracle home
://wenku.baidu.com/view/e0e569c3bb4cf7ec4afed0db.html2. ConfigurationOn the server side, follow these steps:Select Net Manager, and thenAlways default Next,Ii. Oracle Client Installation and configurationInstallation is very simple, directly select the second item, has been the default next, until completed.Configuration:Select Net Configuration Assistant, and then select Local Network connectionAlways default Next, appearsFill in the Global database
Document directory
PL/SQL syntax
% Type of Custom Data Type
Record of composite data type
% Rowtype of composite data type
Summary of Oracle Extended Data Types
PL/SQL syntax
The PL/SQL
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.