A thirsty for information...

1d
awarded Popular Question
Nov
17
comment What is the best way of getting the latest record with the most recent date in oracle 12c?
Update the question with AutoTrace logs for all 4 methods
Nov
17
revised What is the best way of getting the latest record with the most recent date in oracle 12c?
added the auto-trace logs
Nov
17
revised What is the best way of getting the latest record with the most recent date in oracle 12c?
edited body
Nov
17
comment What is the best way of getting the latest record with the most recent date in oracle 12c?
@a_horse_with_no_name: Yes I did, i'll update the question as soon as i can
Nov
17
comment What is the best way of getting the latest record with the most recent date in oracle 12c?
I already used profiler to test each of these methods, the last two had the fastest performance with the least cost. How ever, i needed a a more thorough explanation on these methods, things like logical reads and other important aspects of their performance, In profiler, i cant understand everything. But a professional dba can easily spot the best one
Nov
17
asked What is the best way of getting the latest record with the most recent date in oracle 12c?
Nov
14
accepted Calling a static method from a class throws the type initializer for DS.API threw an exception
Nov
13
awarded Good Answer
Nov
11
comment Calling a static method from a class throws the type initializer for DS.API threw an exception
yes, thats exactly where i missed , the exact place i never forget!(actually my colleage didnt define the variable in fields section, it was in the middle of file among the methods!, thats why i missed it,and looking at the fields section of class, fields were fine!) Thank you alot by the way
Nov
11
comment Calling a static method from a class throws the type initializer for DS.API threw an exception
hundreds of codes can not be easily copied and pasted here for a question!, apart from that , from the security point of view that was not possible
Nov
11
answered Calling a static method from a class throws the type initializer for DS.API threw an exception
Nov
11
comment Calling a static method from a class throws the type initializer for DS.API threw an exception
there is nothing else left, by the way, API is partial and there are 4 classes that make the whole class ( i separated the logically different chores into sub files, and for ease of access, made them a partial API class
Nov
11
comment Calling a static method from a class throws the type initializer for DS.API threw an exception
whats the down vote for? seriously?
Nov
11
comment Calling a static method from a class throws the type initializer for DS.API threw an exception
I updated the question
Nov
11
revised Calling a static method from a class throws the type initializer for DS.API threw an exception
added 562 characters in body
Nov
11
comment Calling a static method from a class throws the type initializer for DS.API threw an exception
I get the object is not initialized expection. while i shouldnt! since i have no idea what it is talking about! it just needs to call a static method which calls DateTime.Now.ToBinary() method !!
Nov
11
asked Calling a static method from a class throws the type initializer for DS.API threw an exception
Nov
7
accepted Do Windows and Debian / Red Hat use the same thread management?
Nov
7
comment Automatic way to put all classes in separate files
its not free! Resharper is better in that case!
1 2 3 4 5