Have Geek Brain

Persistent request data type

I have an oracle table with one of the columns as a long raw type. I know that we cannot use sql to get data from this column.

Can anyone tell me how to get all the data from this column?

Thanks in advance

+1


a source to share


3 answers


Have you tried PL / SQL?



declare
  a mytable.rawcol%TYPE;
begin
  select rawcol into a from mytable;
  -- now do something with "a"
end;
/
+2


a source


You can ALWAYS use SQL to get data. In fact, this is the only way to get data in or out of the database. The question is what format the data appears in and what you do with it. Some SQL clients can handle binary data poorly. Some will show it as a hex stream (which is probably not very significant).



You can use PL / SQL and possibly UTL_FILE to write binary data to a file on the server. Or look at the UTL_RAW package.

+1


a source


You can use perl DBD :: Oracle to query this table and write data. You can use any programming language you like with the oracle client / api which can pull this data and write it to a file. You can also use oracle tools like oracle exp / imp to move data from db to db. Since you haven't specified what you want to do with the data in the long cheese, it's hard for you to help you.

0


a source






More articles:


All Articles