pl sql book

data.CREATE TABLE author(A_ID Number (8) is not NULL,A_name varchar2 (100),A_age Number (3));CREATE TABLE book(B_ID Number (8) is not NULL,B_name varchar2 (100),A_ID VARCHAR2 (100));Insert into author values (1001, ' Zhangsan ', 40);Insert into author values (1002, ' Lisi ', 30);Insert into author values (1003, ' Wangwu ', 50);CommitInsert INTO book values (2001, ' Think in

Tools of the menu item, and select the check box above in Autosave desktop on the right.B. Check the Window list option under Tools of the menu item.9. format SQL)When you get a long SQL statement and want to quickly view the logic, you can put it in this tool for formatting, and the statement logic will be clear at a glance.10. The database automatically detects connections Because the database is automat

[SQL] PL/SQL Syntax of Oracle and its extended data types summary PL/SQL syntax PL/SQL program consists of three parts: Declaration, execution, and exception handling. Template: [

Label: After a piece of SQL code is written, you can initially predict the performance of the SQL at run time by looking at the SQL execution plan, especially if you find that the SQL statement is inefficient, we can analyze the problem of the SQL code by looki

Gerenguishu;--13.3 Creating an IndexCREATE INDEX Chazhaoxinxi on Zyj_bumen (id,identi_name);--sequence creation and use--synonym creation----------------------------------------14, PL/SQL statements----------------------------------------14.1 PL/SQL statement block introduction and basic syntaxDECLARE[Variable declara

Label:1, PL/SQL developer remember login passwordWhen using PL/SQL developer, you want PL/SQL developer to remember the username and password to log in to Oracle for your convenience; Setup method:

Oracle Database-practical operations (3) PL/SQL Oracle ---- PL/SQL PL/SQL is a programming Language that combines Procedural Language and Structured Query Language (SQL ).

How to compile and run PL/SQL code snippets from a Case Study PL/SQL is a process-oriented structured programming statement developed by Oracle for database business logic requirements. In the Oracle kernel, there are two important components: PL/SLQ engine and

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, PL/

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, PL/

Oracle BASICS (4) pl/SQL PL/SQL is also a program Language called Procedural Language/SQL ). PL/SQL is an extension of SQL statements in Ora

Oracle series: PL/SQL tables 1. What is a PL/SQL table?First, PL/SQL tables and records are of the same composite data type. It can be seen as a user-defined data type.A pl/

the logic, you can put it in this tool, format, the logic of the statement is clear10. Automatic connection of databaseBecause the database does not operate for a period of time, it will automatically disconnect, and then need to manually connect themselves, because of the network, always stuck there. The tool provides the ability to detect connections, which can be automatically connected.The specific settings are checked in front of the Tools-preferences-check Connection,check connection.11.

Constant 1. Define the syntax format for constants Constant name constant type identifier [not null]:= value; constants, including the following variable names must begin with a letter, cannot have spaces, cannot exceed 30 characters in length, and cannot have the same name as reserved words, and the constant (variable) quantity name is case-insensitive and can be followed by a number or special character. Not NULL in parentheses is an optional parameter, and if selected, indicates that the con

The following tips only apply to PL/SQL developer 6 and later versions. Version 5 only has some features.1. Right-click the menuRight-click an object name in each text editing window in PL/SQL developer (PLD), such as SQL window, command window, And porgram window, A menu co

1. OverviewPL/SQL (Procedural Language/Structured Query Language) is a Procedural expansion of Oracle's standard database Language SQL. It associates the database technology with the Procedural programming Language, it is an application development language that processes data using loops and branches, and combines SQL data manipulation with procedural language d

The source of this article, in order to facilitate direct copy over. If there is infringement, please inform, thank youhttp://blog.csdn.net/chiclewu/article/details/14646687An Oracle 11g 64-bit version was installed in the virtual machine today, and when connected with PL/SQL developer, it was found that there was no database connection to TNS.It is considered that the