Re: Oracle sql function SPLIT?




"Alex" <akizub@xxxxxxxxx> skrev i meddelandet
news:1146763780.653086.284680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
BTW, what has this to do with Java?
It should run in Java in prepared statement.
So, unfortunately, PL/SQL doesn't work...

Then I understand even less of your question... ;-)

You have "1 2 3" and wan't that turned into separate items, by the way of a
PreparedStatement for Oracle? I think it's a tad overkill...

What's wrong with:

String[] items = "1 2 3".split(" ");

?

Maybe it would be better to explain what you intend to use it for.

// Bjorn A




Inviato da X-Privat.Org - Registrazione gratuita http://www.x-privat.org/join.php
.



Relevant Pages

  • Re: Why use Java Stored Procedures....
    ... PL/SQL is 100% Oracle-centric while Java is not. ... If you did not take advantage of Oracle capabilities, ... Would you rather have a Java programmer migrating Java stored procedures to ...
    (comp.databases.oracle.server)
  • Re: Why use Java Stored Procedures....
    ... PL/SQL is 100% Oracle-centric while Java is not. ... If you did not take advantage of Oracle capabilities, ... I want deep and specific DBMS expertise if I want a well-running ...
    (comp.databases.oracle.server)
  • Re: Why use Java Stored Procedures....
    ... PL/SQL is 100% Oracle-centric while Java is not. ... If you did not take advantage of Oracle capabilities, ... Java in the database isn't transparent. ...
    (comp.databases.oracle.server)
  • Re: Why use Java Stored Procedures....
    ... PL/SQL is 100% Oracle-centric while Java is not. ... If you did not take advantage of Oracle capabilities, ... Java in the database isn't transparent. ...
    (comp.databases.oracle.server)
  • Re: Why use Java Stored Procedures....
    ... pros and cons of using Java for my stored proedures instead of PLSQL. ... PL/SQL is 100% Oracle-centric while Java is not. ... ORACLE the first. ...
    (comp.databases.oracle.server)