Groups > comp.databases.ms-sqlserver > #1951

Oracle PL/SQL | Programming in Simple Steps

X-Received	by 10.107.14.141 with SMTP id 135mr15734833ioo.22.1454696219340; Fri, 05 Feb 2016 10:16:59 -0800 (PST)
X-Received	by 10.140.102.41 with SMTP id v38mr418735qge.2.1454696219216; Fri, 05 Feb 2016 10:16:59 -0800 (PST)
Path	csiph.com!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!news.glorb.com!o2no2475337iga.0!news-out.google.com!h33ni569qge.1!nntp.google.com!94no661919qgt.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Fri, 5 Feb 2016 10:16:58 -0800 (PST)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=117.203.17.254; posting-account=FXrL2goAAADt3hhiophoceUdp-DbUVzi
NNTP-Posting-Host	117.203.17.254
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<a4127372-06f2-4aa1-ab67-7c6f5aeb1cf3@googlegroups.com> (permalink)
Subject	Oracle PL/SQL \| Programming in Simple Steps
From	anitagoyal571@gmail.com
Injection-Date	Fri, 05 Feb 2016 18:16:59 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.databases.ms-sqlserver:1951

Show key headers only | View raw

Enhance the capabilities of SQL as PL/SQL allows mixing of SQL statements with procedural constructs. Unlike SQL, PL/SQL is a programming language extending SQL, which includes procedural elements like loops, data types, control structures and others. You can create program blocks, functions, methods, triggers and packages with this extension. In simple terms, while SQL tells the relational database what to do, PL/SQL tells them how to do.

The main sections on language PL/SQL are:
1. DML Statements
2. Select Query
3. Table Joins
4. Stored Procedures
5. Functions
6. Collections and Records
7. Cursors
8. Exception Handling
9. Triggers
10. Views
11. Error Messages

Start learning Oracle PL/SQL from basics to advance levels here...
https://goo.gl/KMSUDC

Back to comp.databases.ms-sqlserver | Previous | Next | Find similar

Thread

Oracle PL/SQL | Programming in Simple Steps anitagoyal571@gmail.com - 2016-02-05 10:16 -0800

csiph-web