RE: SQL Question

[Kevin Lange]

First of all .....  your query where statement is joining the emp table to itself on deptno.   But, since you are specifying the dept table you have a cartesian join in progress.   Now, instead of the correct return of records you are about to get 100 x 10 or 1000 records.   That in mind, the function should be ran once for each record in the result set. -----Original Message----- From: Steve Haas [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:21 AM To: Multiple recipients of list ORACLE-L Subject: SQL Question Good morning,   Env't:  Oracle 8.1.5, HP-UX 11.0 (64 bit)   Given the following tables: emp with 100 rows dept with 10 rows   and this SQL: select emp.ename, initcap(dept.deptname) from emp.dept where emp.deptno = emp.deptno;   The questions - How many times is the initcap(dept.deptname) function actually "executed"? Is it once for each emp row (100 times) or once for each dept row (10 times) or some other value?   Another scenario - Would it be faster to retrieve rows with a bunch of similar functions (initcap, concatenations of columns and/or literals, etc) or to have and maintain the data in columns with the data formatted as such?   TIA gurus...   Steve Haas Opus Consultants, LLC