What is Synonyms?
Submitted by: AdministratorSynonyms is the alias name for table, views, sequences & procedures and are created for reasons of Security and Convenience.
Two levels are Public - created by DBA & accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifying the owner and Flexibility to customize a more meaningful naming convention.
Submitted by: Administrator
Two levels are Public - created by DBA & accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifying the owner and Flexibility to customize a more meaningful naming convention.
Submitted by: Administrator
Read Online SQL and PL/SQL Job Interview Questions And Answers
Top SQL and PL/SQL Questions
| ☺ | The IN operator may be used if you know the exact value you want to return for at least one of the columns. |
| ☺ | What is the use of CASCADE CONSTRAINTS? |
| ☺ | What is Posting? |
| ☺ | What is Character Functions? |
| ☺ | What is the SQL? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
