Oracle FAQs

Clustered table store data of multiple table based on common columns.

View is virtual table or which has attached select query.Its not actual table.

A cluster is a group of tables which share the same data blocks. Clusters are an optional method of storing table data. Cluster share common columns and are often used together. It is a powerful met...

The Oracle version starting of I. The starting in 1999 with version 6i, 8i and 9i, I signify "Internet" means stands for "Internet" and Oracle added the "I" to the version name to reflect support for ...

Oracle 9i and Oracle 10g....there are more implementation differences. In terms of architecture, 9i is based on Internet technology while 10g is grid computing based one. Many DBA features like Automa...

Collecting the access

eg: insert,select,update

in this group the user can apply only the above operation on the tables.

Are you looking for something like this?"plsql function revstring(instring varchar2) return varchar2 is rstring varchar2(750) := ; iCnt pls_integer; begin for icnt in reve...

See, in oracle to maintain read consistency oracle keeps a copy in undo section of database for the data which is under modification by some transaction. And so readers do not wait for writers and ca...

In before update/delete trigger if we use select statement for fetching the records.in this scenario will wet mutating trigger error.using row level trigger we can avoid instead of statement level trigger. we can accurate results.

There is one Oracle function ROLLUP, the same can be used for required output

QUERY:
SELECT GENDER,COUNT(GENDER)
FROM TABLE_NAME GROUP BY ROLLUP(GENDER);

SELECT COUNT(decode(sex1,'F',1)) "female count", 

There is a data dictionary called as ALL_MVIEWS.
You can check the query and the length of the query in this data dictionary as

Select * from ALL_MVIEWS where MVIEW_NAME = MVIEWNAME

You can join the columns with two different data types by using to_char, to_number to_date functions.
For e.g. one field is a varchar which stores number and other field is a number then you can use.
to_number(var_column) = number_column

Constraint are easy to reference if you give them a meaningful name. It is not necessary to assign name to constraint. If you do not assign any name to constraint Oracle will assign a name to constrai...

Hi, Mainly use constraints for a businessmen rule that restrict enter the record in a table. IN oracle there are 5 type of constraints --- 1) Primary key, 2) foreign key 3) Unique key 4) Not NUll...

The SCN is an important quantifier that oracle uses to keep track of its state at any given point in time. The SCN is used to keep track of all changes within the database, its a logical timestamp tha...

Hi, In oracle use SYNONYM as a temporary name of the object ( Table, view, index etc.)

Code
 
  CREATE SYNONYM synonym_name FOR table_name
 
You CREATE PUBLIC SYNONYM WITH the PUBLIC keywrd
 
 
CREATE PUBLIC SYNONYM synonym_name FOR table_name

Synonum is a alias of the table..

There are eight report triggers. Of these there are five global triggers called the Report Triggers. They are fired in the following order : * Before Parameter Form * After Parameter Form * Before R...

Total 5 Types of Trigger1. Before Parameter Trigger2. After parameter Trigger3. Before Report Trigger4. Between Pages Trigger5. After Report Triggerthe Action are given below1. Before Parameter T...

how to find the instance name?


>select instance_name from v$instance;

Instance Name Is DATABASE NAME Default

Compound Triggers: -> It combines all DML timing events into single trigger body. -> It also resolves mutating table error and enhance the code maintenance. -> The memory variables are persistent t...

"c# SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dBConnection"].ToString()); con.Open(); DataSet ds = new DataSet(); SqlC...

Char: char is fixed length data type
VarChar:Varchar are variable in length In that varchar take the additional Memory bytes depending on the Declare the size of the variable.

it is a Pfile

Hi Friend,

Here is simple defination
initSID.ora will tell you SID is the database name where you are going to creating a new database.

when you create database it'll take you as pfile and spfile is the system parameter file which you can convert if you required use in database.

The SCN plays an important role to determine if the database is in a consistent state when the database is brought online. SMON checks the SCN in all datafile headers when the database is started. Eve...

Does it return only integer?

Never seen in oracle