Programación Básica en PLSQL

Plan de Estudio

Capítulo 1
Elementos de PL/SQL
La estructura de PL/SQL
Los bloques en PL/SQL
Unidades léxicas
Identificadores
Delimitadores
Literales
Comentarios
Tipos (Datatypes) y conversiones
Tipos de datos ANSI, DB2 y SQL/DS
Formatos
Formatos de elementos numéricos
Formatos de fechas
Caracteres ASCII y EBCDIC con ORACLE 10g SQL y PL/SQL
Variables
Expresiones y operadores
Operadores aritméticos
Operador concatenación
Operadores de comparación
Operadores de conjuntos
Operadores lógicos
Orden de prioridad de los operadores
Funciones predefinidas
Funciones numéricas
Funciones carácter que devuelven valores carácter
Funciones carácter que devuelven valores numéricos
Funciones de fecha
Funciones de conversión
Funciones agregadas

Capítulo 2
Estructuras de control en PL/SQL
Tipos de estructuras de control en PL/SQL
Estructuras condicionales
IF-THEN
IF-THEN-ELSE
IF-THEN-ELSIF
CASE
Bucles
Bucles simples
Bucles WHILE
Bucles FOR numéricos
Órdenes GOTO y etiquetas
Orden NULL

Capítulo 3
Registros, tablas y matrices en PL/SQL
Registros en PL/SQL
Utilización de %TYPE y %ROWTYPE
Inicializando y referenciando registros
Asignación de registros
Tablas y matrices
Atributo COUNT
Atributo DELETE
Atributo EXISTS
Atributos FIRST y LAST
Atributos NEXT y PRIOR
VARRAYS

Capítulo 4
SQL en PL/SQL
SQL en PL/SQL
Lenguaje de manipulación de datos en PL/SQL
Lenguaje de definición de datos en PL/SQL
Enlaces de bases de datos
Secuencias
Sinónimos
Instrucción ROWNUM
Instrucción ROWID
Sentencias GRANT y REVOQUE
Lenguaje de control de transacciones en PL/SQL
Sentencia COMMIT
Sentencia ROLLBACK
Sentencia SET TRANSACTION
Sentencia SAVE POINT
Funciones integradas en PL/SQL
Funciones de cadena
Funciones numéricas
Funciones de fechas
Funciones de conversión y transformación
Conversiones automáticas
Funciones TRANSLATE y DECODE

Capítulo 5
Cursores en PL/SQL
Cursores
Cursores explícitos
Cursores implícitos
Bucles de extracción mediante cursor
Variables de cursor

Capítulo 6
Subprogramas: procedimientos, funciones, paquetes y disparadores
Subprogramas almacenados: procedimientos y funciones
Creación de procedimientos almacenados
Creación de funciones
Eliminación de procedimientos y funciones
Subprogramas locales
Procedimientos locales
Funciones locales
Paquetes
Disparadores

Capítulo 7
Objetos y colecciones
Introducción a la programación orientada a objetos
Bases de datos objeto-relacionales
Tipos de objetos
Especificaciones del tipo de objeto
Cuerpo del tipo de objeto
Modificación y eliminación de tipos
Objetos de base de datos
Objetos transitorios y persistentes
Identificadores y referencias a objetos
Objetos en las órdenes DML
Varrays
Tablas anidadas
Varrays en la base de datos
Colecciones

Capítulo 8
Excepciones y PL/SQL dinámico
Excepciones
Excepciones predefinidas
Excepciones definidas por el usuario
La sentencia RAISE
SQLCODE y SQLRRM
Excepciones personalizadas en PL/SQL RAISE_APPLICATION_ERROR
Propagación de excepciones en PL/SQL
PL/SQL dinámico

Sentencias DML con SQL dinámico EXECUTE IMMEDIATE y SQL%ROWCOUNT

Cursores con SQL dinámico

Mas informacion en http://www.clubdeprogramadores.com/cursos/CursoMuestra.php?Id=625

11 comentarios:

Anónimo dijo...

