Oracle DBA Tutorial

Objects can be schema objects like Clusters * Constraints * Database links * Database triggers * Dimensions * External procedure libraries * Index-organized tables * Indexes * Indextypes * Java classes, Java resources, Java sources * Materialized views or Non schema objects..Read more at http...

Schema Object Naming Rules The following rules apply when naming schema objects: Names must be from 1 to 30 bytes long with these exceptions: Names of databases are limited to 8 bytes. Names of database links can be as long as 128 bytes. Names cannot contain quotation marks. Names are not case sen...

A query is an operation that retrieves data from one or more tables or views. In this reference, a top-level SELECT statement is called a query, and a query nested within another SQL statement is called a subquery. This section describes some types of queries and subqueries and how to use them.. Read c...

	Forum	Replies	Views	Last Post
database objects sql Tutorial What is a Database Object? (Preview)	SQL Tutorial	0	2610	Jul 30, 2009 by learnoracle
Objects can be schema objects like Clusters * Constraints * Database links * Database triggers * Dimensions * External procedure libraries * Index-organized tables * Indexes * Indextypes * Java classes, Java resources, Java sources * Materialized views or Non schema objects..Read more at http...
SQL Tutorial What is a Schema Object and its rules? (Preview)	SQL Tutorial	0	2728	Aug 5, 2009 by Anonymous
Schema Object Naming Rules The following rules apply when naming schema objects: Names must be from 1 to 30 bytes long with these exceptions: Names of databases are limited to 8 bytes. Names of database links can be as long as 128 bytes. Names cannot contain quotation marks. Names are not case sen...
sql sql tutorial What is a SQL Queries and Subqueries? (Preview)	SQL Tutorial	0	2937	Aug 18, 2009 by learnoracle
A query is an operation that retrieves data from one or more tables or views. In this reference, a top-level SELECT statement is called a query, and a query nested within another SQL statement is called a subquery. This section describes some types of queries and subqueries and how to use them.. Read c...