I am looking for information regarding Multipass SQL.
Is it a concept for sql engines only, or it it an approach I can use in actually writing a query?
My context is wanting to query multiple fact tables which share a common dimensional surrogate key in a dimensional datawarehouse. According...
I am looking to build a query involving multiple fact tables which share a common dimension key - can anyone shed some light on the accurate way to do this?
Eg Customer dimension table has customer_key
Orders fact table has a list of all orders, including the customer_key involved
Returns fact...
Use the dummy SQL table DUAL, which allows you to perform your calculation while conforming to the usual SQL syntax.
Eg.
select 2+4+5+1
from dual;
> 12
DUAL is handy for many operations where you don't actually need to retrieve table data eg select sysdate from dual.
Anybody know of a freeware product to load Excel data directly to an Oracle database?
I've looked at SQL*XL Lite, but this is a temporary evaluation version only.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.