Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Newbie Oracle-->ANSI SQL Questons

Status
Not open for further replies.
Bob12

Bob12

Programmer
Jan 4, 2002
4
US
I'm just starting work on converting Oracle to Teradata, which supports ANSI syntax. I have some very specific &quot;how to&quot; questions on converting widely used Oracle functions. How do you convert these: TRUNC, ROUND, LEAST, GREATEST, SIGN? If you know of a detailed Oracle<->ANSI SQL translation document that would help.

Thanks!
 
Sort by date Sort by votes
Hi Bob12

I recently ended a DBA role for a 130G single node Teradata RDBMS V2R3. If you could give me some specific sql examples I could help with it. Will however look for equivalent Teradata functions to your query and inform you of the same

What kind of a configuration do you work with?

Regards
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
146
carp
carp
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
117
JarlH
JarlH
jm89
  • Locked
  • Question
Does this function follow ansi sql standard? 1
Replies
4
Views
121
JarlH
JarlH
soushi01
  • Locked
  • Question
Nested For Loop update statement (pl/sql) 1
Replies
2
Views
116
soushi01
soushi01
Jewel142
  • Locked
  • Question
Newbie to Sql Subqueries
Replies
3
Views
95
Jewel142
Jewel142

Part and Inventory Search

Sponsor

Back
Top