Interested to Buy Any Domain ? << Click Here >> for more details...
Why do we need to create an alias if we can directly use
the table name? What are the benefits of referring a table
name by its alias?
Also, when should we go for alias and when for synonyms?
- 1 Answers
- 4129 Views
- I also Faced
- E-Mail Answers
Answer / siva
let us consider we have a database with no of tables and one table name is ComputerScienceAndEngineering_Departement
if any one want to access this table they should use full name
ex: select * from ComputerScienceAndEngineering_Departement ;
it may be difficult to someone and sometimes to us also .
so if we creating alias like csedept then it will become simple to access it.
An alias is simply an alternate name for a table or view. Like tables and views, an alias can be created, dropped, and have comments associated with it.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is parm utility
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What should be specified along with a cursor in order to continue updating process after commit?
I use CS and update a page. Will the lock be released after I am done with that page?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What does reorg do in db2?
What is a synonym ?
What is db2? Explain.
What is DB2 (IBM Database 2)?
What is package versioning? Please give an example.
what is a trigger and types of triggers
What is the use of predicate?
COBOL 
