Outer Web | Explore

Explore >> Select a destination

You are here		blog.sqlora.com Parameterized Views with SQL Macros (Part 2)
\|	\|	sqlmaria.com How to create a parameterized view in Oracle	2.3 parsecs away Travel
\|	\|	Database views have been used for decades to help simplify both ad-hoc queries and reporting for developers, analysts, and end-users. But the problem with defining views is they tend to be either t...	2.3 parsecs away Travel
\|	\|	rwijk.blogspot.com About Oracle: dbms_xplan.display_cursor	3.8 parsecs away Travel
\|	\|		3.8 parsecs away Travel
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	3.8 parsecs away Travel
\|	\|	??????? ?????? ?? ??????? ??????????? 465 ??????! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%????????%' OR A.LASTNAME LIKE '%????????%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ??? ???????, ????????? ???? ?? ??????? A.COMPANY_ID = 1 ???????? ??????? ???????????????? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT...	3.8 parsecs away Travel
\|	\|	dioncho.wordpress.com Interesting case of the restriction of global hints \| Dion Cho - Oracle Performance Storyteller	24.1 parsecs away Travel
\|		One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the...	24.1 parsecs away Travel