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 Data Concarency and Consistency?

1 Answers  

---

What does rownum mean in sql?

0 Answers  

---

wtite down triggr not any entry on Sunday

2 Answers   NIT,

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

How to select all records from the table?

0 Answers  

---

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

Can we have two clustered index on a table?

0 Answers  

---

Are sql connections encrypted?

0 Answers  

---

Is sql a backend language?

0 Answers  

---