Oracle面试题库-SQL.doc

文档介绍：==,,=;如何修改上述命令使其成功执行()=;(CUSTOMER)中有一列为单价(PRICE),写一个SELECT命令显示所有单价在500以上的查语句。ASELECT*FROMCUSTOMERWHEREPRICE>500;BSELECT*FROMCUSTOMERWHEREPRICEBETWEEN500AND*;CSELECT*FROMCUSTOMERWHEREPRICELIKE‘%500%’;DSELECT*FROMCUSTOMERWHEREPRICE>=500;:SELECTpriceFROMinventoryWHEREpriceBETWEEN1AND50AND(priceIN(55,30,95);命令执行后的输出结果是:( ):SELECTmanufacturer_idFROMinventoryWHEREmanufacturer_idLIKE‘%N\%P\%O%’ESCAPE‘\’;命令执行的返回结果是()A所有包含’NPO’的纪录B所有包含’N\P\O’的纪录C所有包含’N%P%O’的纪录D所有包含’%N\P\O%’:,,(+)=;WHERE子句中的(+)是什么含义?+,,把inventory表中的ORDER_DATE值’23-MAY-00′显示成’01-JAN-00′ASELECTROUND(order_date,‘YEAR’)FROMinventory;BSELECTTO_DATE(order_date,‘DD-MM-YY’)FROMinventory;CSELECTTO_CHAR(order_date,‘DD-MM-YY’)FROMinventory;:TO_DATE(’01-JAN-1998′)–TO_DATE(’01-DEC-1996′) 操作的区别?AROUND在截掉数据时有四舍五