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 ...
343
33
how to convert oracle sql date type to xml format ?ORACLE SQL
Click to see more ...
278
32
how to insert xml record to sql table using oracle sql ?ORACLE SQL
Click to see more ...
234
15
how to set grant to table using oracle sql ?ORACLE SQL
Click to see more ...
180
12
how to get xml document from oracle sql select ?ORACLE SQL
Click to see more ...
151
11
get recods plus 1 day oracle sqlORACLE SQL
Click to see more ...
225
11