Answer / sa123

Dont create any public synonym, then that is available only
for its owner

Answer / ankush

dont give any grant permission for the table except the
schema where the table is actually crearted.U can also use
a private synonym.. with in the schema to recognizing the
table with a dirrerent name.

Answer / swapna

Once table is created in your own schema that is only
visible to that schema. For others it is not visible.

what is ref cursor in pl/sql?

3 Answers  

---

Can we use having without group by in sql?

0 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

What are types of exception?

0 Answers  

---

What are sql procedures?

0 Answers  

---

find the third highest salary?

23 Answers  

---

what is union, minus and interact commands? : Sql dba

0 Answers  

---

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

How many sql statements are used?

0 Answers  

---

what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,

---

What is trigger explain with example?

0 Answers  

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---