Oracle中如何实现字符串的连接？(50分)

W

wlandll

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-17

• #1

Oracle中如何实现字符串的连接？
我用 update myTable set ManagID='0'+ManagID
ManagID的值是 23
我要的结果是023

结果Oracle将ManagID当作数字来相加了，结果还是23

 

B

babyboom

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-17

• #2

update myTable set ManagID='0'||ManagID

 

W

wlandll

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-17

• #3

谢谢babyboom，OK了，分已给出！