Home » SQL & PL/SQL » SQL & PL/SQL » COLLATE
COLLATE [message #214156] Mon, 15 January 2007 03:21 Go to next message
bahy91
Messages: 91
Registered: September 2005
Location: Amsterdam
Member
Hi Everyone,
In SQL Server, a character set can be defined in column level using the clause COLLATE. Is there any way in Oracle to define a character set in column level.

Eg :

SQL Server DDL :

create table test(col1 varchar(20) COLLATE <collation_name>)

Thanks in Advance,
bahaa
Re: COLLATE [message #214161 is a reply to message #214156] Mon, 15 January 2007 03:52 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

No you cant.

SqlServer and Oracle have a different approach for this.
Which you can read about here



Re: COLLATE [message #214166 is a reply to message #214161] Mon, 15 January 2007 04:22 Go to previous message
bahy91
Messages: 91
Registered: September 2005
Location: Amsterdam
Member
Thanks a lot,
for your help..



thanks in advance,
bahaa
Previous Topic: How to print space before a number
Next Topic: SQL Querry to return database columns which got updated
Goto Forum:
  


Current Time: Wed Dec 07 06:29:55 CST 2016

Total time taken to generate the page: 0.10516 seconds