Answer / ali

Alias is the temporay name , where as rename is the permanent given.

RENAME:
1. RENAME OLD_TABLENAME to NEW_TABLENAME;
2. alter table table_name rename column column_name to new_columnname;

ALIAS:
1. select ename as name from table_name1 as empl1, table_name2 as empl2 where empl1.id = empl2.id;

Can group functions be used in the order by clause in oracle?

0 Answers  

---

It's Urgent? How to IMPORT .xls & .txt file into ORACLE?

5 Answers  

---

What is a Database instance ? Explain?

3 Answers  

---

What is index-organized table in Oracle?

0 Answers   MCN Solutions,

---

How to display First 4 rows From Database Table?

6 Answers  

---

---

What is difference between sid and service name in oracle?

0 Answers  

---

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

2 Answers  

---

What is recovery manager in Oracle?

0 Answers   MCN Solutions,

---

how to we delete a row using varray

3 Answers   CTC,

---

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

4 Answers   Microsoft, Wipro,

---

How to create id with auto_increment on oracle?

0 Answers  

---

What are the different types of trigger and explain its various uses and functions?

0 Answers  

---