这样的sql server存储过程用oracle怎么写呀！

Question

SET NOCOUNT ON 是什么作用？

Answer 1

CREATE PROCEDURE GetCustomerByEmail is
    Email NVARCHAR(50) := NULL;
begin    SELECT c.PKId,
           c.Email,
           c.Password,
           c.Name,
           a.Address,
           a.Country,
           a.PhoneNumber,
           a.Fax
      FROM Customers c, 
           Addresses a
     WHERE c.Email = Email 
       AND a.CustomerId = c.PKId
end;

Answer 2

CREATE PROCEDURE GetCustomerByEmail(Email NVARCHAR(50):=NULL) is 
begin
    exec immediate 'SELECT c.PKId,
           c.Email,
           c.Password,
           c.Name,
           a.Address,
           a.Country,
           a.PhoneNumber,
           a.Fax
      FROM Customers c, 
           Addresses a
     WHERE c.Email = '||Email ||'
       AND a.CustomerId = c.PKId'    RETURN 0
end GetCustomerByEmail;

Answer 3

to  LGQDUCKY(飘) 
SET NOCOUNT ON 在SQL中就是不显示查询的信息，有点类似set serverout off

Answer 4

哦！好，谢谢！    SELECT c.PKId,
           c.Email,
           c.Password,
           c.Name,
           a.Address,
           a.Country,
           a.PhoneNumber,
           a.Fax
      FROM Customers c, 
           Addresses a
     WHERE c.Email is null
       AND a.CustomerId = c.PKId这条语句得使用游标来取

Answer 5

不知道你们看过Ｃ＃.net自带的哪个书店程序没有。用的是sql server我想把数据库移植到oracle中来，所以正在学习。

Answer 6

SQL> CREATE PROCEDURE GetCustomerByEmail(Email NVARCHAR(50):=NULL) is
  2  begin
  3      exec immediate 'SELECT c.PKId,
  4             c.Email,
  5             c.Password,
  6             c.Name,
  7             a.Address,
  8             a.Country,
  9             a.PhoneNumber,
 10             a.Fax
 11        FROM Customers c, 
 12             Addresses a
 13       WHERE c.Email = '||Email ||'
 14         AND a.CustomerId = c.PKId'
 15  
 16      RETURN 0
 17  end GetCustomerByEmail;
 18  /警告: 创建的过程带有编译错误。SQL>

Answer 7

我的目的就是把duwamish的所有存储过程，转换成oracle的。并且可以运行。