Label:A cursor is a private workspace that holds the results of the execution of an SQL statement.When executing an SQL statement, the database server opens a workspace where the results of the SQL statement are saved.There are two forms of cursors in the Oracle database: implicit and explicit cursors.Implicit cursors are defined by the database server, and expli
replaced by select; for example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements. Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit 1), create a text file Shortcuts.txt, and write the following content:S=selectCopy code is saved to the ~/plugins directory under the PL/
We know that there is an overhead for running SQL statements in PL/SQL programs, because SQL statements must be submitted to the SQL engine for processing.
The transfer of control between PL/S
Tags: how to set SQL text content to open before PL/SQL pre-load, pre-load textJoke: Remember when the first use of PL/SQL, the person who complained to give me a text, I do it with a text document opened,CTRL + A, CTRL + C,ctrl + V or a new "
Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/41479997After installing the 64bit oracle11g database, use PL/SQL to connect the database to solve the "Chinese characters" garbled problemSite Environment
Oper
Downloads.
Step 2: unzip the installation package1> after downloading, decompress the compressed file to a local path, for example, C:/instantclient.2> Create the network/admin folder in this path and create tnsnames in the C:/instantclient/network/admin folder. ora file, the file content is the TNS information of the database to be connected. For example:
WORCL =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.4) (PORT = 1521 )))(CONNECT_DATA =(SERVICE_NAME = orcl))
Four simple guidelines to improve the number and quality of Pl/sql code
I've been writing Pl/sql code since 1990. That means I've written tens of thousands of of lines of software code, but I'm sure most of the code is very clumsy and difficult to maintain.
Luckily, I find it's not too late to find and follow a new w
Label:The PL/SQL language is the language that Oracle expands on SQL.1 procedures, functions, triggers are written in PL/SQL2 procedures, functions, triggers are in Oracle3 PL/SQL statements can be called directly in Java Simple I
Due to the continuous updating of hardware technology, Win7 system gradually become mainstream, and computer memory gradually increased, in order to make full use of memory resources (because 32 of the system can only use up to 3G of memory), improve system performance, many people began to use the Win7 (64Bit) system. A 64-bit Oracle database is installed on a 64-bit system, but there is no corresponding 64-bit PL/
select; for example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements.Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit1), create a text file Shortcuts.txt, and write the following content:S=selectCopy code is saved to the ~/plugins directory under the PL/
PL/SQL Developer is an integrated development environment that specializes in developing applications for Oracle databases. PL/SQL is also a programming language called the procedural SQL language (procedural language/sql).
I uninstalled PL/SQL Developer and compared it with Toad for Oracle.
Previously, PL/SQL Developer was used to manage Oracle, which was inconvenient to use. It is very difficult to open, and there is always an extra box in the upper left corner of the interface. It cannot be set to hide it by default.
The only thing t
To use the Pl/sql program to complete a more complete database task, you need to further learn some advanced design elements of the content. The Pl/sql program that was written earlier, common to the absence of names, can only be stored as files, and then executed through the execution of files, so called nameless bloc
PrefaceBodyPL/SQL(Procedure Language, Procedural Language) SQL 1999 a structured Language commonly used by major database vendors PL/SQL only supports Oracle databasesBasic syntaxMulti-line comment/**/single-line comment --PLSQL BlockStructure[Declare]Define VariablesBeginProcess statement[Exception]Exception HandlingE
Tags: tools user detail ACL Oar data document Tin NTS1. How to check procedure exist: Sql> Conn oper/oper123Connected.sql> desc Dbms_lock;PROCEDURE Allocate_uniqueArgument Name Type in/out Default?------------------------------ ----------------------- ------ --------Lockname VARCHAR2 inLockhandle VARCHAR2 outExpiration_secs number in DEFAULTFUNCTION CONVERT RETURNS Number (38)Argument Name Type in/out Default?------------------------------ -----------
Recently, PL/SQL packages were hang during compilation and initially thought they were dependent on the object being locked. Unexpected results. The following shows the code demonstration.
1. When compiling the package in SQL * Plus, the SQL> alter package bo_syn_data_pkg compile; Alter package bo_syn_data_pkg compile
The case of PL/SQL programming specification
As in SQL, Pl/sql is case-insensitive. Its general guidelines are as follows:
Keywords (BEGIN, EXCEPTION, end, IF THEN else,loop, End LOOP), data type (VARCHAR2, number), internal functions (least, SUBSTR), and user-defined subr
One: PL/SQL program blockPL/SQL is a block-structured language, and a PL/SQL program is a code logic block.The PL/SQL program consists of three components:
1
Declarat
Pl/sql Developer is the primary tool for importing or exporting databases in an Oracle database, this article mainly introduces the process of importing and exporting databases using Pl/sql developer, and describes some of the considerations when importing or exporting, and then we introduce them. Export Step:1 Tools->
My environment is like this: Win7 64-bit + Oracle 11g + PL/SQL 9.04
Since PL/SQL does not support 64-bit data at the moment, only Oracle client 32-bit data can be used, so you need to download it from the official website:
Remember: you must download a 32-bit package)
Http://www.oracle.com/technetwork/database/features
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.