sql-plus.com

plsqltutorial.info

PL/SQL Tutorial - Learn PL/SQL Collections and Records, Examples

http://www.plsqltutorial.info/plsql-collections-and-records.php

PL/SQL Collections and Records. PL/SQL For Loop Statement. PL/SQL While Loop Statement. PL/SQL Collections and Records. Collections and recordings are compound data types containing internal elements like array, record or table. Collections are data types that allow simultaneous processing of multiple variables of the same type. Each element has a unique index, which determines its position in the collection. Nested Tables, Varrays, Associative Arrays (Index-By Tables). TYPE test IS TABLE OF VARCHAR2(50);.

plsqltutorial.info

PL/SQL Tutorial - Learn PL/SQL Cursors by examples with attributes

http://www.plsqltutorial.info/plsql-cursors.php

PL/SQL Collections and Records. PL/SQL For Loop Statement. PL/SQL While Loop Statement. PL/SQL uses implicit and explicit cursors. PL/SQL declare a implicit cursor for each operation to data manipulation in SQL. If you want precise control over the queries, you can declare a explicit cursor; You can define a explicit cursor for the queries which returns more than one registration. The implicit cursors are managed automatically by the PL/SQL. The attributes of the cursors. V id NUMBER:=3;. Oracle closes t...

en.wikipedia.org

SQL*Plus - Wikipedia, the free encyclopedia

https://en.wikipedia.org/wiki/SQL*Plus

From Wikipedia, the free encyclopedia. Is the most basic Oracle Database. Utility, with a basic command-line interface. Commonly used by users, administrators, and programmers. SQL*Plus understands five categories of text:. SQL*Plus internal commands, for example:. Environment control commands such as SET. Environment monitoring commands such as SHOW. External commands prefixed by the ! Scripts can include all of these components. Where the Oracle user. The first version of SQL*Plus was called UFI. A com...

plsqltutorial.info

PL/SQL Tutorial - Links to other online programming resources

http://www.plsqltutorial.info/links.php

PL/SQL Collections and Records. PL/SQL For Loop Statement. PL/SQL While Loop Statement. Website is a tutorial dedicated to sqlplus commands. With Sqlplus you can connect to Oracle server and execute the sqlplus commands like define, run, edit, save, set, show, describe. With SQL*Plus you can manage users administration, tables, operations of archiving and recovery. Present the syntax and examples of sql plus commands like: connect, startup, exit, get, prompt, print, cpoy, append, accept. Like us / join us.

plsqltutorial.info

PL/SQL Tutorial - Learn PL/SQL Exception Handling, Catch Errors, Raise

http://www.plsqltutorial.info/plsql-exception-handling-errors.php

PL/SQL Collections and Records. PL/SQL For Loop Statement. PL/SQL While Loop Statement. Exception Handling in PL/SQL refers to the concept of exception. The exception is an error or an warning message generated by the server or application. Exceptions may be defined, enabled, treated at the level of each block in the program. In PL/SQL there are two types of exceptions:. Internal exceptions that occur from the server. External user-defined exceptions which are declared in declarative section.