Home » Developer & Programmer » Forms » multiple row property
multiple row property [message #272768] Sun, 07 October 2007 03:35 Go to next message
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 Go to previous message
Littlefoot
Messages: 20901
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?
Previous Topic: showscrollbar
Next Topic: problem in open_form
Goto Forum:
  


Current Time: Sat Dec 10 16:59:55 CST 2016

Total time taken to generate the page: 0.25096 seconds