Replace function Oracle Posted on September 24, 2012 by sqlandplsql Replace function replaces the string with another string if it matches. It is a character function in Oracle. Replace function is case-sensitive. Syntax:- REPLACE(‘input string’,’find_string’,’replace_string’);...
REPLACE and TRANSLATE are character function in Oracle. Replace function Translate function Both function looks similar but there are some subtle difference. We can say Translate is an extended version of Replace.
CREATE [OR REPLACE] FUNCTION [SCHEMA..] function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS [declaration_section variable declarations; constant declarations; ] BEGIN [executable_section PL/SQL execute/subprogram body ] [EXCEPTION]...
PL/SQL functions block create using CREATE FUNCTION statement. The major difference between PL/SQL function or procedure, function return always value where as procedure may or may not return value. When you create a function or procedure, you have to...
What is a database link? Database link is a named path through which a remote database can be accessed.
What is ROWID? ROWID is a pseudo column attached to each row of a table. It is 18 characters long, blockno, rownumber are the components of ROWI
What's Deadlock Deadlock is a unique situation in a multi user system that causes two or more users to wait indefinitely for a locked resource. First user needs a resource locked by the second user and the second user needs a resource locked by the first...
What is CYCLE/NO CYCLE in a Sequence? CYCLE specifies that the sequence continue to generate values after reaching either maximum or minimum value. After pan-ascending sequence reaches its maximum value, it generates its minimum value. After a descending...
What are the uses of MERGE? MERGE is used to combine multiple DML statements into one. Syntax : merge into tablename using(query) on(join condition) when not matched then [insert/update/delete] command when matched then [insert/update/delete] command
Explain the uses of Control File. It is a binary file. It records the structure of the database. It includes locations of several log files, names and timestamps. They can be stored in different locations to help in retrieval of information if one file...
