Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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