Oracle Tutorials
Understanding SQL Basics
A tutorial that tells about SQL basics
SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation.....
Understanding SQL SELECT Query Statements
A tutorial that explains SQL SELECT query statements
A collection of 33 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views, sorting and counting query outputs, grouping outputs and applying group functions, joining tables, using subqueries...
Understanding SQL Transaction Management
A tutorial that explains SQL Transaction statements
A transaction is a logical unit of work requested by a user to be applied to the database objects. Oracle server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statements in a transaction can be either all committed (applied to the database) or all rolled back (undone from the database)........
Managing Oracle User Accounts, Schema and Privileges
A tutorial that shows how to manage Oracle User Accounts, Schema and Privileges
A user account is identified by a user name and defines the user's attributes, including the following: Password for database authentication. Privileges and roles....
Understanding SQL DDL Statements
A tutorial that explains about SQL DDL Statements
DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements.......
Understanding SQL DML Statements
A tutorial that explains about SQL DML Statements
DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements.......
Managing Oracle Database Tables
A tutorial that shows how to manage Oracle Db Tables
A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns.....
Creating Your Own PL/SQL Procedures and Functions
A tutorial that shows how to create PL/SQL Procedures and Functions
A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required......
Managing Oracle Table Indexes
A tutorial that shows how to manage Oracle Table Indexes
Index is an optional structure associated with a table that allow SQL statements to execute more quickly against a table. Just as the index in this manual helps you locate information faster than if there were no index, an Oracle Database index provides a faster access path to table data.......
Managing Oracle Tablespaces and Data Files
A tutorial that show to manage Oracle Tablespaces and Data Files
An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes.......
|
|
|
Bookmark Oracle Tutorials
