Welcome aboard! We are happy you are here and wish you good net-raft!
SELECT * FROM TABLE1 WHERE COLUMN1_DATE between sysdate AND sysdate - 1
The most helpful ORACLE SQL solutions
add grant oracle sqlORACLE SQL
Click to see more ...
363
33
how to convert oracle sql date type to xml format ?ORACLE SQL
Click to see more ...
291
32
how to insert xml record to sql table using oracle sql ?ORACLE SQL
Click to see more ...
246
15
how to set grant to table using oracle sql ?ORACLE SQL
Click to see more ...
194
12
how to get xml document from oracle sql select ?ORACLE SQL
Click to see more ...
163
11
get recods plus 1 day oracle sqlORACLE SQL
Click to see more ...
242
11