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

SQL Question Of the Day: Can I create both unique and non-unique btree indexes on same column ?

SQL Question Of the Day: Write a query to print the dates starting from 01-Jan-2022 to 31-Dec-2022

Requirement : Year column need to be matched with the Transaction_date columns year component , if it is matched then pull the records.