Parameters in query
09/01/2019 11:47
i have lot of problems with letter query: select * from order where id_order in (1,5,9) oracle execute this query without problems, but select * from order where id_order in (:id_order) parametar is 1,5,9 oracle returns error any idea??

Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

Answer score: 5
09/01/2019 11:47 - and you need to read my question again...

Every time I want to write diferent value of parameter..

once, for example id_order = 1 and id_order = 5 and id_order = 9 I need to display order number 1, number 5, number 9..

understand??!!...

select * from order where id_order in (1,5,9)further select * from order where id_order in (1,6,17,89)further select * from order where id_order in (2,15,28,150) now, instead of writing (1,5,9) in query , (1,6,17,89), (2,15,28,150)...i want to use parameter select * from order where id_order in (:id_order)after execution i input value 1,5,9 for parameter and error ORA-01722 and ORA-02063 occurs...

in your example i need to input value for :id_order...what should i write? 1? 1,5,9 ?? Alan <not.me@uhuh.rcn.com> wrote in message news:N385e.451$Zn3.351@trnddc02...


Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

Answer score: 5
09/01/2019 11:47 - You need to get a book that teaches your SQL, or read the one you have.

select * from order where id_order in (SELECT :id_order FROM ...) Tom <mail@yahoo.com> wrote in message news:d331c9$6la$1@ss405.t-com.hr...


Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below