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 ...
338
33
how to convert oracle sql date type to xml format ?ORACLE SQL
Click to see more ...
274
32
how to insert xml record to sql table using oracle sql ?ORACLE SQL
Click to see more ...
230
15
how to set grant to table using oracle sql ?ORACLE SQL
Click to see more ...
175
12
how to get xml document from oracle sql select ?ORACLE SQL
Click to see more ...
147
11
get recods plus 1 day oracle sqlORACLE SQL
Click to see more ...
220
11