Oracle sql plsql questions

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

SQL Coding Question Of The Day:

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

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

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?

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

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

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

Hi All thank you for joining and making the subscribers count 150+🙏🙏🙏

SQL Coding Question Of The Day:

SQL Question Of The Day: Can I create synonym for an index?

PL/SQL Question Of The Day: What is the value of %isopen in implicit cursor?

SQL Coding Question Of The Day:

SQL Question Of The Day: Can I insert the data into a table using view?

PL/SQL Question Of The Day: Can I use both named and positional parameters together when calling a procedure or function?

SQL Coding Question Of The Day:

SQL Question Of The Day: Can I create both Btree and Bitmap Index on the same column ?

PL/SQL Question Of The Day: What is the difference between local and global variable and explain with an use case?

SQL Coding Question Of The Day:

SQL Question Of The Day: