-
can we insert a record in dual?
Niranjan Dubey
- Jan 6th, 2012
Dual is a Dummy table when we execute query.. "sql Select * from dual it will show .. DUMMY X It ha...
Rabindra_Kumar
- Oct 28th, 2009
You can perform any DML operations in dual table provided that you have been given the privilege to do so.However never try to perform any DML operations (delete/insert/update) in dual table because d...
-
Analytical Function
WE using Last_value()analytical function but the result do not match according to me?
Raj_P
- Sep 1st, 2010
I am working on Oracle 9i and as far as I know the function "Last_Value" doesnt work in 9i. We are using the "First_Value" function with order by clause using descending order. Select First_Value(FieldName) Over (Partition by FieldName Order by TrandDate Desc) From .
Avashisth
- Feb 20th, 2010
Analytical function are the builtin function in Oracle, so during execution it will be faster then other simple function. These function are basically used for reporting and most of the time to improv...
