Oracle sql plsql questions

описание

Oracle practice & Interview questions

← к каналу @oraclesqlplsql

5 936

подписчиков

Охват к подписчикам

440,4%

ERR

Реакции к просмотрам

0,00%

0 на 20 постов

Пересылки к просмотрам

0,03%

136

Постов в день

0,0

всего 20

Где отзываются чаще

доля реакций к просмотрам

20 дек.SQL Question Of The Day : Implement pagination using rownum and without using the rownum.0,00%
19 дек.SQL Question Of The Day : what is the difference between NVL and coalesce explain with an example.0,00%
17 дек.SQL Question Of The Day : you have an EMP_ATTENDANCE table with below columns: • EMP_ID • ATTENDANCE_DATE • STATUS → 'P' = Present, 'A' = Absent Requirement: Find employees who were absent for 3 or more consecutive working days. Conditions : • Ignore Saturday & Sunday • Consecutive means continuous working days only Expected Output: • EMP_ID • Absence START_DATE • Absence END_DATE • TOTAL_ABSENT_DAYS0,00%
16 дек.Hi All, apologies , it's been a very long time , I was busy with migrations and new projects , will start tomorrow with the questions in oracle.0,00%
27 янв. 2022 г.SQL Question Of The Day: Can I use case statement with in insert statement ?0,00%
22 янв. 2022 г.If you have any questions/ any one is looking for job support or training pls reach out to me @vnpraneeth.oracle@gmail.com0,00%
22 янв. 2022 г.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 G30,00%
21 янв. 2022 г.Requirement : Year column need to be matched with the Transaction_date columns year component , if it is matched then pull the records.0,00%
20 янв. 2022 г.SQL Question Of the Day: Write a query to print the dates starting from 01-Jan-2022 to 31-Dec-20220,00%
19 янв. 2022 г.SQL Question Of the Day: Can I create both unique and non-unique btree indexes on same column ?0,00%
18 янв. 2022 г.If you have any questions/ any one is looking for job support or proxy or training pls reach out to me @vnpraneeth.oracle@gmail.com0,00%
18 янв. 2022 г.Hi All, really sorry for not sending the questions, busy with other stuff, from today will share the questions.0,00%