小牛，骑士，活塞:rose: :rose: :rose:

湖人，火箭，老鹰，开拓者，马刺！:rose: :rose: :rose: :rose: :rose:

IS IT COUNT?月盘点:MONTHLY COUNTING盘点报告:COUNTING_REPORT......上面的说法对吗？或者还有没有其他的说法.TKS!:rose:

6000P=？明天看:yah:

语句:select casewhen (select ip.sk_inout_sale_code_dbfrom inventory_part ipwhere ip.part_no = dnl.sk_category_noand ip.contract = 'SKY') = 'OUTSALE' anddnl.sk_customer_no = 'SKH' then(SELECT coad.sk_destination_abbrFROM customer_order co1,PURCHASE_ORDER_LINE_ALL pol,customer_order co2,CUST_ORD_CUSTOMER_ADDRESS_ENT coa

我要建一个VIEW,这个TABLE有数十个字段,我实际只要对其中几个字段别名并插入少数列,这个TABLE的这些字段名是不是要一个一个的敲出来?SELECT column1,column2,column3.......... FROM TABLE有没有办法一下子就写出来:比如我敲一个SELECT 然后按一个什么键,所有的列名就自动显示在SELECT 后面?

1.SQL语句:SELECT *FROM (SELECT '&part_no' AS root, component_partFROM manuf_structureSTART WITH part_no = '&part_no'CONNECT BY prior component_part = part_no) mWHERE NOT EXISTS (SELECT 1FROM manuf_structure ms, inventory_part ptWHERE ms.part_no = pt.part_noand ms.contract = pt.contractand ms.eng_chg_level >= 1and ms.alternative_no = '*'and ms.bom_type in ('Manufacturing', 'Purc

1.问题描述:MANUF_STRU_TAB中给出了分别以完成品111A,111B,111C展开的三棵树的示例数据,想要的结果:当输入某个完成品番号(111A或111B或111C)时,要得到所有组成品中专用品的番号.(专用品指只在一个成品中使用,不参与其他成品的构成)2.建表语句示例数据create table MANUF_STRU_TAB(father_partVARCHAR2(25) not null,child_partVARCHAR2(25) not null)insert into MANUF_STRU_TAB values('111A',211);insert into MANUF_STRU_TAB values(211,311);insert into MANUF_STRU_TAB values(211,