-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
We continue our series on optimizer transformations with a post that describes the Join Factorization transformation. The Join Factorization transformation was introduced in Oracle 11g Release 2 and applies to UNION ALL queries. Union all queries are commonly used in database applications, especially…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Recently i made two template classes,according to the book "Modern C++ design". I think these classes are useful but no one in my company agree with me,so could any one tell me if these things are useful?
The first one is a parameter wrapper,it can package function paramters to a single dynamic object…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
I'm more of a web developer kind of guy with limited knowledge of networks, so if anyone can point in the right direction, I would be grateful.
I am replacing my satellite connection with a T1 I got for a good deal thru the phone company. I also managed to get my hands on a Netvanta 3200 router…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Here is my query,
select t1.dSyllabus_id,t1.dBatch,t1.dFilePathName,
t2.dDegreeName,t3.dDepartmentAbbr
from tbl_syllabus as t1
join tbl_degree_master as t2,
tbl_department_master as t3
where t2.dDegree_id=t1.dDegree_id
and t3.dDepartment_id=t1.dDepartment_id
and t1.dCollege_id='1'
and t1.dIsDelete='0'
and…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi
Any ideas how i go about replacing the following self join using analytics
SELECT
t1.col1 col1,
t1.col2 col2,
SUM((extract(hour FROM (t1.times_stamp - t2.times_stamp)) * 3600 + extract(minute FROM ( t1.times_stamp - t2.times_stamp)) * 60 + extract(second FROM ( t1.times_stamp - t2.times_stamp))…
>>> More
