Oracle sql plsql questions
前往频道在 Telegram
Oracle practice & Interview questions
显示更多未指定国家未指定类别
5 932
订阅者
无数据24 小时
无数据7 天
无数据30 天
数据加载中...
吸引订阅者
十二月 '24
十二月 '24
+33
在0个频道中
十一月 '24
+58
在0个频道中
Get PRO
十月 '24
+98
在0个频道中
Get PRO
九月 '24
+182
在0个频道中
Get PRO
八月 '24
+21
在0个频道中
Get PRO
七月 '24
+127
在0个频道中
Get PRO
六月 '24
+107
在0个频道中
Get PRO
五月 '24
+98
在0个频道中
Get PRO
四月 '24
+92
在0个频道中
Get PRO
三月 '24
+99
在0个频道中
Get PRO
二月 '24
+81
在0个频道中
Get PRO
一月 '24
+102
在0个频道中
Get PRO
十二月 '23
+1 095
在0个频道中
Get PRO
十一月 '230
在0个频道中
Get PRO
十月 '230
在0个频道中
Get PRO
九月 '230
在0个频道中
Get PRO
八月 '230
在0个频道中
Get PRO
七月 '230
在0个频道中
Get PRO
六月 '230
在0个频道中
Get PRO
五月 '230
在0个频道中
Get PRO
四月 '230
在0个频道中
Get PRO
三月 '230
在0个频道中
Get PRO
二月 '230
在0个频道中
Get PRO
一月 '230
在0个频道中
Get PRO
十二月 '220
在0个频道中
Get PRO
十一月 '22
+200
在0个频道中
Get PRO
十月 '22
+181
在0个频道中
Get PRO
九月 '22
+135
在0个频道中
Get PRO
八月 '22
+148
在0个频道中
Get PRO
七月 '22
+231
在0个频道中
Get PRO
六月 '22
+206
在0个频道中
Get PRO
五月 '22
+259
在0个频道中
Get PRO
四月 '22
+735
在0个频道中
Get PRO
三月 '220
在0个频道中
Get PRO
二月 '220
在0个频道中
Get PRO
一月 '22
+1
在0个频道中
Get PRO
十二月 '21
+207
在0个频道中
Get PRO
十一月 '21
+223
在0个频道中
Get PRO
十月 '21
+248
在0个频道中
Get PRO
九月 '21
+214
在0个频道中
Get PRO
八月 '21
+201
在0个频道中
Get PRO
七月 '21
+231
在0个频道中
Get PRO
六月 '21
+242
在0个频道中
Get PRO
五月 '21
+1 314
在0个频道中
| 日期 | 订阅者增长 | 提及 | 频道 | |
| 21 十二月 | +1 | |||
| 20 十二月 | 0 | |||
| 19 十二月 | +5 | |||
| 18 十二月 | +3 | |||
| 17 十二月 | 0 | |||
| 16 十二月 | +1 | |||
| 15 十二月 | 0 | |||
| 14 十二月 | 0 | |||
| 13 十二月 | 0 | |||
| 12 十二月 | +3 | |||
| 11 十二月 | +2 | |||
| 10 十二月 | +3 | |||
| 09 十二月 | +4 | |||
| 08 十二月 | +3 | |||
| 07 十二月 | 0 | |||
| 06 十二月 | 0 | |||
| 05 十二月 | +3 | |||
| 04 十二月 | +3 | |||
| 03 十二月 | 0 | |||
| 02 十二月 | +1 | |||
| 01 十二月 | +1 |
频道帖子
SQL Question Of The Day: Can I use case statement with in insert statement ?
| 2 | If you have any questions/ any one is looking for job support or training pls reach out to me @vnpraneeth.oracle@gmail.com | 5 227 |
| 3 | 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 | 5 863 |
| 4 | Requirement : Year column need to be matched with the Transaction_date columns year component , if it is matched then pull the records. | 4 752 |
| 5 | SQL Question Of the Day: Write a query to print the dates starting from 01-Jan-2022 to 31-Dec-2022 | 4 858 |
| 6 | SQL Question Of the Day: Can I create both unique and non-unique btree indexes on same column ? | 5 015 |
| 7 | 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 | 5 138 |
| 8 | Hi All, really sorry for not sending the questions, busy with other stuff, from today will share the questions. | 4 786 |
| 9 | 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 | 4 644 |
| 10 | 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? | 6 548 |
| 11 | SQL Question Of the Day: Convert row level data into comma separated string, when appending follow the employee_id asc | 327 |
| 12 | 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 | 705 |
| 13 | 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); | 752 |
| 14 | 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 | 1 196 |
| 15 | 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? | 1 136 |
| 16 | I have sequence created with below command:
Create sequence seq_test start with 10 increment by 5 maxvalue 50 cycle cache 5; | 1 |
| 17 | SQL coding Question Of The Day: Write a sequence which generates negative sequence numbers like
-1
-2
-3
......etc | 1 022 |
| 18 | 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 | 1 145 |
| 19 | 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? | 910 |
| 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. | 1 038 |
