r****5
发帖数: 618 | 1 要写一个procedure，这个procedure的要求是：能加新的customer，但是这个
procedure不能有具体的值，而是有parameter,并且可以使用来输入新的record. 我这
样写的, 但是"Warning, procedure created with compliation errors".
CREATE OR REPLACE PROCEDURE Create_Customer(
v-custnum IN customers.cust_num%TYPE,
v_name IN customers.cust_name%TYPE,
v_address IN customers.cust_address%TYPE)
AS
BEGIN
INSERT INTO customers
VAlUES(v-custnum,v_name,v_address);
END create_customer;
END;
/
另外我用cursor写的。也是同样的errors。大家帮我看看有什么不对？
CREATE OR REPLACE PROCEDURE Create_Customer... 阅读全帖 |
|
i****a
发帖数: 36252 | 2 need to query between TableA and TableB. and it's taking too long
because the columns on lookup do no have indexes
TableA.CustNum data can appear in any or all of the following columns in
TableB
TableB.CustNum1
TableB.CustNum2
TableB.CustNum3
about 240M rows in TableB, on index on the CustNum fields, no foreign
keys
I am thinking creating a separate table with only 3 CustNum1/2/3
columns, with indexes defined, then insert 3 columns of data into it.
but it takes 20 hours to insert with indexes de |
|
r****5
发帖数: 618 | 3 去掉一个, 仍旧不work: encountered the symbol "-" when expecting one of the
following: n out longd double ref char tie interval date binary nationa
character nchar.
CREATE OR REPLACE PROCEDURE Create_Customer(
v-custnum IN customers.cust_num%TYPE,
v_name IN customers.cust_name%TYPE,
v_address IN customers.cust_address%TYPE)
AS
BEGIN
INSERT INTO customers
VAlUES(v-custnum,v_name,v_address);
END;
/ |
|
f*********n
发帖数: 11154 | 4 来自主题: GunsAndGears版 - DEAL? 这个算上运费也就是2毛一发，只要你不在乎给你的AR上钢壳弹。
productnumber=119442&cm_cat=Clearance&cm_ite=Product3&cm_lm=sp:mvpsoccer@l
ive.com&cm_ven=Spop-Email&cm_pla=Clearance_104201116_1&CustNum=102443555 |
|
|
