<![CDATA[Forum PostgreSQL - Kopiowanie danych z Oracle]]>
2009-07-15T11:14:54Z
PunBB
https://forum.postgresql.org.pl/viewtopic.php?id=251
<![CDATA[Odp: Kopiowanie danych z Oracle]]>
https://forum.postgresql.org.pl/profile.php?id=873
2009-07-15T11:14:54Z
https://forum.postgresql.org.pl/viewtopic.php?pid=1058#p1058
<![CDATA[Odp: Kopiowanie danych z Oracle]]>
https://forum.postgresql.org.pl/profile.php?id=873
2009-07-15T11:08:36Z
https://forum.postgresql.org.pl/viewtopic.php?pid=1057#p1057
<![CDATA[Odp: Kopiowanie danych z Oracle]]>
query("select numer,to_char(REGD,'YYYY-MM-DD'),to_char(plans,'YYYY-MM-DD'),
to_char(planf,'YYYY-MM-DD'),err_descr
from tabela");
while($row = $stmt->fetch(PDO::FETCH_NUM))
{
$pole=mb_convert_encoding($row[4],'win1250','UTF-8');
$pole=str_replace("\\",'-',str_replace("'",'-',$pole));
$stmp=$conn->query("INSERT INTO tabela1 (numer,reg_date,plan_s,plan_f,err_descr) VALUES
($row[0],to_date('$row[1]','YYYY-MM-DD'),to_date('$row[2]','YYYY-MM-DD'),to_date('$row[3]','YYYY-MM-DD'),'$pole')");
echo $row[0].' -- '. $row[1].' -- '. $row[2].' -- '. $row[3].' -- '. $row[4].'
';
}]]>
https://forum.postgresql.org.pl/profile.php?id=873
2009-07-15T11:06:43Z
https://forum.postgresql.org.pl/viewtopic.php?pid=1056#p1056
<![CDATA[Kopiowanie danych z Oracle]]>
query("select numer,to_char(REGD,'YYYY-MM-DD'),to_char(plans,'YYYY-MM-DD'),
to_char(planf,'YYYY-MM-DD'),err_descr
from tabela");
while($row = $stmt->fetch(PDO::FETCH_NUM))
{
$stmp=$conn->query("INSERT INTO tabela1 (numer,reg_date,plan_s,plan_f,err_descr) VALUES
($row[0],to_date('$row[1]','YYYY-MM-DD'),to_date('$row[2]','YYYY-MM-DD'),to_date('$row[3]','YYYY-MM-DD'),$row[4])");
echo $row[0].' -- '. $row[1].' -- '. $row[2].' -- '. $row[3].' -- '. $row[4].'
';
}]]>
https://forum.postgresql.org.pl/profile.php?id=873
2009-07-15T05:32:00Z
https://forum.postgresql.org.pl/viewtopic.php?pid=1055#p1055