Oracle Database

78K

Solutions

25K

Contributors

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.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi All,

Can we skip any archivelog in recovery ??
0
 
LVL 6

Administrative Comment

by:Gene Richardson
This looks more like a question than a post and you might get a response if you submit it as such.
0
 
LVL 19

Expert Comment

by:Lucas Bishop
Here's where you can post a question:
https://www.experts-exchange.com/askQuestion.jsp
1
The 14th Annual Expert Award Winners
LVL 7
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Can anyone explain this?

When looking for transactions based on timestamp in e.g. 2017 you can for instance do it like this:

...where timestamp >= to_date('2017','YYYY')
or
...where timestamp >=to_date('01.01.2017','DD.MM.YYYY')

Why does these two expressions return different number of transactions? In my case the latter returns appox. 8 times as many. Is this an error in Oracle SQL or is it something I have missed?

Thx!

Brgds
IVer Erling Årva, Oslo
0
 
LVL 14

Expert Comment

by:Alexander Eßer [Alex140181]
I don't think this is a bug, I suppose it's just the default behavior if you omit some time parts. I just can't find any evidence within the official docs. Maybe some other Oracle expter may help in finding that reference?!
0
 

Administrative Comment

by:South Mod
It seems this is a technical question, and therefore you should post this as a Question in the appropriate topics. The Posts feature is intended for members to share news, information, etc with others, and not to find a solution to a technical problem.
0

Oracle Database

78K

Solutions

25K

Contributors

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.

Vendor Experts

Gil FeldmanMonday Learn more about Monday