<div>
Since this is the second in what I'm guessing will be a series, I wanted o point this out:<br />
You may be able to do a pretty direct port from SQL Server to Oracle but I will caution you that it may not perform the same. &nbsp;The two databases do things pretty differently. &nbsp;To get Oracle to perform, you need to understand how and why it does what it does.
</div>


Since this is the second in what I'm guessing will be a series, I wanted o point this out:
You may be able to do a pretty direct port from SQL Server to Oracle but I will caution you that it may not perform the same.  The two databases do things pretty differently.  To get Oracle to perform, you need to understand how and why it does what it does.

<div>
<div class="content wysiwyg-content">
I need to compare an hour field<br />
<br />
this works in MS SQL and trying to get similar in Oracle SQL Developer<br />
<br />
hh is a number ie: 8<br />
<br />
sum(case when hh=datepart(hour, dateadd(hh,1,getdate())) then 1 else 0 end) &gt;&nbsp;0<br />
<br />
the current time - 1 hour and then just getting the hour.
</div>
</div>


I need to compare an hour field

this works in MS SQL and trying to get similar in Oracle SQL Developer

hh is a number ie: 8

sum(case when hh=datepart(hour, dateadd(hh,1,getdate())) then 1 else 0 end) > 0

the current time - 1 hour and then just getting the hour.

oracle sql developer + get hour from datetime field

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.