Answer Posted / 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;

What is the difference between online and offline backups?

560

---

Can we insert data in view oracle?

531

---

How to execute a stored procedure in oracle?

618

---

Please explain oracle data types with examples?

584

---

What is Undo Management Advisor in Oracle?

609

---

---

What is a connect identifier?

536

---

How to drop an index in oracle?

601

---

How do I know if oracle client is installed on windows?

494

---

What is user managed backup in Oracle?

610

---

How do I escape a reserved word in oracle?

624

---

What is key preserved table?

558

---

How to display row numbers with the records?

584

---

What are the differences between blob and clob in oracle?

580

---

How to list all tables in your schema?

604

---

How do I connect to oracle?

559

---