ocp 19c考題,科目082考試題(13)-variable prompt
13.You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
A. SELECT &&col1, &&col2FROM &table WHERE &&condition = &&cond;
B. SELECT &col1, &col2FROM &&table WHERE &condition;
C. SELECT &col1, &col2FROM “&table” WHERE &condition;
D. SELECT ‘&&col1’, ‘&&col2’FROM &table WHERE ‘&&condition’ = ‘&cond’;
E. SELECT &&col1, &&col2FROM &table WHERE &&condition;
Source : cuug
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70010796/viewspace-2852146/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ocp 19c考題,科目082考試題(34)
- ocp 19c考題,科目082考試題(33)
- ocp 19c考題,科目082考試題-bigfile
- ocp 19c考題,科目082考試題(32) -
- ocp 19c考題,科目082考試題(24)-about sequence
- ocp 19c考題,科目082考試題(27) - order by clause
- ocp 19c考題,科目082考試題(22)- drop columns
- ocp 19c考題,科目082考試題(26) - order by clause
- ocp 19c考題,科目082考試題(25)- instance situations
- oracle ocp 19c考題,科目082考試題-temporary undoOracle
- oracle ocp 19c考題,科目082考試題-Oracle NetOracle
- oracle ocp 19c考題,科目082考試題-INTERSECT operatorOracle
- ocp 19c考題,科目082考試題(29) - about profiles
- ocp 19c考題,科目082考試題(28) - oracle profilesOracle
- ocp 19c考題,科目082考試題(30) - default profile
- ocp 19c考題,科目082考試題(15)-move datafile to
- oracle ocp 19c考題7,科目082考試題-listener tnsnamesOracle
- oracle ocp 19c考題,科目082考試題(18)-unused columnOracle
- oracle ocp 19c考題,科目082考試題-date/time functionsOracleFunction
- ocp 19c考題,科目082考試題(31) - resource_limitMIT
- ocp 19c考題,科目082考試題(14)-starting with the letter D
- oracle ocp 19c考題,科目082考試題(20)-set unused columnOracle
- oracle ocp 19c考題,科目082考試題(19)-set unused columnOracle
- oracle ocp 19c考題,科目082考試題(17)-using an invisible columnOracle
- oracle ocp 19c考題10,科目082考試題 - shared server dispatchersOracleServer
- ocp 19c考題,科目082考試題(12)-about self-join
- ocp 19c考題,科目082考試題(16)-about dropping and unused columns
- oracle ocp 19c考題8,科目082考試題-logical and physical database structuresOracleDatabaseStruct
- oracle ocp 19c考題,科目082考試題(21)-read-only tableOracle
- oracle ocp 19c考題11,科目082考試題 - about SET VERIFY ON commandOracle
- ocp 19c考題,科目082考試題(23)- space management within blocks managed ASSMBloCSSM
- Oracle 19c OCP 1Z0-082認證考試題庫(13-18)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(7-12)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(19-23)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(24-29)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(30-35)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(36-41)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(51-60)Oracle