How to determine whether particular parameter of parameter file is static or dynamic?

mps9029

 Profile Answers by mps9029 Questions by mps9029

• Jul 1st, 2009

In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column contains three phases 1) Immediate 2) DEFERRED 3) False 1. Immediate : We can change the parameter in fly database ie Dynami...

Answer Question  Select Best Answer

What is No Cache in Sequence?

venkat82.k

 Profile Answers by venkat82.k Questions by venkat82.k

• Apr 11th, 2008

Hi friendsCache is memory allocated to generate numbers in sequencemaximum size of cache is 20okkkkkkkkkk

Answer Question  Select Best Answer

How to solve the database block corruption error? even index also validated and recreated and don't have any backup.

adeshgupta123

 Profile Answers by adeshgupta123 Questions by adeshgupta123

• Nov 2nd, 2009

By using DBMS_REPAIR

Answer Question  Select Best Answer

In Oracle what is meant by 'Explain'

singh.neerajin

 Profile Answers by singh.neerajin Questions by singh.neerajin

• May 28th, 2008

This must be oracle explain plan.The EXPLAIN PLAN statement displays execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements. It also helps you to underst...

Answer Question  Select Best Answer

How to retrieve multiple row values in a single column

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Jul 4th, 2008

Dear friend, I didn't get exactly what you want,any please tell me the context so that i can help you out................coming to the question:you want the result of multiple rows in a singl...

Answer Question  Select Best Answer

How to store Image in Oracle table

singh.neerajin

 Profile Answers by singh.neerajin Questions by singh.neerajin

• May 28th, 2008

It is always better to store the images in the BLOB or CLOB datatype.......PROCEDURE apply_changes_to_illust(path varchar2)IS  f_lob BFILE;  b_lob BLOB;  image_name VARCHAR2(30);  ...

Answer Question  Select Best Answer

We have a trigger on database. In the trigger body we have created a body using dbms_output.put_line(********) ;How to fire this ?

ushaudayam

 Profile Answers by ushaudayam Questions by ushaudayam

• Aug 22nd, 2008

Trigger is a pl/sql block that is automatically invoked on an event, when any DML command is used on corresponding table.Triggers are classified into different categories based on when they are to be ...

Answer Question  Select Best Answer

What are the differences and similarities (if any) between SCN and and Log Sequence Number?

sagar verma

• Sep 7th, 2011

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

Answer Question  Select Best Answer

How many exception in Oracle?

ravula sudheer

 Profile Answers by ravula sudheer Questions by ravula sudheer

• Oct 18th, 2008

In Oracle there are two types?of exceptions.USER DEFINED EXCEPTIONS.DEFINED EXCEPTIONS..(NO_DATA_FOUND,VARIRABLE LENGHT TOO LONG .. etc.)

Answer Question  Select Best Answer

What is the purpose of Mviews? Outline the difference between refresh types? How to refresh the MView?

gyana

• Apr 24th, 2017

Dbms_mview.refresh(materialize view name)

Answer Question  Select Best Answer

What is rebuild index, why do we need to rebuild the index?

saikatrana

 Profile Answers by saikatrana Questions by saikatrana

• Feb 1st, 2009

If you want a table moved from its own tablespace to other, then you have to rebuild index.Command:Alter Index index_name rebuild online;

Answer Question  Select Best Answer

SELECT * FROM (SELECT ROWNUM,ENAME,JOB,SAL FROM EMP WHERE ROWNUM

sureshkumar.mtech

 Profile Answers by sureshkumar.mtech Questions by sureshkumar.mtech

• Oct 11th, 2008

Here compulsory to give the alias name for rownum because the column name is not exist in the table so it's show error for invalid columns specification.The query should be below;select * from (select rownum as num, last_name, salary, id from employeewhere rownum

Answer Question  Select Best Answer

How to view whether SMON is running or not using batch script??

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

Ps |grep smon

Answer Question  Select Best Answer

How to debug stored procedure in Oracle?

budzboy

 Profile Answers by budzboy Questions by budzboy

• Jul 14th, 2010

You may use dbms_output.put_line([string]) between lines you think causes the error.

Answer Question  Select Best Answer

How to disable print option from the report preview?

adeelkamboh

 Profile Answers by adeelkamboh Questions by adeelkamboh

• Jun 2nd, 2009

While calling the report, Add a parameter 'DISABLEPRINT' and set its value to 'NO'. Also note that you can also disable email button by doing the same with 'DISABLEMAIL' parameter.Hope that answers your question!

Answer Question  Select Best Answer

How two databases can be interoperabled?

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

What do you want to achieve through this. Be specific.

Answer Question  Select Best Answer

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