Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

REPLLINES

The REPLLINES function replaces one or more lines in a multiline TEXT expression.

Return Value

TEXT or NTEXT

This function accepts TEXT values and NTEXT values as arguments. The data type of the return value depends on the data type of the values specified for the arguments:

Syntax

REPLLINES(text-expression lines [start])

Arguments

text-expression

A multiline text expression in which you want to replace one or more lines.

lines

A text expression that contains one or more lines that will replace existing lines in text-expression.

start

An integer that represents the line number at which to begin replacing. The position of the first line in text-expression is 1. When you omit this argument, REPLLINES starts with line 1. REPLLINES replaces as many lines of text-expression as are required for the specified new lines.

Examples

Example 20-27 Replacing a Text Line

This example shows how to replace the second line in a multiline TEXT value in a variable called mktglist.

The statement

SHOW mktglist

produces the following output.

Salespeople
Products
Services

The statement

SHOW REPLLINES(mktglist, 'advertising', 2)

produces the following output.

Salespeople
Advertising
Services