Home » SQL & PL/SQL » SQL & PL/SQL » Concat
Concat [message #3433] Thu, 26 September 2002 07:15 Go to next message
Will
Messages: 32
Registered: January 2000
Member
If I decided to use the concat function or the || for a string in my Select clause, is there a limitation on the string size?
(Oracle 8i database)

Thanks,
Will

Report message to a moderator

Re: Concat [message #3437 is a reply to message #3433] Thu, 26 September 2002 10:52 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
4000 bytes is the max string size in SQL.

Report message to a moderator

Previous Topic: rollback to savepoint in a package
Next Topic: Simple format column to 5 spaces question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 00:19:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.