Where do we use decode and case statements?
No Answer is Posted For this Question
Be the First to Post Answer
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to create a server parameter file?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
What is partitioned table in Oracle?
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
Can we create trigger on materialized view in oracle?
what is index?
Explain the use of record length option in exp command.
Does rowid change in oracle?
How to open and close an explicit cursor in oracle?
What is save point in oracle database?