i am trying to use rpad to pad the string with a blank space. i tried this
vNamesp := RPAD(' ',2*(i.LEVEL-1),'  ');
but it is not taking the   as a 'blank space' its adding just...
http://www.experts-exchange.com/Database/Oracle/Q_20143477.html
Zones:
OracleDate Answered: 06/29/2001 Grade: B Views: 0
Hi
is there any equivalent function in MS SQL to Oracle's LPAD and RPAD?
say suppose I have field ID(varchar(10)) , I need to display in the following manner
ID
123********
12*******...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21062962.html
Zones:
MS SQL ServerDate Answered: 07/19/2004 Grade: B Views: 119
Hello Gurus,
I have following statment in my stored procedure. Each filed has to be padded with white space as per the file specs.
If i use rpad here then i have 16 more procedure and differ...
http://www.experts-exchange.com/Database/Oracle/Q_21308363.html
Zones:
OracleDate Answered: 03/19/2005 Grade: B Views: 0
Is it possible to RPAD/LPAD a null value string for spaces and if so what is the syntax? Example:
column NULL1 format a2
select
' ' as NULL1,
Is it possible to put rpad or lpad and the...
http://www.experts-exchange.com/Database/Oracle/Q_10299318.html
Zones:
OracleDate Answered: 02/24/2000 Grade: A Views: 72
Hi,
Well i m using a UTL_FILE package to generate text reports, and the columns of the reports is something of this sort.
My nls_lang is set to UTF-8.
| NAME(In Chinese) | Age (In Eng...
http://www.experts-exchange.com/Database/Oracle/Q_20320372.html
Zones:
OracleDate Answered: 09/14/2003 Grade: A Views: 23
Suppose I have a table
XXX
----
ABC VARCHAR2(10)
DEF VARCHAR2(20)
GHI NUMBER(10)
Can I use any Oracle tools to output the table data in a fixed format manner into a flat file. For examp...
http://www.experts-exchange.com/Database/Oracle/3rd_Party_Tools/Q_20594377.html
Hello all,
These scripts are in Oracle under a package.
3RD_TABLE1 is a 3rd party db (Pervasive)
UPDATE 3RD_TABLE1
SET FLD1 = FLD1 + 10
WHERE ORDER_NBR = RPAD(v_order, 30, ' ')
UPDA...
http://www.experts-exchange.com/Database/Oracle/Q_20654172.html
Zones:
OracleDate Answered: 07/10/2003 Grade: A Views: 0
Have any ideas on why the following code could be returning an empty recordset (I comfirmed that the database is in fact being connected to successfully) while the same command from oracle client d...
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_22003930.html
Zones:
FoxProDate Answered: 09/28/2006 Grade: A Views: 32
