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 before trigger?

0 Answers  

---

What is cursor and why it is required?

0 Answers  

---

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

---

How do you truncate?

0 Answers  

---

What are inner outer left and right joins in sql?

0 Answers  

---

What is pl sql architecture?

0 Answers  

---

what is the cursor and use of cursor in pl/sql ?

4 Answers  

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

what are the join types in tsql? : Transact sql

0 Answers  

---

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

Explain the uses of database trigger.

0 Answers  

---

what is an associative array with example?

1 Answers  

---