![]() |
|||
|
![]() |
||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
![]() |
|
Looking for the original pages? (formerly called "Morgan's Library") You can find them here.
![]() Term: REPLACE
Definition: REPLACE ([string], [string to replace], [replacement string] ) Example Usage: The SQL queries below demonstrate the use of REPLACE as character function. SQL> SELECT REPLACE('WWW.PSOUG.ORG','W','X') FROM DUAL; 2. As a Keyword in Object Definitions REPLACE is an optional keyword used in object definitions (DDL) to override the older objet definition with a new one. It retains the access privileges of the object during the definition modification process. If the object is dropped and recreated, however, its privileges are lost. Example Syntax: CREATE [OR REPLACE] [PROCEDURE | FUNCTION | TRIGGER | PACKAGE | TYPE ] [NAME] [IS |AS] Example Usage: The CREATE statement below creates a procedure P_GET_SAL using the REPLACE option. CREATE OR REPLACE PROCEDURE P_GET_SAL Related Links:
Related Code Snippets:
![]() |
![]() |
Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us | 19 users online © 2009 psoug.org |