Oracle SQL Practical question | Oracle SQL to print the all possible combination of numbers

Oracle SQL Practical question | Oracle SQL to print the all possible combination of numbers

00:00 Introduction
00:14 Problem Statement
01:24 Logic to resolve the Problem Statement
03:00 Demo
--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
--------------------------------------------------------------

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

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

About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

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

[QhairunnisaSyed]

Hi sir thank you so much for these wonderful videos. Recently i attended a interview where they asked me similar kind of coding question but little different
The question is we are provided with integer value say N and an array which contains N elements. We need to find the highest sum of possible combinations of an array whose sum should be Highest eg n=5 arr =(1, 2, 3, 5, -6) and outpit should be 10 .
Can you please please help me in how to to solve this question

[DB-HACKS_AV]

Hi sir, we are working in v23 cloud there we can't create trigger is there any ways to audit tables

[Shru]

I currently have 9 yrs of experience in plsql and ssis etl.. what extra I can learn which can help me in my career growth please help out

[subhrakantabehera]

I am a bigginner i am following your channel your teaching style is extraordinary but i don't know how to start Learn sql and plsql from your channel please help me put

[LokeshKumar-iior]

Sir....
How to find out all special characters in a coloumn, pls tell me

[sbs]

Write a query to displayed all details of employees only if has at least 2Ls in his names with out like operators

How to write a query above question

[mrarjitvlog]

Kindly make a videos how we create job in oracle

[abdulmazid]

Sir please make videos on performance tuning concepts your teaching skills is irreplaceable..

[enjoyfriends]

Thanks

WITH d AS (
SELECT
*
FROM
(
SELECT
ROWNUM AS x
FROM
dual
CONNECT BY
level <= 4
)
)
SELECT
*
FROM
(
SELECT
a.x,
CASE
WHEN a.x < b.x
AND a.x != b.x THEN
b.x
END AS inp
FROM
d a,
d b
ORDER BY
a.x,
b.x
)
WHERE
inp IS NOT NULL;