1) classification of Sets
Oracle supports three types of collections:
Associative array (Index-by table)
Nested table)
Variable-length array (VARRAY)
One of their differences is that the Nested table and VARRY can be used either in PL/SQL or directly in the database, but the Associative array doesn't work, that is, associative array cannot be created separately using the create type statement. It can only b
Working with Dates in PL/SQL (date used in PL/SQL) The previous articles in this introductory PL/SQL series focused on working with strings and numbers in PL/
For SQL optimization, you can use SQL tuning advisor to achieve automatic SQL optimization and adjustment. For PL/SQL code, there are both SQL code and PL/
Working with Numbers in PL/SQL (use numbers in PL/SQL) This article gives you all the information you need in order to begin working with Numbers in your PL/SQL programs. numbers in PL/
PL-SQL package creation and application, pl-SQL CreationZookeeper
Creating and applying PL-SQL packages
① IntroductionA package is a combination of PL/
1. The various parts of the sub-program:Declaration section, executable part, exception handling section (optional)2. Sub-Program classification:A. Procedures-performing certain operationsA. Syntax for creating a procedure:CREATE [OR REPLACE] PROCEDURE BEGIN[EXCEPTIONEND;B. Three modes of process parameters:In: Used to accept the value of the calling program, the default parameter modeOut: Used to return a value to the calling programIn out: Used to accept the value of the calling program and re
PL/SQL program control structure and change data and manage transactions in PL/SQL, plsql1. condition Control
A. IF condition branch Syntax:
If (condition 1) then
Statement;
Elsif (condition 2) then
Statement;
Elsif (Condition 3) then
Statement;
Else
Statement;
End if;
B. case condition branch: equivalent comparison, c
................................................................................................ END LOOP; D. Nesting loops and Labels: defining labels: 3. Sequential controlA.goto statement: Used to jump to a specified The disadvantage is that it increases the complexity of the program and reduces readability, so Oracle does not recommend using it for the day. B. NULL statement: Empty statement, do not have any actual effect, usually occupy position with 4. Exception Handling A. There are two
This article gives you all the information you need in order to begin working with numbers in your PL/SQL programs.Numbers in PL/SQL
PL/SQL offers a variety of numeric datatypes to suit different purposes:
Number. A true decimal
v_job= ' salesman ' then UPDATE scott.emp SET sal=sal* (1+c_salesman) WHERE empno=empno1; elsif v_job= ' MANAGER ' then UPDATE scott.emp SET sal=sal* (1+c_manager) WHERE empno=empno1; elsif v_job= ' SR.CONT ' then UPDATE scott.emp SET sal=sal* (1+c_sr_cont) WHERE empno=empno1; END IF; --Displays completion information dbms_output. Put_Line (' already for employees ' | | empno1| | ' A successful raise! '); EXCEPTION-handling of PL/
1. Traditional layer by layer data, and Plsql as a separate unit to return to the client, reduce the query, reduce the network transmission of the round trip, funny2.pl/sql statement blocks are divided into two types: naming (subroutines, functions, packages that exist in the database, and later can be referenced by name), AnonymousDifference: A named statement block is stored in a database, referenced by a
PL/SQL language development Reference Manual: PL/SQL cursor
PL/SQL language development Reference Manual1. cursor)The cursor is the data extracted from the data table. It is stored in the memory as a temporary table. There is a da
Label:Control statements are fundamental to any language, to any programmer. Learn PL/SQL, only to realize the simplicity of Java grammar, it is not an era of things, of course, their positioning is not the same, not in their own longer than the short of others. --The 4th chapter begins--code 4.1 The simplest if statement uses example DECLARE v_count number (10): = 0; --Define the counter variable V_empno
PLSQLPL/SQL developer is an Oracle Database DeveloperProgramIntegrated Unit Development Environment (IDE). With PL/SQL developer, you can easily create the server part of your client/server application. So far, you can do the following in the worst case:• Use a text editor to Write Program units (processes, triggers, and so on ).• Use Oracle
The key to performance optimization is to find the right direction, for example, for a PL/SQL code, we think it is slow to execute, but in the end it needs a measurable tool to analyze, and we sometimes like to leave debug code in it, like using dbms_utility.get_ Time is spent on the execution of the statement, which can be cumbersome if the code is large.PL/SQL
Chapter 2 procedural performance tuning of PL/SQL applications
I. Reasons for PL/SQL Performance problems
When the execution efficiency of PL/SQL-based applications is low, it is usually caused by poor
Today, I am working on an OA report. I use a stored procedure to calculate some data. When doing a for xxx in xxxx loop end loop; loop, I never knew it was Mao. I can't catch the no_data_found exception in for any more. Once this no_data_found Oracle occurs, it automatically jumps out of the for loop, but I don't know what went wrong, that was depressing for an hour. Shit. Later I remembered that pl/SQL too
Today, I am working on an OA report. I use a stored procedure to calculate some data. When doing a for XXX in xxxx loop end loop; loop,
I never knew it was Mao. I cannot catch the no_data_found exception in for any more. Once this no_data_found occurs
Oracle will automatically Jump Out Of The for loop, but I don't know where the error occurred. It was a depressing hour. Shit.
Later I remembered that PL/SQL
total execution time of all units. When switching to the Unit module, the total execution time of the Unit module is
Unit -- unit name, that is, the stored procedure of execution, including the calling process and anonymous block.Line -- code line numberTotal time -- the execution time of the line of code (the color length represents the percentage of the execution time of the line of code and the maximum code execution time)Occurrences-number of executions of this rowText-the corresponding lin
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.