SQL Coding Question Of The Day:

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

SQL / PL/SQL Question Of the Day:
I need to update the country_code , bank_name in the given table.
Criteria : It should be done at the account number level.
If both are null then take the most recent data for the account number and update it

Input Data

Expected Output

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

SQL & PL/SQL question of the Day: Write a query and function to display first character of a given string in a lower case and remaining characters in the word should be in upper case. For example: my string is " welcome to oracle family".
Expected output : wELCOME tO oRACLE fAMILY

SQL / PLSQL question Of The Day : What is the difference between constraints and triggers and in which scenario will use constraints and triggers explain with an example?

PL/SQL Question Of The Day: Instead of using the primary key on the employee table, I would like to implement the same primary key using a trigger. Write a trigger which satisfies all the concepts of primary key.

SQL Question Of The Day: I have a table employees and it contains columns employee_id and salary with duplicate data, without deleting the duplicates I want to implement the primary key on employee_id column. How to achieve the same?

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

SQL coding Question Of The Day: Write a sequence which generates negative sequence numbers like
-1
-2
-3
......etc

SQL Question Of the Day: I have a sequence created with below command:
Create sequence seq_test start with 10 increment by 5 maxvalue 50 cycle cache 5;
Now once it reaches 50, if I do seq_test.nextval what will be the result?

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

SQL Question Of The Day: I want to display the employee_ids who are not managers, I have written this query,but not getting the output, tell the reason why we are not getting the data SQL QUERY: select employee_id from INPUT where employee_id not in (select manager_id from employees);

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

SQL Question Of the Day: Convert row level data into comma separated string, when appending follow the employee_id asc

SQL Question Of the Day: When we create a view before creating the base table using "FORCE", will the view created ? if created what will be the column names and their data types?

SQL & PL/SQL Question Of the Day: Write a query to count how many special characters are there in the given string
using only SQL & also in PL/SQL
Example : Input String = 'ab$34%e#lfgrht)75(34gh'
Expected Output = 5

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

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