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