• SQL Tuning
  Sat, 17 May 2008 20:10:46 +0000, Ask Tom MOST POPULAR
  <code>I am new in tuning sql statements. Can u give a methodology of tuning the sql statements. </code>
  
  
• SQL Query
  Sat, 17 May 2008 20:10:46 +0000, Ask Tom MOST POPULAR
  <code>Tom: I have a table that initially stores information about items in a warehouse stored in different bins. Table look like this where manual inventories are done every 3 months. Effective date is the sysdate when record is inserted. Inv...
  
  
• How to Update millions or records in a table
  Sat, 17 May 2008 20:10:46 +0000, Ask Tom MOST POPULAR
  <code>Good Morning Tom. I need your expertise in this regard. I got a table which contains millions or records. I want to update and commit every time for so many records ( say 10,000 records). I dont want to do in one stroke as I may end up i...
  
  
• Analytics question
  Sat, 17 May 2008 20:10:46 +0000, Ask Tom MOST POPULAR
  <code> I have a table from a 3rd party application that is used to track an order through the various manufacturing operations. A subset of the information looks like this: ORDER OPN STATION CLOSE_DATE ----- --- ------- ----------...
  
  
• CURSOR
  Sat, 17 May 2008 20:10:46 +0000, Ask Tom MOST POPULAR
  <code>Hi Tom, I want to declare multiple cursors based on the values passed through a procedure ie, only where conditions of the cursors will change. The body of the procedure is same for all the cursors. Pls. suggegst a solution. Than...
  
  
• What don't you like about Oracle?
  Sat, 17 May 2008 20:10:46 +0000, Ask Tom MOST POPULAR
  <code>Hi Tom, I was wondering if there are some thing you don't like about Oracle? I personally wish more things came setup, out of the box such as autotrace, intermedia text, scott schema etc. Any thoughts on this? -Alex </code>
  
  
• SQL Query
  Sat, 17 May 2008 20:10:46 +0000, Ask Tom MOST POPULAR
  <code>Hi Tom, I have a table like this create table temp1 (f_name varchar2(100), f_date date, f_amount integer ); Records in this table will be like this: Ajay 15-JUL-02 500 Bhavani 15-JUL-02 700 Chakr...
  
  
• Pivot Query
  Sat, 17 May 2008 20:10:46 +0000, Ask Tom MOST POPULAR
  <code>Please state an example of pivot query. I know that in cardinality I've 2 columns, so how can I show them in columnar form and I know the cardinality is 4. Please also illustrate method of Varray and Nested Tables. Regards Puneet </code...
  
  
• Comparison between Oracle and Others
  Sat, 17 May 2008 20:10:46 +0000, Ask Tom MOST POPULAR
  <code>Hi Tom, My question is something different. As an Oracle expert I always asked to provide strong reasons why to use Oracle Database and not to use for example SQL Server. Please, can you tell where to go in the Internet to search a...
  
  
• getting rows N through M of a result set
  Sat, 17 May 2008 20:10:46 +0000, Ask Tom MOST POPULAR
  <code>I would like to fetch data after joining 3 tables and sorting based on some field. As this query results into approx 100 records, I would like to cut the result set into 4, each of 25 record. and I would like to give sequence number to ea...
  
  

Powered by Ask Tom MOST POPULAR