pl sql basics

Downloads. Step 2: unzip the installation package1> after downloading, decompress the compressed file to a local path, for example, C:/instantclient.2> Create the network/admin folder in this path and create tnsnames in the C:/instantclient/network/admin folder. ora file, the file content is the TNS information of the database to be connected. For example: WORCL =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.4) (PORT = 1521 )))(CONNECT_DATA =(SERVICE_NAME = orcl))

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/41479997After installing the 64bit oracle11g database, use PL/SQL to connect the database to solve the "Chinese characters" garbled problemSite Environment Oper

Oracle is a large database with a C/SClient/Server structure. It is mainly used in the 4GLSQL language and has the advantages of being powerful, simple, and easy to learn. The working process of the C/S structure is: when the client c end) inputs and sends an SQL statement, it will be sent to the server S end through the network ), the result is analyzed and executed, and then returned to the client through the network. At this time, the client can se

Tags: Nextval SQL statement throws exception handling implicitly no i+1 func has a1. Database design: For user-specific needs, then we create a most practical and high performance database! Steps for database design: 01. Demand Analysis 02. Conceptual Structure Design 03. Logical Structure Design 04. Physical Organization Design 05. Implementation of the database 06. Operation and maintenance of the database 3 major paradigms of the database: 1. Ensur

The flow control statements in the PL/SQL program draw on the process control ideas of many high-level languages, but have their own characteristics. Condition control The following example describes the use of conditional control statements. 1. If.. Then.. End If condition control Use If.. Then.. The End If condition controls the syntax structure as shown in Figure 9.15. Execute the following

I. Related content1. Master the structure of PL/SQL program block, understand and familiar with the application of various variables.Second, the specific operation(i) using the system user login Sql*plus, create a user using the SQL statement: U_ your initials (for example: U_zs), the password is: T_ your number three

I uninstalled PL/SQL Developer and compared it with Toad for Oracle. Previously, PL/SQL Developer was used to manage Oracle, which was inconvenient to use. It is very difficult to open, and there is always an extra box in the upper left corner of the interface. It cannot be set to hide it by default. The only thing t

To use the Pl/sql program to complete a more complete database task, you need to further learn some advanced design elements of the content. The Pl/sql program that was written earlier, common to the absence of names, can only be stored as files, and then executed through the execution of files, so called nameless bloc

Tags: SQL language Data System Self programming old version png des oafPL/SQL is an integrated development environment for oralcle databases and is the primary tool for many Oracle database developers. Because PL/SQL (Baidu Encyclopedia) is not only a kind of language, but also a process programming language, in the pr

Label: The execution and exception parts of PL/SQL in Oracle I. The executive section of PL/SQL. An assignment statement. Assignment statements are divided into two types, one defining a variable and then receiving the user's IO assignment, and the other is assigning a value to the

Tags: how to set SQL text content to open before PL/SQL pre-load, pre-load textJoke: Remember when the first use of PL/SQL, the person who complained to give me a text, I do it with a text document opened,CTRL + A, CTRL + C,ctrl + V or a new "

[connect] Disconnects from the database Edit Displays a text editor to edit the SQL Buffer Exec [ute] Procedure Executes the specified procedure Exit [application] Quits a running script or closes the command window. Adding the application parameter will also close PL/SQL developer. Get [filename] Loads a comman

Book Description Oracle PL/SQL recipesIs yourGoBook for PL/SQL programming solutions. it takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. then