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: What is the default error limit in sql loader? Is it same for both conventional and direct path loads?
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
AA0001
AA0002
AA0003
AA9999
AB0001
AB0002
AB0003
AB0004
.
.
.
AZ9999
BA0000
BA0001
BA0002
.
.
.
ZZ9999
once reach ZZ9999 need to start with AA0001 again
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
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
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