TAILIEUCHUNG - PL/SQL

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 (., 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 ; .

• Cơ sở dữ liệu
• Data Types
• Composite Types
• Variable Declaration
• Conditional Statements
• Cursor Attributes
• Creating Procedures
• công nghệ thông tin
• kỹ thuật lập trình
• Oreilly Ado Dot Net Cookbook Ebook Lib
• Mapping
• NET Data Provider Data Types to
• NET Framework Data Types
• Programming Languages
• Implementation of Data Structures
• Elementary data types
• Structured data types
• Data objects
• Variable and Data Types
• Bài giảng Variable and Data Types
• Biến và kiểu dữ liệu
• Toán tử biểu thức
• Câu lệnh nhập
• Trình bày thuật toán bằng lưu đồ
• Lecture Introduction to computing
• Bài giảng Nhập môn máy tính
• Introduction to computing
• JavaScript data types
• Declaring variables
• Lecture Windows programming
• Bài giảng Lập trình Windows
• Windows programming
• Data types classification
• Integral data types
• Bitwise shift operators
• Introduction to java programming
• Primitive Data Types and Operation
• Assignment Statements
• Declaring and Initializing in One Step
• Numerical Data Types
• Programming with C
• Lecture Elementary programming with C
• Programming language
• Identifier names
• Derived data types
• Introduction to Computer Programming
• Nhập môn lập trình
• Kỹ thuật lập trình
• Data types in C
• enum Data type
• struct Data type
• Programming Fundamentals
• Struct Data Types
• Struct data type definitions
• Member accesses
• Simple data processing
• Data structures
• Lecture ECE 250
• Lecture Algorithms and data structures
• Algorithm analysis
• Graph algorithms
• Abstract data types
• Case studies in python
• Programming concepts
• Further reading
• Abstract data types in python
• Organizing data
• Java Data Access
• Database Primer
• JDBC Query
• Design Patterns
• JDBC Data Types
• Java Data Access Development
• home reading 2
• Importance of Data
• Data Collection
• types of data
• Primary Data
• problem solving course
• Giáo dục đào tạo
• giáo trình cao đẳng đại học
• giáo trình tin học
• giáo trình C++
• Module 7 More Data Types and Operators
• Built in simple data types
• Stream I O
• Control structures
• User defined functions
• reference parameters
• Built in array types
• Class construct
• C++ programming
• Lecture C++ programming
• Lập trình C++
• Ngôn ngữ lập trình C++
• User defined simple data types
• Enumeration type
• Advanced data types
• Declaring structure variables
• Accessing structure elements
• Computer science
• Computer science using Java
• Programming using Java
• Java programming
• Fundamental data types of Java
• Java programming language
• Bài giảng ngôn ngữ lập trình Java
• Primitive data types
• Formatting numeric ouput
• Using named constants
• Custom data types
• Member access operator
• Nested structures
• Fundamentals of computing
• Lecture Fundamentals of computing 1
• Number primitive types
• Mixing types
• Excel Data
• Excel Data Types
• microsoft excel
• Windows Programs
• Excel Data Analysis
• using excel
• Gis data models
• Graphic Features
• Digital Orthophotograph
• Raster Data Sources
• Geographic Data Types
• ngôn ngữ lập trình
• lập trình
• ngôn ngữ C#
• C#