best book for oracle pl sql programming

Basic PL/SQL entry-Table Partitioning PL/SQL: a programming Language combined with a Structured Language (Structured Query Language). It is an extension of SQL and supports multiple data types, such as large objects and Collection

A trigger is a special type of subroutine that resides in a database. cannot be called directly by the user, but is initiated by the system when a particular event or action occursTune with the holder line. The trigger cannot accept the number of parameters. So executing a trigger is called triggering or ignition. An Oracle event refers to an INSERT, UPDATE,delete operation, or similar operation on a view of a database table. Triggers are a technique

PLSQL9.2 cannot connect to the Oracle database. When Oacle11g is installed on the system and Oacle10g is installed on the client, plsql is used to connect to the database. PL/SQL 9.2 cannot connect to the Oracle database. When the system is installed with Oacle 11 GB and the client is installed with Oacle 10 Gb, it wi

Oracle instant client is installed in Linux on the PL/SQL Dev Virtual Machine and Oracle is installed. Since PL/SQL Developer is used in Windows physical machines to connect to Oracle o

to the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin4. Set the language of Oracle, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * fr

segment......When conditional expression Results n ThenStatement Segment N[ELSE statement Segment]END case;Example: Show week based on input 1-7DECLAREV_week Number:= S;BEGIN CaseV_week when 1 ThenDbms_output. Put_Line ('Monday'); when 2 ThenDbms_output. Put_Line ('Tuesday'); when 3 ThenDbms_output. Put_Line ('Wednesday'); when 4 ThenDbms_output. Put_Line ('Thursday'); when 5 ThenDbms_output. Put_Line ('Friday'); when 6 ThenDbms_output. Put_Line ('Saturday'); when 7 ThenDbms_outp

Tags: structure space height def BMS img Complete declare ROCPL/SQL Programming one: Preface II: PL/SQL Overview Two--1:PL/SQL block structure 1 "declare" 2--declaration sect

The features of automatic PLSQL running in ORACLE: In the UNIXDE corn utility, the automatic scheduling task runs in PLSQL in ORACLE. The DBMS_JOB package allows you to schedule PLSQL Features of automatic PL/SQL running in ORACLE: Use the DBMS_JOB package in the UNIXDE corn

Tags: add SQL and article tle specified data javascrip too Reprint Please specify source: http://blog.csdn.net/dongdong9223/article/details/50728536This article is from "I'm a fish-hook blog." Connect Oracle using the PL/SQL Developer tool and error when logging in: ORA-12154:TNS:couldnot resolve the co

name after the hostname)2. Oracle Home and OCI libaray configured with PL/SQL developerEnter the PL/SQL Developer in non-logon mode, designate the Oracle home path as the Oracle Client

Label:Due to the continuous updating of hardware technology, Win7 system gradually become mainstream, and computer memory gradually increased, in order to make full use of memory resources (because 32 of the system can only use up to 3G of memory), improve system performance, many people began to use the Win7 (64Bit) system. A 64-bit Oracle database is installed on a 64-bit system, but there is no corresponding 64-bit

1, to use PL/SQL need to install the Oracle client (this is necessary, otherwise plsql will not use, this client can go to Oracle official Web download, called instance client, as far as possible with the newer version on it, The Windows version of the big is more than 50 m, as well as the lite version of more than 20

PL/SQL programming method Daquan I. dynamic SQL splicing (using replace) www.2cto.com pay attention to using replace to achieve dynamic SQL splicing effect, v_psql can be used to pass variables [plain] 1 declare 2 a number: = 2; 3 v_ SQL