![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
小金鱼钰钰
这个作者很懒,什么都没留下…
展开
-
071-新增2
View the Exhibit and examine the description of the EMPLOYEES table Evaluate the following SQL statement: SELECT first_ name, employee_ id, NEXT_ DAY (ADD MONTHS (hire. date, 6), 1) "Review FROM empl...原创 2019-11-15 19:43:47 · 220 阅读 · 0 评论 -
071-新增2
Evaluate the commands issued by the DBA: 1 - CREATE ROLE mgr; 2 - GREATE CREATE TABLE, SELECT ON oe.orders TO mgr; 3 - GRANT mgr, create table TO SCOTT; Which statement is true regarding the executio...原创 2019-11-15 19:39:15 · 281 阅读 · 0 评论 -
071-新增2
View the Exhibit and examine the structure of the EMPLOYEES table You want to select all employees having 100 as their MANAGER ID managers and their manager. You want the output in two columns: the f...原创 2019-11-15 19:35:29 · 191 阅读 · 0 评论 -
071-新增2
Examine the data in the CUSTOMERS table: CUSTNO CUSTNAME CITY ------------- --------------- ---------------- 1 KING SEATTLE 2 GREEN BOSTON 3 KOCHAR SEATTLE 4 SMITH NEW YORK You want to list all citi...原创 2019-11-15 19:30:20 · 236 阅读 · 0 评论 -
071-新增2
View the Exhibit and examine the description of the EMPLOYEES table. You want to calculate the total remuneration for each employee. Total remuneration is the sum of the annual salary and the percent...原创 2019-11-15 19:24:49 · 177 阅读 · 0 评论 -
071-新增2
Evaluate the following query: SELECT INTERVAL’300’ MONTH,INTERVAL ‘54-2’ YEARTO MONTH, INTERVAL’11:12:10.1234567’ HOUR TO SECOND FROM dual; What is the correct output of the above query? A) +25-00,+5...原创 2019-11-15 19:19:44 · 132 阅读 · 0 评论 -
071-新增2
View the Exhibit and examine the description for the PRODOCTS and SALES table. PROD_ ID is a primary key in the PRODUCTS table and foreign key in the SALES table with ON DELETE CASCADE option. The S...原创 2019-11-15 19:16:41 · 169 阅读 · 0 评论 -
071-新增2
You need to produce a report where each customer’s credit limit has been incremented by $1000. In the output,the customer’s last name should have the heading name and the incremented credit limit sho...原创 2019-11-15 19:13:31 · 223 阅读 · 0 评论 -
在linux操作系统上安装12c Oracle数据库
文章目录在虚拟机上安装linux操作系统操作系统安装好后的准备工作使用root登陆,获取IP地址编辑yum配置文件安装软件包添加组和用户检查内核参数共享内存使内核参数生效资源限制检查需要的目录复制安装文件到系统 在虚拟机上安装linux操作系统 这个之前写过 https://blog.csdn.net/yangyuCISCO/article/details/84309516 有的电脑给40G硬盘内...原创 2019-06-26 10:43:51 · 633 阅读 · 0 评论