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?

SQL Question Of The Day: I want to load the data into 2 tables using the sql loader. I have one data file which contains informatio/columns for 2 tables. Using sql loader can we do this? if yes how to write the control file? Do we use 2 control files?.....

SQL Question of The Day: What is the difference between Case and Decode function ? When to use which one? Explain with an example...