Re: for help

cname, clength and colid are column names that you wish to display data for.

ocicolu is the table name that you query against

tname is a column name that you apply criteria for, so that you do not get all the rows displyed. tabname seems to be a varable, but in fact is the criteria

It really is a pretty simple query, on the face of it.

Query syntax:
SELECT col1, col2
FROM table_x
WHERE col_y = 'criteria';

Laya Li wrote:

>Hi every one,
>I read a few samples codes of OCI, such as oci04.c oci06.c and
>oci02.c. I cannot understand the query they used. Here is this query:
>select cname, clength, colid
> from ocicolu
> where tname = tabname;
>What is ocicolu? Is it a table name? what is tname? In these codes,
>looks like tabname is argument, so you can use the same query select
>data from different tables.
>could anyone explain this query to me?
>
>Thanks,
>
>LLI
>
>
Received on Thu Jul 18 2002 - 18:30:34 CDT