create a store procedure and created synonms for that store procedure after mod

create a store procedure and created synonms for that store
procedure after modify that store procedure will effect on
synonms?
If we delete the store procedure what happened to that synonms?

Question Posted / shivainduja

2 Answers
7544 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

create a store procedure and created synonms for that store procedure after modify that store proce..

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.

Is This Answer Correct ?

5 Yes

0 No

create a store procedure and created synonms for that store procedure after modify that store proce..

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.

Is This Answer Correct ?

1 Yes

4 No

Post New Answer

More SQL PLSQL Interview Questions

Why do we need cursor in pl sql?

0 Answers

How many triggers can be applied on a table?

0 Answers

What is the current version of postgresql?

0 Answers

Why do we need unique key in a table?

0 Answers

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers Doyensys, Infosys, Metric Stream,

How to execute OS(operating system) command from pl/sql?

3 Answers

How do you concatenate in sql?

0 Answers

What information is needed to connect sql*plus an oracle server?

0 Answers

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers TCS,

Explain dml and ddl?

0 Answers

What is the basic difference between a sql and stored procedure ?

2 Answers L&T,

Which command is used to delete a package?

0 Answers

For more SQL PLSQL Interview Questions Click Here