what is the use of system.effective.date variable in oracle?
What is Java Pool in Oracle?
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 ?
What is ASM (Automatic Storage Management) in Oracle?
what is data independence exactly? give an example
What happens if variable names collide with table/column names?
How to initialize variables with default values?
Without giving condition how to retrieve the unmatched records from table.
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
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
What is a proxy class?
What is a view and how is it different from a table?
What do you understand by database schema and what does it hold?