Đang chuẩn bị liên kết để tải về tài liệu:
PL/SQL

Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ

Modes: IN: procedure must be called with a value for the parameter. Value cannot be changed OUT: procedure must be called with a variable for the parameter. Changes to the parameter are seen by the user (i.e., call by reference) IN OUT: value can be sent, and changes to the parameter are seen by the user | PL/SQL Objectives Why PL-SQL ? Language features Basic Structure of PL/SQL program Data Types Control Flow in PL-SQL Loops in PL-SQL Why PL SQL ? PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages like procedures, loops, variables, objects etc. Resulting a structural language that is more powerful than SQL PL SQL, Is there any Advantage ? In case of SQL to send 3 queries we will need three network trips between client and server. In PL-SQL we bundle any number of queries in a block and in single network trip task is done. SQL Query1 SQL Query2 SQL Query3 Client Server SQL Query1 SQL Query2 SQL Query3 Client Server PL-SQL Block Language features Supports constructs like any other 4th generation language: Variables and Data types Loops and Control statements Procedures and Functions Packages Triggers Objects Records (Its like structure in C language) PL SQL program structure Declare Begin Exception End; --It ends the program PL SQL nested block > Declare Begin > Declare Begin Exception End; Exception End; PL SQL Block Remember : Declare is optional and only required when variables need to be declared. Exception is optional and required when Error/Exception handling is done. Begin and End are mandatory as all logic and queries are written inside it. Declare Begin Exception End; PL SQL program- Sample I BEGIN Insert into Dept values(70,’HR’,’Pune’); Insert into Dept values(80,’PSD’,’Mumbai’); Insert into Dept values(90,’ESG’,’Pune’); END; --This program will insert three records at the same time in the table dept. PL SQL program- Sample II -- This program displays the sum of two numbers DECLARE v_num1 Number; v_num2 Number; v_sum Number; BEGIN V_num1 := &Number1; V_num2 := &Number2; V_sum := v_num1 + v_num2 ; . | PL/SQL Objectives Why PL-SQL ? Language features Basic Structure of PL/SQL program Data Types Control Flow in PL-SQL Loops in PL-SQL Why PL SQL ? PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages like procedures, loops, variables, objects etc. Resulting a structural language that is more powerful than SQL PL SQL, Is there any Advantage ? In case of SQL to send 3 queries we will need three network trips between client and server. In PL-SQL we bundle any number of queries in a block and in single network trip task is done. SQL Query1 SQL Query2 SQL Query3 Client Server SQL Query1 SQL Query2 SQL Query3 Client Server PL-SQL Block Language features Supports constructs like any other 4th generation language: Variables and Data types Loops and Control statements Procedures and Functions Packages Triggers Objects Records (Its like structure in C language) PL SQL program structure Declare

TÀI LIỆU LIÊN QUAN
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.