See this post in these very forums.

Gints Plivna

http://www.gplivna.eu

Most probably the problem is that DTS is creating case sensitive table names, but if you fire select in Oracle without double qoutes it assumes table names are in uppercase.

So...

One cannot test his actual driving skills without actual car as well as one need installed Oracle server to create Oracle database and get it up and running. You can...

If you look closer at it you'll find that it contains <br>, which obviously is redundant.

Gints Plivna

http://www.gplivna.eu

Usually such questions are better to ask on target platforms, because they like converts to them much more than converts from them 🙂

One of the tools is Migration workbench.

And here...

Assuming this is Oracle because written in _Oracle_ category in SQL Server forums, so:

SQL> with a as (

2 select '9:34' col from dual

3...

If you are running this as a script in Oracle then aftre initial Begin Oracle is waiting for anonymous block i.e. some pl/sql constructions. You don't need any BEGIN/END for...

It is always worth to look in Oracle docs CASE Expressions

Gints Plivna

http://www.gplivna.eu

I can only estblish a fact that you are suffering from high factor of data waste 😉

Gints Plivna

http://www.gplivna.eu

At least I didn't understood where (Oracle or MS SQL) you have to do these updates and what kind of updates... OK assuming this is almost Oracle forum 😉 you...

How about reading this very thread from this very forum?

Gints Plivna

http://www.gplivna.eu

Jeff Moden (2/15/2008)

---

You've exemplified exactly what I was talking about, Gints... doesn't really matter what people think of one or the other, they are very different and anyone who thinks...

Yea such people has...

JohnG (2/14/2008)

---

Heh... thanks Steve... I'll consider it. It would be very difficult, though, because I break out in a bad case of Tourette's syndrome every time I try to do...

Hmm cannot see any...