SQL* Is there a way to make a procedure that will verify what time and day?(Beginner) SQL*

It’s for a school project and I know it may seems basic but I’m wondering how to make a procedure that will verify what time and day it’s actually is like monday and not the date. thank you

Answer

Please use this –

select to_char(sysdate, 'Day') from dual;

Pls note, you can use ‘DAY’ to get all caps, ‘Day’ to get initcaps. There are whole lot of things you can do in terms of formatting the date. You can refer to the link below. https://livesql.oracle.com/apex/livesql/file/content_GCEY1DN2CN5HZCUQFHVUYQD3G.html