Answer / ankush

A synonym is an alternative name for objects such as
tables, views, sequences, stored procedures, and other
database objects.

So naming convention dose not effect the object if the
object code is update or modify.


The synonym exists in the datbase but it is in a invalid
state.

Answer / shivaindu

If you update in store procedure it will not effort in synonyms.

If we delete the store procedure that synonyms will not
delete but it won’t work.

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

---

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

---

How to raise user-defined exception with custom sqlerrm ?

0 Answers  

---

scope of exception handling in plsql

4 Answers   Wipro,

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

How show all rows in sql?

0 Answers  

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---

What does closing a cursor do?

0 Answers  

---

What is a string data type in sql?

0 Answers  

---

How do you add a column to a table?

0 Answers  

---