Oracle Database Discussions

In a SQL statement, select a, b, ' ' c...

Here, the field c is of char(101). There are two ways to do it:

1) put 101 blank spaces in-between ' '

2) use some function

I do not like 1). I prefer 2). But I do not remember the function (something like space(101)). But not so sure.


Thanks.

Scott

Message was edited by:
scottjhn