Oracle SQL Practical question | Oracle SQL to compute count of group of repeating values

Oracle SQL Practical question | Oracle SQL to compute count of group of repeating values

--------------------------------------------------------------
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

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

[hemnathc]

In your every video learning new things. Thank you Siva

[firozahmed]

All explanations are very neat and clean. Can we get a learning video about explain plan, tkprof and AWR? and like when to use what (in which scenario )between the three?

[shivrajmore]

Consider there are two tables. In first table there are details of employees and in second table there are salary details.
Then how to fetch the employee details having max salary.
@siva academy.

[vishalsaxena]

Sir today i had my interview in oracle data base and i m fresher actually that was my first interview the interviewer asked me many question and i replied the answers but they want need the answers like why this function we use advantages and disadvantages of the oracle objects like hm function ko ku use krty h hota kya h function hmara procedure ka use kya h ku hm cursor ko use krty h so as a fresher level i dont think koi bhi ans kar paega bcz muje yaad tha bht kuch syntexes bhi but phr bhi m select nhi ho paya so please make videos with all explanation as like interviews want pls

[sundarrajan]

Bro can u say how to find no. Of. * in the table. Note: * is in multiple column

[devikas]

If a table is having check constraint and before update trigger, which one will invoke first? Please answer, sir

[krishnanselvam]

could you post video while plsql interview freequently asking about importent unix

[krishnanselvam]

could you post video about cursor and cursor bulk collection full topic and functions and pakkages and tiggers videos with example

[lalatendupradhan]

The 2nd query output is
WITH T AS
(
SELECT DT_VAL,
GD_VAL,
ROWNUM,
ROWNUM - row_number()over (partition by gd_val order by ROWNUM) A

FROM PRACT33
ORDER BY ROWNUM
)
SELECT GD_VAL, COUNT(A)
FROM T
GROUP BY GD_VAL;

[krishnanselvam]

Could you post videos upload plsql loop and for loop and while loop and go-to statement and for loop cursor with syntax and example and details explanation.

[anshuman]

Hi Sir could you please help us in json data handling in 19c

[sachinchandanshiv]

Is it beneficial for an Oracle PL/SQL developer to get an AWS certification? Does it assist with career progression?

[jollymemories]

Is there any way to reach you bro ? FB or twitter. i want some answer from you pls