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

6 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...

The articleice Machines introduces:This article about How To Buy Commercial Ice Machines For Restaurant,With the introduction of cutting edge and innovative technologies, a commercial ice machine is no longer a bulky device producing insanitation, consuming a lot ...

If you need more ice Machines infomation about How To Buy Commercial Ice Machines For Restaurant, Click here to find.

With the introduction of cutting ice Machines edge and innovative technologies, a commercial ice machine is no longer a bulky device producing insanitation, consuming a lot of energy, making noise, and taking a lot of time to make the needed supply of ice. As a result of high end technologies, commercial ice machines are able to achieve “being green” the highest levels of energy and water conservation. Now a commercial ice machine can easily produce from 65 pounds to 2,000 pounds of ice cubes in a day. You can find varied shapes of ice cubes such as dice, half dice, octagon, crushed, nugget, and flake.

Commercial ice machines are the standalone units,ice Machines designed to produce large quantities of ice for various commercial purposes. Once installed, these commercial ice makers are pretty automatic and do not need much attention from you or your staff. These factory-made machines consist of a condensing unit and ice-making section that operates as an integrated unit to make ice, an ice bin or a storage unit to store the created ice and a dispensing unit to dispense the ice out of the machine. Many automatic ice machines use moving water to create an improved quality of ice cubes. They work on the principle of “faster the water moves the better the ice quality becomes”. In this process, the air and un-dissolved solids get washed away. This results in pure and clear ice production.

Large amounts of ice are demanded for various purposes in many ice Machines commercial entities such as Restaurants, Bars, Ice Cream Parlors, Bakeries, Country Clubs and Golf Courses. A commercial ice machine is the perfect choice for such places as the large quantity of ice also needs to be a certain quality as well. Automatic commercial ice machines will make plenty of ice of equal size in a short span of time. All you need to do is just start the machine and set the required functions, and leave the rest up to the machine. You will get good quantity of quality ice in a short amount of time. In addition, many commercial ice machines come with a self cleaning function. This will help maintain the quality and quantity if the produced ice while decreasing the time that you and or your staff must spend with the machine.

Keep in mind that there are two varieties of ice machines: air cooled and waterice Machines cooled. Air cooled ice machines use air to disperse the heat, whereas water cooled ice machine uses water to do the same function. Air cooled ice machines use more energy and also are much noisier than water cooled ice machines. However, they are more affordable than water cooled ice machines.

An assorted collection of wonderful, fast and energy efficient commercial ice makers are readilyice Machines available in the market. Various renowned and reliable manufacturers have come up with their unique range of these amazing machines. Numerous models that create different types and sizes of ice are available in the local and online market. A competitive urge of creating more efficient and cost effective ice machines, has left the customers and consumers with a distinctive variety of these units in which to choose.

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

Videos de Programacion

Loading...