Lpad and Rpad?

[Ale]

can we use Lpad() or Rpad() in insert statement?.............

if yes, kindly help me out with the query.....

[debasisdas]

Kindly post the query that that you are trying to execute with the mentioned functions.

[Ale]

Kindly post the query that that you are trying to execute with the mentioned functions.

we can use rpad() in the select statement........

for Ex: select lpad(cust_code,5,'0') from customer;

I've generated a sequence for the column cust_code in the table....startin with 1 and so on....,now after executing the above query....we get....

00001
00002
00003
.
.
.

my question is....can we directly pad them and insert in to the table, rather than selecting it...storing it in some variable....and thn inserting it as a string???

[debasisdas]

Yes you can directly use both of those functions in insert statment.