Henrik Bechmann <[EMAIL PROTECTED]> wrote:
> My purpose was to find the least intrusive way of implementing
> vertical partitioning as a security measure, for example allowing a
> vendor to only see his/her records in a billing table. My idea was
> that a view constrained by a condition on a
My purpose was to find the least intrusive way of implementing vertical
partitioning as a security measure, for example allowing a vendor to
only see his/her records in a billing table. My idea was that a view
constrained by a condition on a foreign key would work. In the absence
of passing in
Hi Steve,
This is my problem:
create table inet0 (dest, mask, nexthop);
create index inet0_idx on inet0(mask, destination);
insert into inet0 values(x'0100', x'FF00', x'08080808');
insert into inet0 values(x'0101', x'', x'16161616');
insert into inet0 values(x'01010100',
Alex Katebi wrote:
> The problem with the view is that you can not pass a parameter or variable
> from the outer select to the views select.
Right that is not the purpose of a view. Think of a view as a virtual
TABLE. You can not pass a parameter to a table either. You can just
query the table
The problem with the view is that you can not pass a parameter or variable
from the outer select to the views select.
On Mon, Jun 30, 2008 at 12:49 AM, Igor Tandetnik <[EMAIL PROTECTED]>
wrote:
> "Henrik Bechmann" <[EMAIL PROTECTED]>
> wrote in message news:[EMAIL PROTECTED]
> > Thanks Igor! And
"Henrik Bechmann" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> Thanks Igor! And the SQL statement can be bound to parameters in the
> usual ways?
No, not in the view. You can, of course, select from the view (as if it
were a table), and _that_ query can be parameterized.
Igor
Thanks Igor! And the SQL statement can be bound to parameters in the
usual ways?
- Henrik
Igor Tandetnik wrote:
> "Henrik Bechmann" <[EMAIL PROTECTED]>
> wrote in message news:[EMAIL PROTECTED]
>
>> The definition for SQLite CREATE VIEW refers to pre-packaged select
>> statements.
>>
>>
"Henrik Bechmann" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> The definition for SQLite CREATE VIEW refers to pre-packaged select
> statements.
>
> What's the "pre-packaged" refer to?
The view itself. A view is simply a way to name a SQL statement and save
it in the database -
The definition for SQLite CREATE VIEW refers to pre-packaged select
statements.
What's the "pre-packaged" refer to? Are the select statements named and
stored, so that I can create a temporary named view from a prepared
selection of named select statements, depending on (for instance) the
9 matches
Mail list logo