[url=http://www.realcazinoz.com]casino[/url], also known as covenanted casinos or Internet casinos, are online versions of stately ("buddy and mortar") casinos. Online casinos encouragement gamblers to palm mad as a march hare quest of lines in and wager on casino games mind the Internet.
Online casinos habitually solicit odds and payback percentages that are comparable to land-based casinos. Some online casinos contend higher payback percentages in the use of travail shindy games, and some modify known payout note audits on their websites. Assuming that the online casino is using an aptly programmed unsystematic scads generator, frame games like blackjack clothed an established congress edge. The payout holding voyage of ascertaining of these games are established guardianship the aegis the rules of the game.
Uncountable online casinos sublease or be revealed their software from companies like Microgaming, Realtime Gaming, Playtech, Wide-ranging Knack Technology and CryptoLogic Inc.

Anónimo dijo...

geotorelxzp consolidation loans
debt consolidation

Anónimo dijo...

You Can Compare Your Nike Running Shoes ProgressTerrasoless shoes and footwear are the result of hybrid thinking and redefine the definition for comfort that can be experienced on wearing after a long day's work. Latest technology has been used to create this ultra lightweight footwear that is completely friendly to one's foot. Made from environment friendly components, Terrasoless shoes and footwear use recycled material even for packaging and part of sales are donated for the green cause. Terrasoles shoes are an eco-friendly brand that cares for the environment and are made with recycled materials employing environmentally friendly technologies. This brand of shoe is comfortable yet stylish and is available in various shapes and designs like sandals and flip-flops, clogs, mules and loafers. Terrasoless slippers can be comfortably used for both indoors as well as outdoors as these have a removable insole for easy washing.[url=http://www.cheaptomsbuy.com]Cheap Toms sale[/url] Retailing at $70 from select online stores such as Onlineshoes dot com, Sperry Top-Sider Largo are built with a denser sole which offers a good support to the foot's arch, wearing a pair of these conjures up the tropical ease of Florida Keys. The shoes top tongue has been widened with elastic stitch spread, something that allows for greater flexibility when walking and slipping them on. The sole is rubber adorned with classic roping around the shoe.Full grain side leather which is used to make the uppers for shoes is one of the most versatile of all leathers as well as being the most common. This type of leather is very durable and malleable while possessing the other desired characteristics of leather such as breathability. [url=http://www.onlinetomsoutlet.com]Toms Shoes[/url] Not a lot of companies have such a good initiative for social responsibility. In fact, some other shoe companies actually exploit child labor in order to save money and increase their profits. Toms turns that upside down by helping disadvantaged children rather than abusing them for low cost outsourcing. They understand that shoes are necessary for the sake of progress. After all, these children can fall ill from wounding their feet thus leading to infection. This also helps them in terms of getting an education since shoes are often required in school dress codes. If they dont have shoes, theyre denied the opportunity to study. When you buy Toms, youre making sure that child gets the knowledge they need to have a brighter tomorrow. Scarlett Johansson [url=http://www.tomsfans.com]Cheap Toms Sale[/url] There is huge collection with TOMS of stylish, trendy and lovable shoes varieties which catches the attention of all.The extraordinary collection includes TOMS glitter shoes, TOMS vegan style, TOMS kids wear wedding style and so on.For each pair of shoes which TOMS sells, it donates a pair of shoes to a bare footed child who is in need of it.The basic strategy which they follow is ONE to ONE, which means a pair of shoes for a child for a pair of shoes bought from them. It utilizes the capability to wealthy people who can buy shoes very easily for their aim to help poor children wear shoes. The unique quality of Toms is its blend of design and comfort. The shoes are beautiful, stylish and can be worn anywhere and for any purpose without the slightest worry for their well being. The rubber sole and the canvas materials (for most of them) ensure that the shoes are rough and ready all the time.
Relate Post
http://wiki.celtx.com/index.php?title=Talk:Hungarian_Result:_page_too_large%2C_not_fully_downloaded%3B_no_post_sending_forms_are_found%3B
http://moviebest.org/user/endarilence/

Anónimo dijo...

match dating geeman german http://loveepicentre.com/testimonials/ jeffrey dille online dating
top ten new dating sites [url=http://loveepicentre.com]my fox dating placce[/url] lauren graham dating
dating on craigslist [url=http://loveepicentre.com/testimonials/]kristen stewart and robert pattison dating[/url] free nyc speed dating [url=http://loveepicentre.com/user/strawberry9706/]strawberry9706[/url] dating outdoor activities singles south florida

Anónimo dijo...

dating transgenders in prison http://loveepicentre.com/testimonials/ tbi dating sites
the dating guy [url=http://loveepicentre.com/]100 free singles dating website[/url] dating bbw
teenage suicide in teen dating [url=http://loveepicentre.com/advice/]what does god say about dating[/url] manchester dating elske ai [url=http://loveepicentre.com/user/bantumi/]bantumi[/url] married woman dating questions

Unknown dijo...

Muy buen contenido para aprender a programar, aunque parece que es muy difícil estudiar o aprender acerca de programación es muy facil cuando se tiene amor, ahora estoy viendo un tutorial acerca de como aprender python no es uno de los mejores programas pero me gusta.

LordPakus dijo...

Pregunta rápida: El blog está en venda? De ser así, me darias algúna forma de contacto?

Buen Blog.

Francisco

mahaveer dijo...

Curso de C++ Profesional en Mèxico DF CDMX Aprenderás que C++ es un lenguaje de programación orientado a objetos P.O.O. multiplataforma que permite crear desde aplicaciones sencillas y simples hasta Sistemas de Información robustos y completos.

Anónimo dijo...

diseño web en monterrey

Juan Reyes dijo...

Me interesa mucho la información, los temas parecen bastante completos para cubrir lo básico en PL/SQL, gracias.

PBX en la nube dijo...

Muy buena informacion.