ch
Feedback

不要被骗子欺骗!Telemetrio 会找到并标记这些频道 👉 如果想查看标记,请订阅

Oracle sql plsql questions

前往频道在 Telegram

Oracle practice & Interview questions

显示更多
未指定国家未指定类别
5 932
订阅者
无数据24 小时
无数据7 天
无数据30 天
帖子存档
SQL Question Of The Day: Can I use case statement with in insert statement ?
27 1月 2022, 00:40

If you have any questions/ any one is looking for job support or training pls reach out to me @vnpraneeth.oracle@gmail.com
22 1月 2022, 06:55

SQL Question Of The Day: Requirement :I would like to findout 21-jan-2022 belongs to which group and prior to that group if t
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
22 1月 2022, 06:52

Requirement : Year column need to be matched with the Transaction_date columns year component , if it is matched then pull th
Requirement : Year column need to be matched with the Transaction_date columns year component , if it is matched then pull the records.
21 1月 2022, 12:24

SQL Question Of the Day: Write a query to print the dates starting from 01-Jan-2022 to 31-Dec-2022
19 1月 2022, 22:55

SQL Question Of the Day: Can I create both unique and non-unique btree indexes on same column ?
18 1月 2022, 23:17

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
17 1月 2022, 22:55

Hi All, really sorry for not sending the questions, busy with other stuff, from today will share the questions.
17 1月 2022, 22:16

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
17 1月 2022, 22:14

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?
05 7月 2021, 06:33

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: Convert row level data into comma separated string, when appending follow the employee_id asc
05 7月 2021, 06:27

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
01 7月 2021, 09:03

SQL Question Of The Day: I want to display the employee_ids who are not managers, I have written this query,but not getting t
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);
01 7月 2021, 06:21

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
24 6月 2021, 08: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?
24 6月 2021, 08:05

I have sequence created with below command: Create sequence seq_test start with 10 increment by 5 maxvalue 50 cycle cache 5;
24 6月 2021, 08:03
24 6月 2021, ~08:03

SQL coding Question Of The Day: Write a sequence which generates negative sequence numbers like -1 -2 -3 ......etc
23 6月 2021, 03:39

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
22 6月 2021, 00:18

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?
21 6月 2021, 23:44

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.
20 6月 2021, 04:20