Oracle sql plsql questions

SQL & PL/SQL Coding Question Of The Day:

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

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?

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: what is the difference between simple and searched case statements? When to use which one explain with an example?

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: 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 will happen to the existing indexes on the table when we are running sql loader in conventional and direct path loads?

PL/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?

SQL Coding question Of The Day:

SQL Question Of The Day:

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

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

SQL Coding 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?

PL/SQL question of the day

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

SQL Coding Question Of The Day:

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