Oracle sql practice exercise with solution | SQL query to print sequence of numbers

Description:

SQL Practical Interview question
Oracle sql practice exercise with solution
SQL questions for data analysis
---------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------

[vidyashree]

Thank you so much for your video series.

[sujaa]

Thank you Siva, it was very helpful.
Regards,
Sujaa

[jyotikhandagale]

This question asked me in every interview. Thank You

[rahulbhusari]

Or else can cover the data engineer or data analytics series

[rahulbhusari]

Can you please make some core videos like data model or making database design or data masking kind of thing...

[sairamkrishnabegenuine]

Can you pls make videos on Model queries.

[rohanpatil]

Sir how to find the missing number in a table which contains 1...7 and number 5 is missing.
I want output as 5

[madakasai]

CREATE OR REPLACE FUNCTION SF_LOOP1(P_NUMBER NUMBER)
RETURN SYS_REFCURSOR
AS
TYP SYS_REFCURSOR;
BEGIN
OPEN TYP FOR SELECT LEVEL FROM DUAL CONNECT BY LEVEL<=P_NUMBER;
RETURN TYP;
END;
/
SELECT SF_LOOP1(10) FROM DUAL;