1
  • DFU with VARCHAR fields?

    Can I use DFU to maintain VARCHAR fields in a table? If not, is there another easy utility that I can give users to add text to such a file?

    markhod5 pointsBadges:
  • How can I get the DDL of a column?

    How can I get the DDL of a column? Suppose I declared a column with varchar2(10). So I need to extract that length of varchar i.e 10.

    apsg112905 pointsBadges:
  • SQL7919 Data conversion error

    Hi, I have an embedded SQL program in which I generate an XML element as a VARCHAR(256). This is done via: select xmlserialize( xmlelement(NAME "Name", 'Something') as VARCHAR(256) ) as XmlResult from sysibm/sysdummy1 The SQL statement is run via sqlcursor and I fetch the result into a RPGLE...

    mathypaesen10 pointsBadges:
  • How to use convert data type from Oracle data time string to Oracle varchar2

    DB version: Oracle 10gR2 10.2.0.4 64 bit ogg version :11.2.1.0.1 Source db:PARAMETER VALUE ------------------------------ -------------------------------------------------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA...

    jasonliuwq5 pointsBadges:
  • Error In SQL SERVER DataBase

    am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : "True" to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ? pls help me. i am...

    SrimanBenivolent5 pointsBadges:
  • Converting date time in C#

    hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in C#, and save to...

    Zubairm765 pointsBadges:
  • Execute a view/query is slower in SQL Server 2005 than 2000

    Hi, I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index. When I run the following query "select top 500 * from myview order by name", it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50). Strangely...

    Db23290 pointsBadges:
  • How to create a command list of values in Oracle

    I've been trying to convert a single-columned subquery into a command-separated VARCHAR typed list of values. I understand how to do it on SQL Server but now I need to do it on Oracle. Can someone help me?

    ITKE434,490 pointsBadges:
  • Character limit for a column in an Oracle database

    I'm looking to store different postal codes in my Oracle database. I believe the column will be a VARCHAR2. I know the U.S. codes are 9 and Canadian codes are 7. Would 32 characters be efficient enough for the limit in the column? Or should I go higher? Thanks!

    ITKE434,490 pointsBadges:
  • Crystal Reports and varchar(MAX) not printing

    Hi All, I have a Crystal Reports report (VS2005 version) that prints a number of fields from a SQL table. When I print the report under Windows XP, everything works properly. When I print under Windows Vista on a tablet PC, the report prints, except for the varchar(MAX) field. Does anyone know a...

    Markchimes20 pointsBadges:
  • varchar(max) size limit

    I have defined a table field with datatype of varchar(max) but it only stores upto 8k characters, I thought (max) upped this limit to 2g character. How can I get it to store more than 8k characters?

    Niranjan5635 pointsBadges:
  • is varchar numeric

    sql to check varchar as numeric

    DuaneD5 pointsBadges:
  • Date formats and Microsoft Analysis Services

    How can we convert date format in analysis services form yyyy-mm-dd to dd-mm-yyyy without converting date to varchar Thanks

    C0sc0s15 pointsBadges:
  • Convert column from Number(9) to varchar2(3) in SQL

    What is the quickest way of achieving a total column datatype change from number(9) to varchar(3)? I have a few million rows in this table and SQL will run forever ....

    GeoMar5 pointsBadges:
  • DB2/400 field to match an Oracle VARCHAR?

    We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

    Michaelwpeak5 pointsBadges:
  • The difference between VARCHAR and NVARCHAR

    What is the difference between varchar and nvarchar?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Need help creating a specific Oracle View

    We have several tables with what would probably have been nested columns if that feature had existed when they were created. They are simple VARCHAR2 columns occurring a fixed number of times (2 to 4). Since they are often null, the true number is variable with a fixed maximum. Although we would...

    OracleATE190 pointsBadges:
  • Define array in Oracle

    i have coulumb stn varchar2(100) , i want to split it to 4 columbs n1 varcha2(20)...n4 varchar2(20) ,depend on space eg: stn : John Adms Smith Zac n1 : John n2 : Adms n3 : Smith n4 : Zac i use oracle8.0.5 developer6

    Tota10 pointsBadges:
  • Converting a varchar to a numberic in SQL query

    How can we convert a varchar field to Numberic in a SQL Query in db2 400?

    AS400 - Ask the Expert485 pointsBadges:
  • Replace a variable part of a string in a varchar2 field

    I have a vendor Oracle table containing data as follows column name: PVC_Value value = TRKCASETRK;6,0,0,0,0,0,0;;20801911;32004910;43175007;2,2;0;59647;1,30;0;0;3002 As you can see this field contains data delimited by semi-colons (for 13 elements) I need to relace the 7th and 10th elements in this...

    JoeA15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following