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 ...
369
33
how to convert oracle sql date type to xml format ?ORACLE SQL
Click to see more ...
299
32
how to insert xml record to sql table using oracle sql ?ORACLE SQL
Click to see more ...
254
15
how to set grant to table using oracle sql ?ORACLE SQL
Click to see more ...
200
12
how to get xml document from oracle sql select ?ORACLE SQL
Click to see more ...
169
11
get recods plus 1 day oracle sqlORACLE SQL
Click to see more ...
247
11