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;

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

0 Answers  

---

How to create an oracle database manually?

0 Answers  

---

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

What is currency type in database ?

3 Answers   TCS,

---

What is a data dictionary and how can it be created?

0 Answers  

---

How to select an oracle system id (sid)?

0 Answers  

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---

Which Department has MOST NUMBER of employees?

8 Answers   IBM, LeadSquared, Mastek,

---

In Oracle 9i what does "i" Stands for?

36 Answers   MBT,

---

How can I combine multiple rows into a comma-delimited list in oracle?

0 Answers  

---

What language does oracle use?

0 Answers  

---

What is background process in Oracle?

0 Answers   MCN Solutions,

---