select peopleid where (TO_CHAR(PEOPLE.BIRTHDATE, 'MM') = TO_CHAR(SYSDATE, 'MM')) AND (TO_CHAR(PEOPLE.BIRTHDATE, 'DD') between TO_CHAR(SYSDATE, 'DD') and TO_CHAR(SYSDATE, 'DD') +7
|JDeveloper 12c for 32 bit||4||66|
|Is it possible to insert default data into a column without using column list in insert statement||16||82|
|Getting TNS:Connect timeout occurred while opening the application||5||55|
|Oracle sql query||7||38|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!