Fundementals of PL/SQL

Every Programming language has a syntax, vocabulary, and character set. In order to communicate within that language, we have to learn the rules that govern its usage. PL/SQL is a relatively simple programming language. Like other programming languages, PL/SQL has a character set, reserved words, punctuation, datatypes, and fixed syntax rules.

This chapter contains these topics:

PL/SQLCharacter Sets

Conditional Compilation

PL/SQL Built-In Functions

Comments disabled

Comments on this article have been disabled.

Notify a mention to this article (trackback)

Identification

Article search

Sections

Oracle Administration (6.13.2010)
- Introduction to DataBase Administration (8.14.2010)
- Types of Oracle Database users (8.14.2010)
Oracle Backup and Recovery (6.13.2010)
- Oracle Backup:Basic concepts (8.15.2010)
- Oracle Recovery:Basic Concepts (8.15.2010)
Oracle PL/SQL (6.13.2010)
- ASCII Function in PL/SQL (6.19.2010)
- Oracle PL/SQL:Built In Exceptions (7.15.2010)
- PL/SQL:CASE Statement (7.15.2010)
- Character Functions in PL/SQL (6.19.2010)
- Comments in PL/SQL (6.18.2010)
- Conditional Control Statments (7.15.2010)
- Cursor FOR Loop (7.26.2010)
- Oracle PL/SQL:Data Types (7.15.2010)
- Oracle PL/SQL:Constants (7.15.2010)
- Oracle PL/SQL :Declaring Variables (7.15.2010)
- Delimiters (6.17.2010)
- EXIT Statement in PL/SQL (7.22.2010)
- EXIT-WHEN statement in PL SQL (7.22.2010)
- FOR Loop in Oracle PL SQL (7.26.2010)
- Fundementals of PL/SQL (6.15.2010)
  - Declarations (6.17.2010)
- PL/SQL:GOTO Statement (7.18.2010)
- Identifiers (6.16.2010)
- Identifiers(contd..) (6.16.2010)
- Oracle PL/SQL:IF-THEN-ELSE Statment (7.15.2010)
- INSTRC Function in PL/SQL (6.19.2010)
- Introduction to PL/SQL (6.13.2010)
- Lexical Units (6.15.2010)
- Loop statement In PL SQL (7.22.2010)
- Loops in Oracle PL SQL (7.20.2010)
- NLS_LOWER Function in PL/SQL (6.20.2010)
- Oracle Built In Functions:ACOS function (7.10.2010)
- Oracle Built In Functions:ADD_MONTHS Function (7.10.2010)
- Oracle Built In Functions:ATAN function (7.10.2010)
- Oracle Built in Functions:ATAN2 function (7.10.2010)
- Oracle Built in Functions:AVG function (7.10.2010)
- Oracle Built In Functions:CEIL function (7.10.2010)
- Oracle Built In Functions:EXP function (7.10.2010)
- Oracle Built In Functions:FLOOR function (7.10.2010)
- Oracle Built In Functions:LN function (7.10.2010)
- Oracle Built In Functions:MOD function (7.10.2010)
- Oracle Built In Functions:Numeric Functions (7.10.2010)
- Oracle Built In Functions:SIGN Function (7.10.2010)
- Oracle Built In Functions:SIN function (7.10.2010)
- Oracle Built In Functions:SINH function (7.10.2010)
- Oracle Built In Functions:SQRT function (7.10.2010)
- Oracle Built In Functions:TAN function (7.10.2010)
- Oracle Built in Functions:LOG function (7.10.2010)
- PL/SQL Built-in Functions (6.19.2010)
- PL/SQL Character Set (6.15.2010)
- RETURN Statement in PL SQL (7.22.2010)
- Sequential Control Statements (7.18.2010)
- Oracle PL/SQL:Stored Functions (7.15.2010)
- Oracle PL/SQL:Stored Procedures (7.15.2010)
- Oracle Pl/SQL Stored Procedures:Procedure Parameters (7.15.2010)
- Stored Procedures:Advanced Concepts (7.15.2010)
- WHILE Loop in Oracle PL SQL (7.27.2010)
Oracle Database Tuning (6.13.2010)
- SQL Tuning Tips-Identify Bad SQL Statements (8.12.2010)
Partners (8.4.2010)
Oracle SQL * Plus (6.13.2010)
- Introduction to SQL (7.12.2010)
- Introduction to SQL* Plus (8.2.2010)
- SQL Select Statement (8.8.2010)
- Script Files in SQL * Plus (8.3.2010)
- SQL * Plus Editing Commands (8.2.2010)
About Us (6.16.2010)

Last articles

Partitioning in oracle (3.26.2011)
Using SQL statements in C (2.15.2011)
UTL_FILE_DIR in Oracle (1.28.2011)
Use DECODE for IF/ELSE Selection (1.27.2011)
DBMS_ALERT Package (1.19.2011)
Oracle 11g:Automatic Storage Management (1.1.2011)
Using SQL Trace in oracle (12.29.2010)
Exception Handling in Oracle PL/SQL (12.21.2010)
Relational Database Management System(RDBMS) (12.21.2010)
Pseudocolumns in SQL (12.18.2010)

Categories

Built-In Functions (RSS) (14)
C SQL Connection (RSS) (0)
Exception Handling (RSS) (1)
Home (RSS) (6)
Oracle Administration (RSS) (1)
Oracle ASM (RSS) (1)
Oracle Backup and Recovery (RSS) (1)
Oracle Error Codes (RSS) (1)
Oracle Initialization Parameters (RSS) (1)
Oracle Packages (RSS) (1)
Oracle PL/SQL (RSS) (41)
- Cursor in PL/SQL (RSS) (3)
- Exception Handling in PL/SQL (RSS) (0)
- Fundementals of PL/SQL (RSS) (8)
- Introduction to PL/SQL (RSS) (3)
- PL/SQL Functions (RSS) (1)
- Records in Oracle (RSS) (4)
- Triggers in oracle (RSS) (5)
Oracle Tips and Tricks (RSS) (0)
Oracle Tuning (RSS) (10)
Pro *C (RSS) (1)
Procedures in PL/SQL (RSS) (3)
RDBMS (RSS) (1)
SQL tutorials (RSS) (10)

Monthly archives

Favourite sites

Subscribe to this site

Stay current with Techno Oracle on these personalized pages: