Oracle SQL Practical question | Oracle SQL to find total time and work time and break time

Oracle SQL Practical question | Oracle SQL to find total time and work time and break time
--------------------------------------------------------------
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

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

[bsraju]

Hi Siva sir... You are so helpful to us, you are doing great service without expectations from viewers... 🙏. ...Can you pls share us a vedio " how to debug plsql code through display stmnt and other ways "?
Thank you in Advance 🙏.

[prithvikumar]

Hi can you please share the scripts for this question. Yo have explained it very clearly and we want more questions related to window functions

[akshaysinha]

Sir please make some sessions on Performance Tuning 🙏

[manjutharak]

Hi Brother make video on PL/SQL Object Type. In real-time I seen that object type they will in collection types and that collection type variable name they will mention as a datatype in procedure what purpose they will do Luke this my question

[zuqepgx]

Hii good evening sir,
Your videos are really so helpful.
Sir I want the solution for the following query,
Write a query to display customer name which contains three words in their name from customer table???

[venugopalshramwad]

Well explained, Great work. Love to watch more videos like this, Much appreciated

[hariprasath]

1)Sir i cant able to get the output ... u have alternate query for this ..? If yes means plz tell me
2)And how to write query for this without using nvl ()

[premlatakapse]

hello sir
good evening
sir ur video is very helpful
sir i want the solution for the following query
WAQ to (trunc(sysdate))< = trunc(sysdate)

[parakkumpura]

Hi Bro.. what if in and out time data present like this
In/time. Out/time
9:30am. Null
Null. 11:12am
11:30am. Null


How to calculate this?

[rajivshivaraman]

Sir can you please make video on XMLTABLE?

[inhlam]

Use Lag function, and nvl function for total time.

[oraatech]

HOW CAN I QUERY TOTAL MINUTES FROM 1 COLUMN IN SAME DAY LINKE IN TIME IS 9 SO I HAVE TO KNOW THE HOW MUCH MINUTES HE LATE IN OFFICE?

[veerayyachowdary]

Good explanation but video clarity is bad I hope next time you will come with good clarity.

[SanjayKumar-ngzp]

Please find table script to test above functionality

CREATE TABLE time_tracker
(ename varchar2(100),
punch_desc varchar2(100),
punch_time date
);

select * from time_tracker;

insert all
into time_tracker values('RAVI', 'PUNCH IN', TO_DATE('01-SEP-2021 10:00:00 AM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('RAVI', 'PUNCH OUT', TO_DATE('01-SEP-2021 12:30:00 PM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('RAVI', 'PUNCH IN', TO_DATE('01-SEP-2021 01:30:00 PM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('RAVI', 'PUNCH OUT', TO_DATE('01-SEP-2021 04:30:00 PM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('RAVI', 'PUNCH IN', TO_DATE('01-SEP-2021 05:30:00 PM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('RAVI', 'PUNCH INUT', TO_DATE('01-SEP-2021 06:00:00 PM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('KAVIN', 'PUNCH IN', TO_DATE('01-SEP-2021 09:00:00 AM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('KAVIN', 'PUNCH OUT', TO_DATE('01-SEP-2021 11:30:00 AM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('KAVIN', 'PUNCH IN', TO_DATE('01-SEP-2021 11:45:00 AM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('KAVIN', 'PUNCH OUT', TO_DATE('01-SEP-2021 12:30:00 PM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('KAVIN', 'PUNCH IN', TO_DATE('01-SEP-2021 01:15:00 PM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('KAVIN', 'PUNCH OUT', TO_DATE('01-SEP-2021 4:00:00 PM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('KAVIN', 'PUNCH IN', TO_DATE('01-SEP-2021 4:15:00 PM', 'DD-MON-YYYY HH:MI:SS AM'))
into time_tracker values('KAVIN', 'PUNCH OUT', TO_DATE('01-SEP-2021 6:30:00 PM', 'DD-MON-YYYY HH:MI:SS AM'))
select * from dual ;

[dhavalpandya]

Hi Siva,
I have below requirement:
Input table with one column I'd
11
11
11
12
12
12
11
11
11
And I want output like below
I'd, grpid
11, 1
11, 1
11, 1
12, 2
12, 2
12, 2
11, 3
11, 3
11, 3

[nehakapoor]

Hi i have new question can you please tell me how to calculate difference between years..question write query to find year in which olympic happens but due to pandemic it was delayed


olm_id olm_year
101 2000
102 2004
103 2012
104 2016
105 2024

Output
103 2008
105 2020