Explore >> Select a destination
|
You are here 
|
www.dbaglobe.com | ||
| | | | |
iusoltsev.wordpress.com
|
|
| | | | | ??????? ?????? ?? ??????? ??????????? 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... | |
| | | | |
leonotes.wordpress.com
|
|
| | | | | ????????transitive closure?Wiki??????????Oracle????????... | |
| | | | |
connor-mcdonald.com
|
|
| | | | | Ever heard of a BAND join? It's not actually new, it has been around since 12.2. Jonathan Lewis wrote up a nice post on it was back in 2017 but in a nutshell MERGE join done without a band join SQL> select 2 e1.last_name|| ' has salary roughly between '|| e2.last_name comparison 3 from 4... | |
| | | | |
antognini.ch
|
|
| | | |||
