top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What DBMS package should I use to manipulate the long column in Oracle 7

+1 vote
294 views
What DBMS package should I use to manipulate the long column in Oracle 7
posted Nov 24, 2014 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

You cannot use PL/SQL. You have to use OCI calls to do this and Oracle has a great tech note on this. It is located in our PL/SQL development section at

answer Nov 26, 2014 by Arun Gowda
Similar Questions
+1 vote

I have a Time column in my SQL Server table which has data like (14:00:00.0000000).

I am trying to load this type of data in Oracle table which has corresponding column datatype as timestamp. I am trying to convert the time column in SQL server to timestamp column in oracle using Informatica.

Whats the best way to do it?

0 votes

Why should I not commit after every record when updating a large table Committing after every record does not hurt but its much efficient to commit after a batch of records like 5000 - 7000.

...