Code:
select max(bob) from table_name
You can, in fact, create a table with a column named "max(bob)" by enclosing the column name in double quotes. However if you do this, the statements"
Code:
select "max(bob)" from table_name
pjda
Last Activity: Nov 13 '07, 06:19 PM
Joined: Aug 27 '07
Location:
-
Are you sure that what you've seen isn't something like:
? This will run through the table and select a single row which is the maximum value of the column BOB in the table.
You can, in fact, create a table with a column named "max(bob)" by enclosing the column name in double quotes. However if you do this, the statements"
... -
This doesn't sound like a SERVEROUTPUT issue. You would have to post Line 164 of procedure PROCEDURE_NAME, plus what you're trying to put into it before anyone could help you....Leave a comment:
-
It's fairly easy to get the list of documents that contain a particular token. That's what the CONTAINS function does.
Oracle doesn't explicitly keep track of the number of times a word is contained in any particular document. The TOKEN_INFO column contains the docid of each document in which a token is found, however to obtain the information you would like requires that you count the number of times the particular DOCID occurs...Leave a comment:
-
PRO*C is Oracle's pre-compiler for C. It allows a programmer to embed Oracle SQL calls in a C program. There are several other pre-compilers available. Check out Oracle PRO*C Guide...Leave a comment:
No activity results to display
Leave a comment: