convert为什么报错?

[tian790317]

select convert('abc',NCHAR(40),char) from dal

或是oracle中convert怎么用,给出个具体例子`

[robin_ares]

oracle里convert 是字符转码函数 ，
比如SELECT CONVERT('数据库','UTF8') from dual
和你想要的类型转换搭不上边

[小灰狼W]

select cast('abc' as char(10)) from dual

用cast 来转换类型

[xiaozhangnima]

这个来学习

[cosio]

没有这个函数,这个函数是MS SQL


select to_char('abc') from dual;

[cosio]

CONVERT 

SYNTAX: 

    CONVERT(char, dest_char_set [,source_char_set] ) 

PURPOSE: 

    Converts a character string from one character set to another. 

    The char argument is the value to be converted. 

    The dest_char_set argument is the name of the character set to which 
    char is converted. 

    The source_char_set argument is the name of the character set in 
    which char is stored in the database.  The default value is the 

    database character set. 

    Both the destination and source character set arguments can be 
    either literals or columns containing the name of the character set. 

    For complete correspondence in character conversion, it is essential 
    that the destination character set contains a representation of all 
    the characters defined in the source character set.  Where a 
    character does not exist in the destination character set, a 

    replacement character appears.  Replacement characters can be 
    defined as part of a character set definition. 

Common character sets include: 

US7ASCII 
    US 7-bit ASCII character set 
WE8DEC 
    DEC West European 8-bit character set 
WE8HP 
    HP West European Laserjet 8-bit character set 
F7DEC 
    DEC French 7-bit character set 
WE8EBCDIC500 
    IBM West European EBCDIC Code Page 500 

WE8PC850 
    IBM PC Code Page 850 
WE8ISO8859P1 
    ISO 8859-1 West European 8-bit character set 

EXAMPLE: 

    SELECT CONVERT('Grob','WE8HP','WE8DEC') "Conversion" 
    FROM DUAL 

    Conversion 
    ---------- 
    Grob 

[dawugui]

[Quote=引用楼主 tian790317 的回复:]
select convert('abc',NCHAR(40),char) from dal

或是oracle中convert怎么用,给出个具体例子`

[/Quote]
如果是abc,不需要转.直接使用.

另convert是ms sql的函数,oracle中转换字符串的函数是:to_char.

因为'abc'本身已经是字符串,不需要转换.

[Dave]

Oracle确实没有convert函数，只有to_char() 和 to_date()...

sql: CONVERT(VARCHAR(10),GETDATE(),111)
oracle: to_char(sysdate,'yyyy/mm/dd')

[数据娃掘]

convert 是字符转码函数

[zswangg]

oracle中转换字符串的函数是:to_char.