multiple row property [message #272768] |
Sun, 07 October 2007 03:35 |
roni_a180
Messages: 45 Registered: October 2007
|
Member |
|
|
there r 10 row in tabuler form.
if i generate a single sql statement
(ex. select count(*)into v_cnt from emp)
then count value 1 we r see 1 row in tabuler form
and count value 2 we r see 2 row in tabuler form
and count value 3 we r see 3 row in tabuler form
and ....
|
|
|
Re: multiple row property [message #272794 is a reply to message #272768] |
Sun, 07 October 2007 07:43 |
|
Littlefoot
Messages: 21821 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Please, read the OraFAQ Forum Guide to learn how to properly ask a question here (especially the IM speech section).
As of your question: SELECT COUNT(*) INTO variable FROM table returns exactly one value. What do you mean by saying that one value should be in the first row, the second value in the second row etc. when there's only one value?
Could you create an example (preferably using Scott's schema) so that we could see what you mean?
|
|
|