Oracle sql plsql questions
Kanalga Telegram’da o‘tish
Oracle practice & Interview questions
Ko'proq ko'rsatishMamlakat belgilanmaganToif belgilanmagan
5 932
Obunachilar
Ma'lumot yo'q24 soatlar
Ma'lumot yo'q7 kunlar
Ma'lumot yo'q30 kunlar
Ma'lumot yuklanmoqda...
O'xshash kanallar
Taglar buluti
Ma'lumot yo'q
Muammo bormi? Iltimos, sahifani yangilang yoki bizning qo'llab-quvvatlash boshqaruvchimizga murojaat qiling>.
Kirish va chiqish esdaliklari
---
---
---
---
---
---
Obunachilarni jalb qilish
Dekabr '24
Dekabr '24
+33
0 kanalda
Noyabr '24
+58
0 kanalda
Get PRO
Oktabr '24
+98
0 kanalda
Get PRO
Sentabr '24
+182
0 kanalda
Get PRO
Avgust '24
+21
0 kanalda
Get PRO
Iyul '24
+127
0 kanalda
Get PRO
Iyun '24
+107
0 kanalda
Get PRO
May '24
+98
0 kanalda
Get PRO
Aprel '24
+92
0 kanalda
Get PRO
Mart '24
+99
0 kanalda
Get PRO
Fevral '24
+81
0 kanalda
Get PRO
Yanvar '24
+102
0 kanalda
Get PRO
Dekabr '23
+1 095
0 kanalda
Get PRO
Noyabr '230
0 kanalda
Get PRO
Oktabr '230
0 kanalda
Get PRO
Sentabr '230
0 kanalda
Get PRO
Avgust '230
0 kanalda
Get PRO
Iyul '230
0 kanalda
Get PRO
Iyun '230
0 kanalda
Get PRO
May '230
0 kanalda
Get PRO
Aprel '230
0 kanalda
Get PRO
Mart '230
0 kanalda
Get PRO
Fevral '230
0 kanalda
Get PRO
Yanvar '230
0 kanalda
Get PRO
Dekabr '220
0 kanalda
Get PRO
Noyabr '22
+200
0 kanalda
Get PRO
Oktabr '22
+181
0 kanalda
Get PRO
Sentabr '22
+135
0 kanalda
Get PRO
Avgust '22
+148
0 kanalda
Get PRO
Iyul '22
+231
0 kanalda
Get PRO
Iyun '22
+206
0 kanalda
Get PRO
May '22
+259
0 kanalda
Get PRO
Aprel '22
+735
0 kanalda
Get PRO
Mart '220
0 kanalda
Get PRO
Fevral '220
0 kanalda
Get PRO
Yanvar '22
+1
0 kanalda
Get PRO
Dekabr '21
+207
0 kanalda
Get PRO
Noyabr '21
+223
0 kanalda
Get PRO
Oktabr '21
+248
0 kanalda
Get PRO
Sentabr '21
+214
0 kanalda
Get PRO
Avgust '21
+201
0 kanalda
Get PRO
Iyul '21
+231
0 kanalda
Get PRO
Iyun '21
+242
0 kanalda
Get PRO
May '21
+1 314
0 kanalda
| Sana | Obunachilarni jalb qilish | Esdaliklar | Kanallar | |
| 21 Dekabr | +1 | |||
| 20 Dekabr | 0 | |||
| 19 Dekabr | +5 | |||
| 18 Dekabr | +3 | |||
| 17 Dekabr | 0 | |||
| 16 Dekabr | +1 | |||
| 15 Dekabr | 0 | |||
| 14 Dekabr | 0 | |||
| 13 Dekabr | 0 | |||
| 12 Dekabr | +3 | |||
| 11 Dekabr | +2 | |||
| 10 Dekabr | +3 | |||
| 09 Dekabr | +4 | |||
| 08 Dekabr | +3 | |||
| 07 Dekabr | 0 | |||
| 06 Dekabr | 0 | |||
| 05 Dekabr | +3 | |||
| 04 Dekabr | +3 | |||
| 03 Dekabr | 0 | |||
| 02 Dekabr | +1 | |||
| 01 Dekabr | +1 |
Kanal postlari
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 |
