Varchar2 and Oracle quick question

Posted by DAVID on Stack Overflow See other posts from Stack Overflow or by DAVID
Published on 2010-04-26T01:17:02Z Indexed on 2010/04/26 1:23 UTC
Read the original article Hit count: 327

Filed under:

varchar2

|

empty

|

spaces

Hi guys im using varchar2 for a product name field, but when i query the databa from the run SQL command line it shows too many empty spaces, how can i fixe this withouth changing the datatype

here is the link to the ss

http://img203.imageshack.us/img203/20/varchar.jpg

© Stack Overflow or respective owner

Related posts about varchar2

Ibator didn't generate Oracle varchar2 field

as seen on Stack Overflow - Search for 'Stack Overflow'
I have table APP_REQ_APPROVE_COMPARE with following fields: "ID" NUMBER NOT NULL ENABLE, "TRACK_NO" VARCHAR2(20 BYTE) NOT NULL ENABLE, "REQ_DATE" DATE NOT NULL ENABLE, "OFFCODE" CHAR(6 BYTE) NOT NULL ENABLE, "COMPARE_CASE_ID" NUMBER NOT NULL ENABLE, "VEHICLE_NAME"… >>> More
(PL/SQL)Oracle stored procedure parameter size limit(VARCHAR2)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, there. I have an problem with my oracle stored procedure as following. codes : CREATE OR REPLACE PROCEDURE APP.pr_ap_gateway ( aiov_req IN OUT VARCHAR2, aov_rep01 OUT VARCHAR2, aov_rep02 OUT VARCHAR2, aov_rep03 OUT VARCHAR2, aov_rep04 OUT VARCHAR2… >>> More
Replace CHAR with VARCHAR2

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I replace CHAR with VARCHAR2 in all tables in a schema? Note: I'm content with a query that returns the ALTER TABLE statements so I can save the script and run it again. >>> More
How do you Send More that 20 Parameters to a Stored Procedure Using ODP.Net?

as seen on Stack Overflow - Search for 'Stack Overflow'
Switching from Microsofts Oracle Driver to ODP.NET version 10.2.0.100. After changing the data types to OracleDBTypes in a procedure, that worked perficetly using System.Data.OracleClient, the procedure fails if we try and pass in more that 20 parameters. The error returned is: ORA-06550: line… >>> More
Using Pragma in Oracle Package Body

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to create an Oracle Package and two functions in it: A public function ( function_public ) and a private one ( function_private ). The public function calls the private one. I'd like to add the same pragma to the functions: WNDS, WNPS. Without the pragma I can create a code like this: CREATE… >>> More

Related posts about empty

how to save and load the state of a game in scheme

as seen on Programmers - Search for 'Programmers'
I'm creating the game of chess in scheme, but do not know how to save and load game state is a part I have this code (define-struct ficha(color se-movio? tipo-ficha )) ;;tablero lista de listas de fichas (define-struct estado (tablero turno fichaSel)) (define bpawn (bitmap "b-peon.png")) (define… >>> More
Database Memory :: MySql Innodb how much storage memory allocation for empty field vs not empty fie

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I new in database, and dont know how and when mysql allocate memory space. In MySql Innodb how much storage memory allocation for empty field (no string inserted) vs not empty field? Other form of my question: When memory allocated space In MySql Innodb for varchar/text field in time of… >>> More
When using c:if test="${empty command.propertyList}" and c:if test="${not empty command.propertyList

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I use the following markup to generate a collection of elements <c:if test="${empty command.materialList}"> <span>It has been evaluated</span> more code... </c:if> <c:if test="${not empty command.materialList}"> <span>It has been evaluated</span> … >>> More
Read empty values as empty and not as default values

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How to read the empty values from the "dbf" file in C#. Currently while reading the dbf files, the empty values in the file are automatically getting converted to default values. Like empty decimal field is converted to "0.000". Can someone please help in way to read the empty fields as they are… >>> More
Checking for empty arrays: count vs empty

as seen on Stack Overflow - Search for 'Stack Overflow'
This question on 'How to tell if a PHP array is empty' had me thinking of this question Is there a reason that count should be used instead of empty when determining if an array is empty or not? My personal thought would be if the 2 are equivalent for the case of empty arrays you should use empty… >>> More