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 redo log?

1112

---

How to define a record variable to store a table row?

1111

---

What is the difference between count (*), count (expression), count (distinct expression)?

1046

---

what is the scripts in data base?

2219

---

What is dual table oracle?

1029

---

What happens to the current transaction if the session is killed?

1033

---

What is the usage of analyze command in oracle?

1140

---

What is the use of oracle?

1075

---

Explain enable novalidate constraint.

1131

---

How to run create database statement?

1075

---

Is oracle a language?

987

---

What are the common oracle dba tasks?

1201

---

What is a database schema in oracle?

1150

---

Explain the use of online redo log files in oracle.

1077

---

How to login to the server without an instance?

1213

---