how to procedure for joins - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to procedure for joins

Author

Topic

gnanasekar
Starting Member

6 Posts

Posted - 2011-08-17 : 07:11:34

select ename,jobtitle
from
employee,job
where
employee.empno=job.empno(+);

THIS IS SQL STATEMENT.HOW CAN CREATE PROCEDURE FOR THIS
AND
cursor c1
is select salary from employees;
begin
open c1;
fetch c1 into i;
if c1% isopen
then
dbms_output.put_line('opened');
else
dbms_output.put_line('closed');

close c1;
end;

declare
i varchar2;
cursor c1 is
select salary from employees;
begin
loop
open c1;
if c1%isopen then
dbms_output.put_line('opened');
else
dbms_output.put_line('closed');
endif
close c1;
end;

THIS IS MY CURSOR PROGRAM HOW CAN I EXE WITH PROCEDUR
HELP ME TO CREATE PROCEDURE FOR THIS TWO PROGRAMS....

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2011-08-17 : 07:33:02

Are you working with Microsoft SQL Server as this is not T-SQL?

If not, I think you might want to find a relevant forum for you DBMS..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources