New answers tagged

1 vote

Patching Oracle Client 11g2 versions on SQL Server

Different versions are installed in different Oracle Homes, so I would expect the next installation to be say e:\app\user\product\11.2.0\client_2\ Are you sure that is the client version ...
1 vote

How To turn a string with "pipe-separated" values into individual rows in Oracle PL/SQL

You simply need to add in additional columns, e.g.: WITH student_info AS (SELECT 1 item_number, 'Ali|Reza|Pantea' st_firstname, 'Hashemi|Nosrati|Yaghobi' st_lastname, '10|20|20' st_score FROM dual ...
  • 220

Top 50 recent answers are included