-
How to recover a table which is already been droped?
kishore.giri
- Dec 10th, 2007
If the database is running in archivelog mode then perform time-based recovery to recover the table.
-
Oracle 10g new features
Can anyone please tell me what are the advanced features in 10g when compared to 9i
kumar1974
- Jan 23rd, 2008
Oracle 10g features are 1) Sys Aux Tablespace 2) ASM3) New Flash Recovery Area 4) CTWR (Change Tracking Writer) This is background process which writes the block change information to the change tracking file. 5) Server Manageability Components6) Unified Job Schedular etc
-
Oracle Database Connectivity with C++
How can we connect Oracle database with our C++ program. Explain with an example.
sarthak2175
- Mar 8th, 2008
Hi i fil u can use pro c to connect the data base to the front end data condition: database should b oracle ...
-
-
Determining static/dynamic parameters
How to determine whether particular parameter of parameter file is static or dynamic?
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...
-
Cache in Oracle Sequence
What is No Cache in Sequence?
venkat82.k
- Apr 11th, 2008
Hi friendsCache is memory allocated to generate numbers in sequencemaximum size of cache is 20okkkkkkkkkk
-
Recover data from database block corruption error
How to solve the database block corruption error? even index also validated and recreated and don't have any backup.
-
Oracle Explain
In Oracle what is meant by 'Explain'
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...
-
Multiple Row Values
How to retrieve multiple row values in a single column
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...
-
Store Image in Oracle
How to store Image in Oracle table
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); ...
-
Trigger Body
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
- 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 ...
-
SCN and Log Sequence Number
What are the differences and similarities (if any) between SCN and and Log Sequence Number?
-
Oracle Exception
How many exception in Oracle?
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.)
-
Refresh Materialized View
What is the purpose of Mviews? Outline the difference between refresh types? How to refresh the MView?
-
Rebuild Index
What is rebuild index, why do we need to rebuild the index?
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;
-
Sub Queries Alias Name
SELECT * FROM (SELECT ROWNUM,ENAME,JOB,SAL FROM EMP WHERE ROWNUM
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
-
View SMON
How to view whether SMON is running or not using batch script??
-
Stored Procedure Debugging
How to debug stored procedure in Oracle?
budzboy
- Jul 14th, 2010
You may use dbms_output.put_line([string]) between lines you think causes the error.
-
Disable Print Option
How to disable print option from the report preview?
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!
-
Databases Interoperability
How two databases can be interoperabled?
Oracle Basics Interview Questions
Ans