This discussion is archived
1 Reply Latest reply: Jun 10, 2011 12:20 AM by mkirtley-Oracle RSS

During migraton how to handle  temp table of sqlsrvr 2005

867407 Newbie
Currently Being Moderated
hi all

i hav migrated full database to oralce
in procedures i m facing errors

i want to know how to handle with temporary table of sql server 2005
???????

AND
How to solve >>>>>

(In SQLSERVER 2005)

COde--

CASE tLogin WHEN '01-Jan-1900'
THEN Space(0)
ELSE
----
I have to translate into (ORACLE pl/sql)


----------
can any one give me solution for this?????????



thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points