Answer / kiran

CREATE [OR REPLACE] FUNCTION function_name
[(parameter_name [IN | OUT | IN OUT] type [, ...])]
RETURN return_datatype
{IS | AS}
BEGIN
< function_body >
Return value()
END [function_name];

Answer / tulsi

FUNCTION name (argument list .....) Return datatype is
local variable declarations
Begin
executable statements
Exception
execution handlers
End;

What is trigger and how to use it in sql?

0 Answers  

---

Can you have a foreign key without a primary key?

0 Answers  

---

how to include comments in sql statements? : Sql dba

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

what are Dynamic SQL statements?

9 Answers  

---

What are the two different parts of the pl/sql packages?

0 Answers  

---

How do I save a sql query?

0 Answers  

---

What is java sql drivermanager?

0 Answers  

---

What is dml statement?

0 Answers  

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---

What are sql data types?

0 Answers  

---

What is user in sql?

0 Answers  

---