I am now using an Access program that was created years ago and I used it 5 yrs ago and am now back - and when I attempt to go from 1 record to another with the arrows at the bottom - it use to scan very quickly and now I have to click on the arrow each time to make it go from one record to another. Is there an easy way to make that move quickly without having to click on the arrow each time?

I have some datafiles were there on a secondary disk and that disk has become damaged and new disk at this time not available. How will I recover from this situation?

thanks in advance.
Ibrahim

What is the actual processing being done at backend or server side to retrive the data or complete the DML operation.

KSPradeep Rayavarapu

• Jan 28th, 2013

The order of Query Execution is following
1)From Clause
2)Where Clause
3)Group By Clause
4)Having Clause
5)Select
6)Order By Clause

Sachin Garg

• May 22nd, 2012

Hi Friends, When we pass a SELECT query it executes under some phases. That includes 1) Checking by Server Process - Which type of Query is this - Sql or Pl/sql. 2) If sql - server process puts the ...

Answer Question  Select Best Answer

What does Error 0600 mean?

ashokgaddipatidba

• Oct 15th, 2012

These are the internal errors. we have to contact Oracle Support

Answer Question  Select Best Answer

janardhan akki

• Sep 26th, 2012

In Case of normal views when ever u call the view it will get data from base table......

in case of pipeline view: if u call the view it vil get data from another view .....means it also logically getting data from base tables only.......the inner view may be materialized view....

Answer Question  Select Best Answer

RAM

• Aug 8th, 2012

TOAD,PUTTY WITH LIINUX/UNIX ,ORACLE FORMS,ORACLE REPORTS.

srikanth

• Jul 22nd, 2012

Toad, Putty,Bmc remedy

Answer Question  Select Best Answer

DURGAPRASAD

• Jul 24th, 2012

Code
SELECT TO_CHAR(ADD_MONTHS (SYSDATE,-LEVEL ),DD-MON-YYYY)  AS DATES    FROM DUAL   
CONNECT BY LEVEL 
<25 ORDER BY LEVEL DESC

Diptiman Badajena

• Mar 29th, 2012

Try this one:

Code
SELECT ADD_MONTHS (TRUNC(SYSDATE), (-1*(LEVEL-1))) date_calculated
  FROM dual
CONNECT BY LEVEL < 25
ORDER BY date_calculated;

Answer Question  Select Best Answer

You have a batch job which has hundreds of SQL queries in it. Earlier is was finishing in expected time. However, now it is taking twice the time. There is no CPU utilization issue due to other jobs. How would you know that which of the queries are taking more time now and why?

Nagaraj Teli

• Jul 22nd, 2012

Please find the below methods for finding one of the query which is taking longer time in the batch script. Methods :- 1) Put the dbms_output after each of the SQL query. 2) Create a logfile using th...

koushikinath

 Profile Answers by koushikinath Questions by koushikinath

• May 24th, 2012

1. At first enable the trace, at the beginning of the sqls.
2. Then check the trace file.
3. Using tkprof create the output file.
4. According to explain plan check the elapsed time for each query.
5. Then tune them

Answer Question  Select Best Answer

Snehal

• Jul 10th, 2012

View : View exists logically.Its a virtual table.Whenever we are firing a query on a view we are getting a data from a table. But for a snapshot it is not a case... snapshot itself store a data.. refr...

ravinder lathwal

• May 15th, 2012

Snapshot is just like print screen. or materialized view is actual table.
snapshot is read only.you will find it same stage every time.
but materialized view is update mode.always you will find it a new stage.

Answer Question  Select Best Answer

santosh

• May 21st, 2012

UNDO tablespace contain the old information. it is circular process. it will overwrite the first extents. so if you need the overwritten statement that time it will show as snap_shot is to old.

oradebug

 Profile Answers by oradebug Questions by oradebug

• Jul 25th, 2009

First you have to understand that Oracle is a MVCC (multiversion concurrency control) or "repeatable read" database system.? Queries are returned with all rown consistent with respect to the point in...

Answer Question  Select Best Answer

You have a very large query say of 2000 lines. How would you check if the indexes are being used or not. Would you read all the lines of explain plan in plan table to get it? If yes, will it be feasible? Do you have any other method of checking this?

raghuvir Khanna

• May 10th, 2012

We can moniter the use of indexed with the help of view V$object_usage simple we need to use
Alter index monitoring usage;
select tablename,indexname ,used from V$object_usage ;

Sam

• May 7th, 2012

Check and resolve join with the largest cost

Answer Question  Select Best Answer

If in PL/SQL Autonomous transaction, you get error then how will you role back the main transaction?

Mohammad Jarwan

• Apr 9th, 2012

Used in table trigger to execute update statement for same table.

dhiren21

 Profile Answers by dhiren21 Questions by dhiren21

• Sep 20th, 2009

Before this Ask a Question to your Self... What are you Updating?When You Updated this?How you are updating?Then? Check the Commit?Point if commited not possible to rollback normally.Steps :::? Restor...

Answer Question  Select Best Answer

How to create LOV dynamically at runtime & attach to text field?

SHAHNAWAZ MUZAFFAR

• Mar 10th, 2012

We can use Dynamic LOV through assigning into a global variable and using this global variable into our sql statement.

Answer Question  Select Best Answer

How to find the startup time of instance?

kishore

• Nov 15th, 2011

How to get instance startup time


>select to_char(startup_time,'dd-mon-yyyy HH12:MI:SS ')"db startup time"
2 from sys.v$instance;

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 22nd, 2010

Use this simple command in SQLPlus or an a query retreival tool of your choice. select To_char(startup_time, 'Mon-dd-yyyy hh24:mi AM') as STARTUP_TIME from v$instance;

Answer Question  Select Best Answer

How will you find the total number of databases present in our system via LINUX OS?

Richard Naveen

• Oct 31st, 2011

Etc/oratab

subrahmanyam pattapu

• Jul 20th, 2011

We can find which databases are running in server. by using the following command.

ps-ef|grep smon

It will show the databases is up and running.

Answer Question  Select Best Answer

Explain what are Oracle Catlog & Oracle Archive Log ?

jazz

• Sep 20th, 2011

When the log writer writes into the redo logs i.e online redo logs in circular motion.when one redo log is full it switches to another redo log , at this point of transfer it is called log switch.

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

oracle catalog used for recovery purpose in RMAN our target database registered in catalog and storing metadata for the target database. Archivelog is also used for recovery purpose but its store red...

Answer Question  Select Best Answer

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

We can not delete responsibillity but we can disable the responsibility from user so that user can not use this resp he is not authorised to use particular responsibility.

psicre

 Profile Answers by psicre Questions by psicre

• Jul 22nd, 2010

You cannot delete reps in EBS....

Answer Question  Select Best Answer

What is meant by Remote Backup?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

Suppose as a client u connected to server with the help of some third party tool and you are going to take backup from your server then that is called remote backup.

Answer Question  Select Best Answer

Explain in detail what are bdump, cdump & udump?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

background dump (bdump) :--. > bdump is used for all the issues raised related to background process in our database. its also contain alert .log which contain all activities and issues related to da...

Answer Question  Select Best Answer

What is the use of catalog and no catalog in RMAN?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

Rman with catalog means our target database registered in catalog and its used for recovery purpose. its containing metadata about to database.

rman with no catalog means metadata stored in controlefile through the controlfile we can do the recovery.

Answer Question  Select Best Answer