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


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

Post New Answer

More Oracle General Interview Questions

What is Java Pool in Oracle?

0 Answers   MCN Solutions,


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

0 Answers   Oracle,


What is ASM (Automatic Storage Management) in Oracle?

0 Answers   MCN Solutions,


what is data independence exactly? give an example

6 Answers  


What happens if variable names collide with table/column names?

0 Answers  


How to initialize variables with default values?

0 Answers  


Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,


State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

0 Answers   Atos Origin,


hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,


What is a proxy class?

0 Answers  


What is a view and how is it different from a table?

0 Answers  


What do you understand by database schema and what does it hold?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)