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...

SQL Question Of The Day: what is the difference between simple and searched case statements? When to use which one explain with an example?

SQL Coding Question Of The Day: When I use minus operator without any where condition will the queries go for full tablescan or it will go to the index scan if they columns selected in the query has a index....

SQL Question Of The Day: If there is no else clause placed in the case statement what value will it display when the conditions are not satisfied?

PL/SQL coding question of the Day: I need to generate a sequence like
AA0001
AA0002
AA0003
AA9999
AB0001
AB0002
AB0003
AB0004
.
.
.
AZ9999
BA0000
BA0001
BA0002
.
.
.
ZZ9999

once reach ZZ9999 need to start with AA0001 again