Home » Developer & Programmer » Forms » multiple row property
multiple row property [message #272768] Sun, 07 October 2007 03:35 Go to next message
Messages: 45
Registered: October 2007
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
Messages: 20847
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: Tue Oct 25 19:52:08 CDT 2016

Total time taken to generate the page: 0.09399 seconds