Data storage spaces in varchar2

Posted on 16th Feb 2014 07:03 pm by admin

Trying to understand what's happening.
I am selecting a value from a table that is defined as char(16) and placing in a new table defined as varchar2(50).
If the data that I select contains spaces, ie "1234........0001" (where dot represents space), I am curious how this is stored by Oracle.
The reason I ask is because when I extract the varchar2 field out to a cvs file in contains a tab (chr 9) instead of all of the spaces.
Please explain this behavior.
Thanks

Your Answer:

Login to answer

Other forums

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for

CHMOD script
Hi,

I need a script to read all files in a folder and set to 777.

Can anyone help out

Not sure why this script is not working?
Hi I am new to php programing and I was trying to make up a simple script like a captcha but I canno

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

Unable to customise toolbar in FCK
onClick='location.href=index.htm'> not working
Below is my code:

echo "<input type='button' value='redirect' onClick='location.h

output printing as hexadecmal... XD
Everything works except the calcem call for the totusold and totuprice. The out put shows up as hex.

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

classic dynpro : hide area and auto adjust hights
Hi,

I want to develop a similar user interface as is used in standard transaction MIGO.