Answer Posted / pradeep aryan

hi this is Sql server Statement:

Create table findSalary(salay int)

-- create procedure
Create proc stp_testdata
as
begin
select * from findsalary
end
-- Create function
create function Function4()
returns varchar
as
begin
return 'test data'
end
-- insert command
insert into findsalary values (89)


this is working fine

How much does sql certification cost?

1088

---

What is sql mysql pl sql oracle?

1070

---

What is update query?

980

---

What is pl sql record in oracle?

1034

---

how do you tune the slow running queries in oracle db , explain the methodology

2775

---

Explain the steps needed to create the scheduled job?

1038

---

Does asenumerable execute the query?

1043

---

How to read/write files from pl/sql?

1035

---

What is a record in a database?

1062

---

What are the 3 types of behavioral triggers?

1251

---

Can we rollback delete command?

984

---

How many subqueries can be nested in a statement?

982

---

How can get second highest salary in sql?

988

---

Can we create a trigger on view?

895

---

How much does sql cost?

998

---