Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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

What is basic structure of pl sql?

0 Answers  

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

How many sql are there?

0 Answers  

What are the types of variables use in pl sql?

0 Answers  

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

What is type and rowtype in pl sql?

0 Answers  

What is the syntax and use of the coalesce function?

0 Answers  

Is oracle and sql same?

0 Answers  

Can we write dml inside a function in sql server?

0 Answers  

How to rename a column in the output of sql query?

0 Answers  

What are the two parts of design view?

0 Answers  

What is compound trigger?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories