What is difference between Rename and Alias?

Q

✍: Guest

A

Rename is actually changing the name of an object whereas Alias is giving another name (additional name) to an existing object.

Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.

2011-12-22, 5530👍, 0💬

What is difference between SUBSTR and INSTR?
What is difference between SUBSTR and INSTR? INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence. SUBSTR function return a portion of string, beginning at character position, substring_le... 2011-12-19, 4989👍, 0💬

What is Web Listener ?
What is Web Listener ? Web Listener is Web Server listener which is listening for web Services(HTTP) request. This listener is started by adapcctl.sh and defined by directive (Listen, Port) in httpd.conf for Web Server. When you initially type request like http://becomeappsdba.blogspot. com:80to acc... 2011-12-27, 4233👍, 0💬

What is difference between ICM, Standard Managers and CRM in Concurrent Manager ?
What is difference between ICM, Standard Managers and CRM in Concurrent Manager ? # ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks and try to restart them. You can say it as administrator to other concurrent managers. It has othe... 2011-12-19, 4115👍, 0💬

How to start Applications listener ?
How to start Applications listener ? In Oracle 11i, you have script adalnctl.sh which will start your apps listener. You can also start it by command lsnrctl start APPS_$SID (Replace sid by your Instance SID Name) 2011-12-26, 3981👍, 0💬

What are various joins used while writing SUBQUERIES?
What are various joins used while writing SUBQUERIES? =, , IN, NOT IN, IN ANY, IN ALL, EXISTS, NOT EXISTS. 2011-12-23, 3964👍, 0💬

What is difference between UNIQUE and PRIMARY KEY constraints?
What is difference between UNIQUE and PRIMARY KEY constraints? An UNIQUE key can have NULL whereas PRIMARY key is always not NOT NULL. Both bears unique values. 2011-12-22, 3939👍, 0💬

How to confirm if Apps Listener is Up and Running ?
How to confirm if Apps Listener is Up and Running ? execute below command lsnrctl status APPS_$SID (replcae SID with your Instance Name) so If your SID is VISION then use lsnrctl status APPS_VISION out put should be like Services Summary... FNDFS has 1 service handler(s) FNDSM has 1 service handler(... 2011-12-26, 3927👍, 0💬

What is difference between SQL and SQL*PLUS?
What is difference between SQL and SQL*PLUS? SQL is the query language to manipulate the data from the database. SQL*PLUS is the tool that lets to use SQL to fetch and display the data. 2011-12-20, 3909👍, 0💬

What is use of Applications listener ?
What is use of Applications listener ? Apps Listener usually running on All Oracle Applications 11i Nodes with listener alias as APPS_$SID is mainly used for listening requests for services like FNDFS and FNDSM. 2011-12-23, 3824👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.