OCP19C-82

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?

发布于 2021-04-25 04:04:25

【多选题】
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;

关注者

0

被浏览

97

MEISHAONV 2023-04-25

这家伙很懒，什么也没写！

此回答被采纳为最佳答案，开通VIP会员可查看

1 个回答

撰写答案

请登录后再发布答案，点击登录

关于作者

MrCheng

这家伙很懒，什么也没写！

提问

回答

1540

被采纳

1481

关注TA

发私信

相关问题

1

低领老年人，中龄老年人，高龄老年人分别

2

现金购买的电子客票，自退票之日起180天内（含当日），持购票时使用的( )前往任一铁路车站窗口领取现金。

3

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored?

4

You have been tasked to create a table for a banking application. One of the columns must meet three requirements: Be stored in a format supporting date arithmetic without using conversion functions Store a loan period of up to 10 years Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

5

7.In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: Which statement is true?

6

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. Which query can be used?

7

Which two statements are true? (Choose two.)

8

(Choose three.)

9

Examine the following command: CREATE TABLE ( prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in t he PRODUCTS table?

10

ALTER TABLE orders SET UNUSED (order_date); Which statement is true?

发布
问题

手机
浏览

扫码手机浏览

在线
客服