Oracle Equivalent of SQL Server Syntax

oracleoracle-11g-r2

I'm looking for the Oracle equivalent of the following SQL Server syntax:

select Cast(0x41424344 as varchar(max))

In SQL Server, it selects 'ABCD'.

0x41424344 is the hex of 'ABCD'

Best Answer

SQL> select utl_raw.cast_to_varchar2('41424344') from dual;

UTL_RAW.CAST_TO_VARCHAR2('41424344')
------------------------------------
ABCD

Related Solutions

Sql-server – Does SQL Server 2008 have an equivalent to Oracle’s “table%rowtype” syntax or (Data Type)

No version of SQL Server has this. It would be useful (PostreSQL has the same and I like it).

In SQL Server, there are table types (CREATE TYPE), temporary tables (CREATE TABLE #foo) and table variables (DECLARE @var TABLE), but you can't mimic or inherit a table definition using %TYPE or CREATE TABLE .. INHERITS/OF

SQL Server – Equivalent of Oracle USING INDEX Clause

Is there a SQL Server 2008 equivalent of the USING INDEX clause in Oracle?

No. When you create a primary key or unique constraint in SQL Server, a unique index to support that constraint is created automatically, with the same keys.

Which seems to imply that there is a way of specifying what index should be used for a Primary Key.

No. The documentation is only attempting to explain whether the automatic supporting index will be created as clustered or nonclustered, if you do not specify. It is confusingly worded, I agree.

To clarify, when you add a primary key constraint to an existing table without expressing a preference, the supporting index will be clustered if there is no pre-existing clustered index on the table. The supporting index will be created as nonclustered if there is already a clustered index

You can specifically request a clustered or nonclustered primary key using: PRIMARY KEY CLUSTERED or PRIMARY KEY NONCLUSTERED.

In fairness, the documentation is much clearer on the subject at:

table_constraint (Transact-SQL)

Best Answer

Related Solutions

Sql-server – Does SQL Server 2008 have an equivalent to Oracle’s “table%rowtype” syntax or (Data Type)

SQL Server – Equivalent of Oracle USING INDEX Clause

Related Question