User Profile

zaffer · Nov 4 '11, 08:15 AM

Is there a way to create virtual table if I don't have create privilege??

zaffer · Oct 19 '11, 09:18 AM

Code:

SELECT trunc(sysdate) dt, count(*) as count
FROM ATM_MONITOR.ATM_PROBLEM
WHERE trunc(sysdate) = trunc(create_time)
union
SELECT trunc(sysdate)-1 dt, count(*) as count
FROM ATM_MONITOR.ATM_PROBLEM
WHERE trunc(sysdate)-1 = trunc(create_time)
union
SELECT trunc(sysdate)-2 dt, count(*) as count
FROM ATM_MONITOR.ATM_PROBLEM
WHERE trunc(sysdate)-2 = trunc(create_time)

...

User Profile

Profile Sidebar

How can I make virtual table whitout create privilege?

PL/SQL return count for all dates