Oracle Certificate Profession 1Z0-051-07
A. Both USING and ON clauses can be used for equijoins and nonequijoins.
B. A maximum of one pair of columns can be joined between two tables using the ON clause.
C. The ON clause can be used to join tables on columns that have different names but compatible data types.
D. The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause.
答案:(C、D)
解析:
--A(X), USING只能用於等值連線 --B(X), 可以指定多個pair of columns select e.empno, e.ename, e.deptno, d.loc from emp e join dept d on(e.deptno = d.deptno and d.deptno = e.deptno) where empno = 7788; --D --ON可以與WHERE一起使用 select e.empno, e.ename, e.deptno, d.deptno, d.loc from emp e join dept d on(e.deptno = d.deptno) where e.empno = 7788; EMPNO ENAME DEPTNO DEPTNO LOC ---------- ---------- ---------- ---------- ------------- 7788 SCOTT 20 20 DALLAS
--USING可以和WHERE一起使用 select e.empno, e.ename, deptno, d.loc from emp e join dept d using(deptno) where empno = 7788; EMPNO ENAME DEPTNO LOC ---------- ---------- ---------- ------------- 7788 SCOTT 20 DALLAS |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1156380/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 關於Oracle Certificate ProfessionOracle
- Oracle Certificate Profession 1Z0-051-28Oracle
- Oracle Certificate Profession 1Z0-051-22Oracle
- Oracle Certificate Profession 1Z0-051-27Oracle
- Oracle Certificate Profession 1Z0-051-25Oracle
- Oracle Certificate Profession 1Z0-051-26Oracle
- Oracle Certificate Profession 1Z0-051-29Oracle
- Oracle Certificate Profession 1Z0-051-20Oracle
- Oracle Certificate Profession 1Z0-051-16Oracle
- Oracle Certificate Profession 1Z0-051-14Oracle
- Oracle Certificate Profession 1Z0-051-19Oracle
- Oracle Certificate Profession 1Z0-051-12Oracle
- Oracle Certificate Profession 1Z0-051-03Oracle
- Oracle Certificate Profession 1Z0-051-04Oracle
- Oracle Certificate Profession 1Z0-053-06Oracle
- Oracle Certificate Profession 1Z0-053-02Oracle
- Oracle Certificate Profession 1Z0-053-09Oracle
- Certificate Authority
- git SSL certificate problem: unable to get local issuer certificateGit
- GIT clone報錯: SSL certificate problem: unable to get local issuer certificateGit
- SSL certificate chainsAI
- PHP composer 報錯 certificate verify failedPHPAI
- 教育授權certificate used to sign the license
- git (v2.18.0) error setting certificateGitError
- 專案使用guzzleHttp報錯:certificate has expiredHTTP
- android javax.net.ssl.SSLPeerUnverifiedException: No peer certificateAndroidJavaException
- 證書鎖定Certificate Pinning技術
- WCF分散式安全開發實踐(11):訊息安全模式之Certificate身份驗證:Message_Certificate_WSHttpBinding分散式模式HTTP
- Useless SAP PA certificate, do we still need to get it?
- electron專案npm i 報錯certificate has expiredNPM
- [GuzzleHttp\Exception\RequestException] cURL error 60: SSL certificate problem: unable to get localHTTPExceptionError
- wget 命令提示 “use ‘--no-check-certificate’” 臨時解決方法wget
- error:14090086:SSL routines:ssl3_get_server_certificateErrorServer
- 解決“The remote certificate is invalid according to the validation procedure”問題REM
- windows 環境下使用 Node.js 遇到 unable to get local issuer certificateWindowsNode.js
- gitlab-runner x509: certificate signed by unknown authorityGitlab
- ***PHP5.6.xSSL3_GET_SERVER_CERTIFICATE:certificateverifyfailed解決方案PHPServerAI
- 如何匯入某網站的certificate證書到SAP ABAP系統網站