Обсуждение: Problem in Porting from Oracle to Postgres SQl

Поиск
Список
Период
Сортировка

Problem in Porting from Oracle to Postgres SQl

От
Amit
Дата:
Hi! <p>I am facing two problems in porting from oracle to Postgres SQL. <p>1> There is a code in Oracle like
<p> <b>Type Tstate is table of number(9)</b><br /><b>    index by binary_integer;</b><br />. <br />........ <br />To
definea runtime table, basically it works like a array, How can it be possible in Postgres SQL, <br />I have tried
<b>createtemp table.</b>... But it not works.. <br />Is there any way to use arrays. <br />  <p>2> There is one
functionin Oracle <b>Executesql '...........'</b> to execute <br />    and what i got in Postgres is <b>Execute
immediate'.........'</b><br />    But it is giving error at Execute. <p>I will be very thankful if any one help me.
<p> Amit <br />( India )