cancel
Showing results for 
Search instead for 
Did you mean: 

Use of Native SQL

Former Member
0 Kudos

Can i use all sql statementsa which are used in oracle ? Basically I am more interested in oracle data conversion functions like to_date(),To_Char() with appropriate formats.

I know that to use oracle's native commands i have to use Native SQL and for that i have to write my query between EXEC SQL and ENDEXEC. But i am not able to use query that uses date conversion fuctions like to_date() and to_char().

Also i want to know the list of SQL statements which can be used with Native SQL in Oracle.

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

HI Deval,

> Can i use all sql statementsa which are used in

> oracle ? Basically I am more interested in oracle

> data conversion functions like to_date(),To_Char()

> with appropriate formats.

Yes you may use these (and any other functions) within native SQL.

The "correct" format pattern depend on what you want as output. Best source would be the oracle documentation,

> I know that to use oracle's native commands i have to

> use Native SQL and for that i have to write my query

> between EXEC SQL and ENDEXEC. But i am not able to

> use query that uses date conversion fuctions like

> to_date() and to_char().

Why can't you use them? Any error messages?

Show us your code and the error message - it will be much easier than to help you.

KR Lars

> Also i want to know the list of SQL statements which

> can be used with Native SQL in Oracle.