SQL Question Of The Day: Can I use case statement with in insert statement ?
Oracle sql plsql questions
@oraclesqlplsql
Oracle practice & Interview questions
Oracle sql plsql questions (English)
Are you looking to enhance your skills in Oracle SQL and PL/SQL? Look no further than our Telegram channel, 'Oracle sql plsql questions'! This channel, with the username '@oraclesqlplsql', is dedicated to providing practice questions and interview tips related to Oracle SQL and PL/SQL. Whether you are a beginner looking to learn the basics or an experienced professional wanting to sharpen your skills, this channel is perfect for you. With a wide range of questions covering topics such as queries, functions, procedures, and more, you can test your knowledge and improve your understanding of Oracle databases. We also regularly share interview questions to help you prepare for job interviews and land your dream job in the field of Oracle development. Join 'Oracle sql plsql questions' today and take your Oracle SQL and PL/SQL skills to the next level!
Oracle sql plsql questions
22 Jan, 11:55
If you have any questions/ any one is looking for job support or training pls reach out to me @[email protected]
Oracle sql plsql questions
22 Jan, 11:52
SQL Question Of The Day: Requirement :I would like to findout 21-jan-2022 belongs to which group and
prior to that group if there are any groups present, pull last 2 groups
and the date range.
In this example : 21-Jan-22 falls under G4, so we need to pull out date range of G2 and G3
prior to that group if there are any groups present, pull last 2 groups
and the date range.
In this example : 21-Jan-22 falls under G4, so we need to pull out date range of G2 and G3
Oracle sql plsql questions
21 Jan, 17:24
Requirement : Year column need to be matched with the Transaction_date columns year component , if it is matched then pull the records.
Oracle sql plsql questions
20 Jan, 03:55
SQL Question Of the Day: Write a query to print the dates starting from 01-Jan-2022 to 31-Dec-2022
Oracle sql plsql questions
19 Jan, 04:17
SQL Question Of the Day: Can I create both unique and non-unique btree indexes on same column ?
Oracle sql plsql questions
18 Jan, 03:55
If you have any questions/ any one is looking for job support or proxy or training pls reach out to me @[email protected]
Oracle sql plsql questions
18 Jan, 03:16
Hi All, really sorry for not sending the questions, busy with other stuff, from today will share the questions.
Oracle sql plsql questions
18 Jan, 03:14
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
using only SQL & also in PL/SQL
Example : Input String = 'ab$34%e#lfgrht)75(34gh'
Expected Output = 5
Oracle sql plsql questions
05 Jul, 10:33
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?
Oracle sql plsql questions
05 Jul, 10:27
SQL Question Of the Day: Convert row level data into comma separated string, when appending follow the employee_id asc
Oracle sql plsql questions
01 Jul, 13:03
If you have any questions/ any one is looking for job support or proxy or training pls reach out to me @[email protected]
Oracle sql plsql questions
01 Jul, 10:21
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);
Oracle sql plsql questions
24 Jun, 12:05
If you have any questions/ any one is looking for job support or proxy or training pls reach out to me @[email protected]
Oracle sql plsql questions
24 Jun, 12:05
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?
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?
Oracle sql plsql questions
23 Jun, 07:39
SQL coding Question Of The Day: Write a sequence which generates negative sequence numbers like
-1
-2
-3
......etc
-1
-2
-3
......etc
Oracle sql plsql questions
22 Jun, 04:18
If you have any questions/ any one is looking for job support or proxy or training pls reach out to me @[email protected]
Oracle sql plsql questions
22 Jun, 03:44
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?
Oracle sql plsql questions
20 Jun, 08:20
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.
Oracle sql plsql questions
19 Jun, 08:01
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?
6,736
subscribers
46
photos
11
videos
