• October 31, 2005 31 Oct'05

    Help with tkprof report

    My total CPU time is 214 minutes for 672 rows fetched. Under "query" I have 6830738. What does this mean?  Continue Reading

  • October 31, 2005 31 Oct'05

    Is my table in the buffer pool keep?

    I created a table using the command 'create table t (no number)' followed by an alter, 'alter table t storage(buffer_pool keep).' There are 100 rows in this table. If I query v$db_object_cache, I do not find this table as kept. However if I query ...  Continue Reading

  • October 28, 2005 28 Oct'05

    WHERE EXISTS ( SELECT NULL... ) revisited

    In a previous post, you wrote that for an EXISTS clause, it doesn't matter if you use SELECT 'text,' SELECT 1, or SELECT NULL. I have at some point been told that using SELECT NULL for an EXISTS should allocate less memory than selecting a value. ...  Continue Reading

  • October 28, 2005 28 Oct'05

    DELETE WHERE NOT EXISTS

    I have two tables, A1 and A2, and they both have a column called SSn. How will I delete a row from table A2 that doesn't exist on A1?  Continue Reading

  • October 28, 2005 28 Oct'05

    Match two words in a column

    I have two tables, and both have a column called full_name. I want to match at least two words in the full name column. For example, "John Alder Smith" and "John F Smith" is a match, while "Peter Duncan Doyle" and "Peter Parker" is not a match.  Continue Reading

  • October 28, 2005 28 Oct'05

    DISTINCT with GROUP BY

    Could you give us a situation where both DISTINCT and GROUP BY are required?  Continue Reading

  • October 26, 2005 26 Oct'05

    Using Perl scripts to take an incremental data export

    I want to take an incremental data export from 40 tables and import into a similar schema residing remotely. I need to write Perl scripts to do this task. Is there a way to do this in Perl? If not, then what is the right way to do this?  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close