PL/SQL is an extension of Oracle's standard database language, Oracle has consolidated PL/SQL into Oracle servers and other tools, and more developers and DBAs have begun using PL/SQL in recent years, and this article will cover PL/SQL basic syntax,
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 SQL statements and programming methods,
-- Exception test declarev_ename EMP. empno % type; -- defines the variable beginselect ename into v_ename from EMP where empno = & gno; dbms_output.put_line ('name: '| v_ename ); exception when no_data_found then dbms_output.put_line ('unfound');
Shortcut:===============================================================================Edit/undo Ctrl + ZEdit/redo shift+ctrl+zEdit/pl/sql beautifier ctrl+w (Custom) shift+home Select the cursor position to the beginning of the line
1. PL/SQL Developer remember login password when using PL/SQL developer, in order to work conveniently hope PL/SQL Developer remember login Oracle user name and password; Setup method: PL/SQL Developer->tools->preferences->oracle->logon history,
Oracle PL/SQL practiceBasic InformationAuthor: (English) bilington (A.) and so on, Lu Tao [Translator's introduction]Press: People's post and telecommunications PressISBN: 9787115294852Mounting time:Published on: February 1, November 2012Start:
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:
1. My Objects is automatically selected by default after logon.By default, after PLSQL Developer logs on, All objects will be selected in Brower. If the user you log on to is dba, it will take several seconds to expand the tables directory, after
1. My Objects is automatically selected by default after logon.By default, after PLSQL Developer logs on, All objects will be selected in Brower. If the user you log on to is dba, it will take several seconds to expand the tables directory, after
Oracle tutorial pl/SQL introduction, oracle tutorial plsql
This example describes Oracle pl/SQL. We will share this with you for your reference. The details are as follows:
I. What is pl/SQL?
Pl/SQL (procedural language/SQL) is an extension of
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.