If you have any questions/ any one is looking for job support or proxy or training pls reach out to me @vnpraneeth.oracle@gmail.com

PL/SQL Question Of The Day: What is the difference between strong & weak ref cursor?

SQL Question Of The Day: What is the difference between NVL , NVL2 & NULLIF ?

SQL Coding Question Of The Day: Write a query to display the number of days, months, years, hours, minutes and seconds from your birth date to till date?

PL/SQL Question Of The Day: In a single table how many triggers I can create?

SQL Question Of The Day: What is the difference between coalesce and nvl ?

SQL Coding Question Of The Day:

SQL Question Of The Day: what is the output of below query?
Select substr('ASIA',5,2) from dual;

SQL Question Of The Day: what is the result of below query
Select instr('ASIA','B') from dual

SQL Coding Question Of The Day:

Hi All, really sorry for not sending the questions, busy with other stuff, from 2morow will share the questions.

PL/SQL question of the day

SQL Question Of The Day: How to convert an existing unique key constraint to Primary key without dropping the existing unique constraint?

SQL Coding Question Of The Day:

May be thinking like we can just club the columns but it won't work like that... Try 😊

PL/SQL Question Of The Day: what is the range of error codes we can use for raise_application_error?

SQL Question Of The Day:

SQL Coding question Of The Day:

SQL Question Of The Day: What is the default error limit in sql loader? Is it same for both conventional and direct path loads?

PL/SQL Coding Question Of The Day

SQL Question Of The Day: What will happen to the existing indexes on the table when we are running sql loader in conventional and direct path loads?