Re: Retrieve N record from a large table...

Hello Thomas,

Thomas Kyte wrote:

> what I did once upon a long time ago what this:
>
> created a dummy view with N columns in it. something like:
>
> create view dummy as select substr( 'x', 1, 2000 ) c1, substr( 'x', 1, 2000 )
> c2, .... from dual;
>
> I built a default block on it. I made sure the default block referenced the
> view dummy NOT schema.dummy.
>

    Is the block contains fixed number of items? i.e. how can handle the table which contains more column fields than the block items?

> At runtime, I would ask the user for the table name.
> I would query the data dictionary for the list of columns.
> I would use that to build a view (say they said "emp") like:
>
> create view dummy as select ename c1, to_char(empno) c2, ...., to_char(null),
> c10, to_char(null) c11, ..... from emp;
>
> I would use forms_ddl to create the view.
>
> I would use forms builtins to hide the extra columns.
>
> I would go-block and execute query.
>
> I'm done -- forms does all of the scrolling for me. I don't have to do any
> more.
>
> Might that work for you?
>

Thanks,
Jimmy Received on Sat Sep 04 1999 - 02:28:47 CDT