Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multipass SQL
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... -
Querying multiple fact tables
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...- biff2002
- Thread
- Replies: 1
- Forum: Data Warehousing/Big Data
-
Evaluating a string
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. -
Excel to Oracle - Any freeware products?
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
