Sql is structured query language, which is a computer language for storing, manipulating and retrieving data stored in relational database. Objetivos del curso oracle lenguaje pl sql avanzado. This chapter introduces the advanced pl sql features and refers to other chapters or documents for more information. Oracle database plsql language reference oracle database plsql language reference oracle database. You can also define subtypes of the scalar data types. The pl sql data types include the sql data types, additional scalar data types, and composite data types. Sql is an ansi american national standards institute standard, but there are many different versions of the sql language. Plsql saves time on design and debugging by strong features, such as exception handling, encapsulation, data hiding, and objectoriented data types. Your contribution will go a long way in helping us serve. This manual includes syntax, usage notes, keywords, and examples for each of the sql statements used on the system. Plsql gives high productivity to programmers as it can query, transform, and update data in a database. Desarrolla complejas y performantes consultas en sql server. Microsoft sql server, microsoft access, mysql y oracle versiones 7, 8, 8i, 9i y 10g.
Relational software mas tarde paso a llamarse oracle. Oracle forms developer and oracle reports developer guidelines for building applications release 6i january, 2000 part no. It contains reference information for the tasks of system administration, database administration, application programming, and operation. Estos consejos le ayudaran a trabajar con archivos. This book defines structured query language sql as supported by db2 for ibm i.
52 1171 462 1461 1172 362 277 651 1140 1069 178 1203 1134 1026 151 1389 1352 1210 991 1262 772 608 664 1055 971 1382 1088 627 1369 1369 778 670 135 956 807 178 716 1399