急！Oracle考试的几道题

[公务员面试有几道题？多长时间回答一道最好]你好，公务员面试一般分为结构化面试和无领导小组讨论两种。现在大部分都是采用结构化面试题目的，今年4月份省级联考刚参加过。计3道题总计10分钟，即平均一题听题，思考，答题约3...+阅读

急！Oracle考试的几道题

1、select * from 商品信息表 where 销售单价 between 1000 and 2000 ;

2、select * from 商品信息表 order by 销售单价 desc ;

3、select * from 商品信息表 where （商品名称 like 'A%' or 商品名称 like '%R' ） and 单价>3000;

4、select * from 商品信息表 where 产地 in （'南京市'，'北京市'）；

select * from 商品信息表 where 产地='南京市' or 产地='北京市'；

5、select count（商品种类） from 表名 where 供应商='供应商名'；

Oracle简单试题大神来看看

create table table_1

( id varchar2(20) primary key,

name varchar2(50) null,

workshop varchar2(10) null);

create table table_2

(

id varchar2(20) primary key,

gz number,

jt number,

sf number,

month number

);

create table table_3

(

id varchar2(20) primary key,

cd number,

zt number,

month number

);

insert into table_1 values('1003'，'尼妹'，'三')；

insert into table_2 values('1003',5000,500,5500,10);

insert into table_3 values('1003',0,0,0,10);

Oracle存储过程的笔试题：有一个两维表 M行N列请用Oracle的存

行列转换啊

利用数据字典，经过存储过程生成对应的视图，我来写一个

稍等

不好意思，中午电脑出毛病了。过程如下

CREATE OR REPLACE PROCEDURE row_col_convert(p_tabname IN VARCHAR2,view_name IN VARCHAR2 DEFAULT 'v_tmp') AUTHID CURRENT_USER AS sqlstr VARCHAR2(4000); sqlstr1 varchar2(500):='select ''??'' newid'; cur sys_refcursor; id_col VARCHAR2(30); id varchar2(100); BEGIN if trim(p_tabname) is null then return; end if; SELECT column_name INTO id_col FROM user_tab_cols WHERE table_name=upper(p_tabname) AND column_id=1; OPEN cur FOR 'select to_char('||id_col||') from '||p_tabname||' order by 1'; loop fetch cur INTO ID; exit WHEN cur%notfound; sqlstr1:=sqlstr1||',max(decode('||id_col||','''||id||''',to_char(??)))＂'||id||'＂'; END loop; sqlstr1:=sqlstr1||' from '||p_tabname; FOR cur1 IN(SELECT column_name FROM user_tab_cols WHERE table_name=upper(p_tabname) AND column_id>1) loop sqlstr:=sqlstr||chr(10)||'union all '||REPLACE(sqlstr1,'??',cur1.column_name); END loop; execute immediate 'create or replace view '||view_name||' as '||substr(sqlstr,12); END;

编译好过程后，传入表名（视图名为可选传参，默认为v_tmp），执行后查询创建的视图即可

可以根据实际情况作适当修改，比如这里取字段名用的user_tab_cols可以改成all_tab_cols，此时最好再加上owner条件来准确定位

试试，有问题问我

Oracle12c最新CUUGOCP071考试题库53题

53、（12-14） choose the best answer:Examine the command to create the BOOKS table。SQL>CREATE TABLE books(book_id CHAR(6) PRIMARY KEY,title VARCHAR2(100) NOT NULL,publisher_id VARCHAR2(4),author_id VARCHAR2(50));The BOOK_ID value 101 does not exist in the table。 Examine the SQL statement:SQL>INSERT INTO books(BOOK_ID, TITLE, AUTHOR_ID)VALUES ('101', 'LEARNING SQL', 'Tim Jones');Which statement is true?A) It executes successfully only if the PUBLISHER_ID column name is added to the columns list and NULL is explicitly specified in the INSERT statement。 B) It executes successfully only if NULL is explicity specified in the INSERT statement。C) It executes successfully only if the PUBLISHER_ID column name is added to the columns list in the INSERT statement。 D) It executes successfully and the row is inserted with a null PUBLISHER_ID。 Answer:D【Oracle 12c】最新CUUG OCP-071考试题库（53题）标签：coltabddevarcolumnrowsqlexistval标签 col tab dde var column row sql exist val。