- Object relational impedance mismatch ... 2009-08-06 ... What are your thoughts on the so called "object relational impedance mismatch"? http://en.wikipedia.org/wiki/Object-relational_impedance_mismatch This seems to fuel the mentality that for an object oriented application to work people need to...
- Execute SQL Select statement stored in a table. ... 2009-09-08 ... Hi Tom, I have done the following <code>create table sql_statement(sqlid integer, sqlstmt clob, isselect varchar2(1)) begin insert into sql_statement(sqlid, sqlstmt, isselect) values(1, 'insert into dept(deptno, dname) values(:1,:2)', 'N')...
- SQL*Loader data from first record must be inserted in all rows ... 2009-09-01 ... Hi. Some data in the first record of my text file (a date), has to be inserted in all rows of the table. How do I create a CTL file for this? The first row of the text-file goes e.g. HEAD20091001. The date (2009-10-01) relates to all the rest of t...
- Rownum quey with sorting ... 2009-09-01 ... Hi Tom, I have a query which return millions of record,(as a result of inner join). I am not sure whether the client application will be able to handle these many records at once. I want to partition the query result in a few sets, and re...
- embedding a variable in a string ... 2009-08-31 ... After running a proc I wrote I get this error: ORA-01756: quoted string not properly terminated I am writing SQL as a string so that I can embed variables into the the string, like: v_sql := 'insert into... select... etc'; I then execute thi...
- internal logic of distinct clause ... 2009-08-06 ... I have 2 questions for you TOM: 1. ) when a query has a distinct clause on a clomun and the same column is used in the order by clause, will oracle order the data first and eliminate the duplicate or will it eliminate the duplicate records and the...
- What is the meaning of SQL*Net message from client ... 2009-08-07 ... Can you please help interpreting this output? OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------...
- Multiple production databases in a RAC cluster, ... 2009-08-05 ... Hello, Our management is inclining towards sharing two production databases on a 3-node RAC cluster. Each node is very powerful in terms of capacity (like memory and CPU). The intention is to have RAC capabilities for both the databases. Each d...
- DBMS_SPACE.CREATE_INDEX_COST ... 2009-07-26 ... Hi, I am trying to use the DBMS_SPACE.CREATE_INDEX_COST subprog. Although, it completes, it only returns NULL and 0 (the table stats are up to date) ? Any idea ? Thx. Bernard
- Balancing Instances and schemas ... 2009-08-06 ... Dear Tom, In your literature I have read "each box deserves its own database", meaning is better to have a single instance running in a box than more. Is it safe to generalize that if I have say 100 schemas, it is better to have a single instan...
Ask Tom HOT ARTICLES