Question : Why rowid is the fastest way to access the data from the table?
SQL Question Of The Day: What is the difference between trunc and round? Explain with a use case.
SQL Coding Question Of The Day:
Select trunc(11.456,2) as result1 , round(11.456.2) as result2 from dual
Select trunc(11.456,2) as result1 , round(11.456.2) as result2 from dual
Anonymous Quiz
14%
11.46 & 11.46
16%
11.45 & 11.45
47%
11.45 & 11.46
11%
11.46 & 11.45
13%
None of the above
PL/SQL Coding question of the Day: Write a function to find out whether the given number is a prime number or not? If prime number return as Y else N
SQL Question Of The Day : what is a savepoint and explain the same with a use case?
PL/SQL Question of the Day: Which keyword we need to use to propogate the exception to the outer block or calling block?
SQL Question Of The Day : What is the difference between replace and translate and explain with a use case?
PL/SQL Question Of The Day : can I write commit inside a trigger? If yes in which scenario and if no why ?
SQL Question Of The Day: What is the difference between decode and case statement explain with an use case?
PL/SQL Question Of The Day : while creating a function if we don't write return statement what will happen will it compile or not ?
SQL Question Of The Day: what is a scalar sub query and when we can use this explain with a scenario?
PL/SQL Coding question of the day : For the given input date return the number of days from 01st Jan of that year to the given input date. For this write a function which accepts one input parameter namely input_date and return the number of days.
SQL Question of The Day : How to write a full outer join query using oracle standards?