what is the use of system.effective.date variable in oracle?

Question Posted / pankaj kumar

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle General Interview Questions

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

What are the different approaches used by Optimizer in choosing an execution plan ?

Explain oracle 12c new features for developers?

How to drop an existing view in oracle?

What is the relation of a user account and a schema?

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

What is analyze command used for?

Explain enable novalidate constraint.

Name the various constraints used in oracle?

What is a materialised view?

How to initialize variables with default values?

For more Oracle General Interview Questions Click Here