Examples of software provided by Oracle Corporation are: PL/SQL supports a variety of data types for storing numbers, rows and dates, computational flow control operators (including conditional transitions and loops) and three container (collection) types – variable length arrays, associative arrays and nested tables.Ī number of tools can be used for database administration and application development for Oracle DBMS. PL/SQL supports program blocks (in the form of functions, procedures and packages that are stored in the database in compiled form and can be executed later, or anonymous blocks that cannot be compiled and are used only with the form of scripts). The third key language used in Oracle DBMS on par with SQL and PL/SQL is Java. The SQL procedural extension developed by Oracle is called PL/SQL (Procedural Language/Structured Query Language) and is based on the syntax of the Ada and Pascal languages. Oracle supports a number of different platforms including Windows, Linux, Max OS X and Sun Solaris. Oracle is the most popular of SQL implementations it was historically the first commercial SQL implementation and the first implementation to be compatible with the SQL’93 standard. Oracle SQL – Oracle DBMS is a relational database management system developed by Oracle Corporation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |