What is the query to get meta and meta-meta data?

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

Every query is sort of query for metadata.select * from emp;Metadata for employee isn't it.

Answer Question  Select Best Answer

How to insert a picture or sound clipping in Oracle Database?

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Mar 30th, 2009

Use blob datatype to insert image/picture into Oracle database.

Answer Question  Select Best Answer

How to Install Oracle 9i in Vista?

gtrice

 Profile Answers by gtrice Questions by gtrice

• Sep 22nd, 2009

You don't. Window XP Pro is required. Try Linux.

Answer Question  Select Best Answer

Why is sys_context used for providing privileges in Oracle?

reyazan

 Profile Answers by reyazan Questions by reyazan

• Oct 16th, 2009

The sys_context function can be used to retrieve information about the Oracle environment.The syntax for the sys_context function is:sys_context( namespace, parameter, [ length ] )namespace is an Orac...

Answer Question  Select Best Answer

How to read columns from excel file (converted into *.CSV format) into Forms using upload button.

kishore.harname

 Profile Answers by kishore.harname Questions by kishore.harname

• Oct 31st, 2009

You can use UTL_file package which is provide by Oracle to read & write data into csv file or use external table funda.

Answer Question  Select Best Answer

What is the role of Referential Integrity Constraint in Normalization?

surendra

• Jan 31st, 2013

Best examples of Referential Integrity constants Primary Key And Foreign key. Primary Key constraint allow a particular attribute to be not null and unique. Where as Foreign key will be used when ever there is a need to maintain the same attribute values in the multiple tables.

Answer Question  Select Best Answer

When do we will go for Sequence and when go for Indexes. What is the difference between Sequence and Indexes.

varunprasath

 Profile Answers by varunprasath Questions by varunprasath

• Jun 7th, 2010

Sequence - A sequence is used to generate a number sequence that can be used as a primary key.Indexes - An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns.

Answer Question  Select Best Answer

Explain about the Chained / Migrated Rows

vidyajnath

 Profile Answers by vidyajnath Questions by vidyajnath

• Apr 23rd, 2010

In two circumstances, the data for a row in a table may be too large to fit into a single data block. In the first case, called chaining, the row is too large to fit into an empty data block. In this ...

Answer Question  Select Best Answer

Outline the names and function of Oracle background processes

vidyajnath

 Profile Answers by vidyajnath Questions by vidyajnath

• Apr 23rd, 2010

The Oracle architecture has five mandatory background processes Mandatory background processes: DBWR (Database Writer) PMON (Process Monitor) CKPT (Check Point) LGWR (Log Writer) SMON (System Monitor)...

Answer Question  Select Best Answer

How can you prevent tablespace fragmentation? (rebuilding, moving)?

vidyajnath

 Profile Answers by vidyajnath Questions by vidyajnath

• Apr 23rd, 2010

As rows are added to tables, the table expands into unused space within the space. Conversely, when rows are deleted, a table may coalesce extents, releasing unused space back into the tablespace. As ...

Answer Question  Select Best Answer

How to see materialized view occupied memory space?

PK

• Feb 29th, 2012

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

Answer Question  Select Best Answer

What is log switch?

asit

• Jun 9th, 2012

log switch ::suppose we have two redo log files LOG A, LOG B. when transaction(DML) are occurred in Database then they are recorded in LOG A. When LOG A is filled up, a log switch occurs, All new tran...

Answer Question  Select Best Answer

How to show the cursor is busy when any process is going on in Oracle Forms 6i?

budzboy

 Profile Answers by budzboy Questions by budzboy

• Jul 14th, 2010

Set_application_property(cursor_style, busy);

Answer Question  Select Best Answer

Which one will give best performance between GROUP BY function in Oracle and GROUP BY function in Crystal Reports? Explain

Shyam

• Oct 22nd, 2015

The Group BY in Oracle will give best performance, because Group By is not a function for Oracle.

Answer Question  Select Best Answer

How to join two columns which is having different datatype? Say Coulmn1 with Varchar2 datatype and Coulmn2 with long datatype.

PK

• Feb 28th, 2012

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

Answer Question  Select Best Answer

What do you mean by ROW_NUMBER(), RANK(), DENSE_RANK() differentiate them?

asit

• Jun 9th, 2012

THE BELOW FUNCTIONS ARE OLAP FUNCTIONS...

rank() function skips the continuity but dense_rank() function gives the sequence.It is always advised to use dense_rank for viewing nth highest/lowest value. row_num() gives the serial no in the order how they are inserted in to a table.

Answer Question  Select Best Answer

Which system tables contain information on privileges granted & privileges obtained?

asit

• Jun 9th, 2012

For users permissions : user_tab_privs table is used.
for viewing all permissions : all_tab_privs

Answer Question  Select Best Answer

What do you mean by Force View?

asit

• Jun 9th, 2012

Force view is the process to create a view forcefully without a base table. syntax:

Code
 

Answer Question  Select Best Answer

Explain the concept of compond triggers

neeraj06.in

 Profile Answers by neeraj06.in Questions by neeraj06.in

• Nov 10th, 2011

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...

Answer Question  Select Best Answer

How to convert Oracle Report into text or doc file?

bondneoo

 Profile Answers by bondneoo Questions by bondneoo

• Aug 18th, 2010

Goto Tools->Preferencesthen Runtime Values->Set mode to character.

Answer Question  Select Best Answer