Oracle Enterprise Solutions & Architecture
Pages
Home
Oracle APEX Change Management System | Yasser Hassan Portfolio
Oracle Change Management System Demo
SQL Fundamentals
SQL Fundamentals II
PHP
SQL PLUS
PL/SQL
Forms and Reports
HTML5
JavaScript
Java
PL/SQL Collections and Records
PL/SQL Transactions
Ref Cursors
PL/SQL Analytic Functions
Problems and solves
Oracle Indexes
Work Samples
Record & Collection
Conditional statements
LOOP
Triggers
Object Oriented
NLS_LANG
Oracle Interview Question
About Me
Contact Me
Privacy Policy
Saturday, June 13, 2015
Oracle get date of first monday of the current month
Statement to get date of first monday of the current month :
SELECT NEXT_DAY(TRUNC(SYSDATE, 'MONTH'),'MONDAY') FROM DUAL;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment