Oracle SQL Practical question with answer | Compute the start and end value of group in given seq

[ramchinthakayala]

Nice logic with rownum ... You would explore many ways I ❤️ that and I will try reverse of this question.

[maheshpandey]

Thanks siva!

Reverse is here...

with tbl as
(
select 1 st, 3 en from dual union all
select 5, 5 from dual union all
select 7, 9 from dual union all
select 11, 12 from dual union all
select 15, 16 from dual union all
select 20, 20 from dual
),
ntbl as (select st, en, en-st+1 r from tbl ),
le as
(
select level lvl from dual
connect by level <=
(
select max(r) from ntbl) )

select
st+lvl-1 output from ntbl join le
on lvl<=r
order by output;

[sudhakarm]

I got the expected output. Thank u Siva for sharing this much of knowledge.

[narasimhanmurugan]

Bro I want to know query tunning and performance tunning clear concepts

[aaashwini]

Hi Siva,
Please upload videos on XML publisher reports --> multiple logo management in reports, displaying report in different languages. Please let me know if there are any videos which detail the above requirements.
Thank you
Ashwini

[shashank]

Awesome logic bro👏, pls make a video on pipeline function, explain plan in detail, Partioned table with local and global index how it's works?

[hrijoyeemukherjee]

Hi sir, can you please explain the same using row_number() ? In case we have unordered numbers then rownum is not working properly..please make a video on that..

[mathi]

Hi Siva, Thank you so much for sharing your knowledge with us, best session
practice sum ans:
SELECT distinct START_RANGE+level-1 c FROM TEMP_PRAC22_2 connect by level<= END_RANGE - START_RANGE+1
order by 1;

[NaveenKumar-rxfq]

Nice, but it also done by adding one identity column.... but ur explanation is too good

[veera]

Ur videos are just awsome siva... Can u explain sequence and level in sql???? Bcoz most of the videos in practice section are based on this concept only... That's y I'm asking siva... Pls do the needful help..

[kuldeepgupta]

Nice explanation Shiva
But what happens if we insert these values in a table but in random order and then apply order by
Then still we will get the same result ?

[srinivass]

Hi Siva, I have a requirement..
I have records with line numbers 1.0, 1.1, 1.2, 1.2.1, 1.3, 1.3.1, 1.3.2
Reqmt is
When I delete 1.3.1, 1.3.2 should become 1.3.1
When I delete 1.2, 1.2.1 then 1.3 records should change to 1.2 I.e it should be in sequence when records are deleted. Pls help with the logic

[munibhadranaidu]

hi sir can we store varray, nested tables, associative array in database.

[Jeetu]

Hi siva, Could you please make a detailed video on multi threading in oracle using partitions . Not a single video is available on youtube for the same.

[ashutosh]

Nice video. Please make a video on how an Optimizer works in back end.

[hanumanthu]

Hi Siva, i have one interview question for 7+,
Q) How we can find given sudoku was resolved or not ? or how we can find resolved pattern of sudoku by sql query?


could you please help us to answer this

[syedziauddin]

Hi sir how to make rows into columns and 1 column data into 2 column

[gurunaidu]

hi please video on time format 12hrs and 24 hrs

[syedziauddin]

How to covert rows into column and column into rows

[LGGift]

hi bro can u plz make some videos on pipelined functions