- SQL Tuning ... ... <code>I am new in tuning sql statements. Can u give a methodology of tuning the sql statements. </code>
- SQL Query ... ... <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 ... ... <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...
- CURSOR ... ... <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? ... ... <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>
- Pivot Query ... ... <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...
- extracting data to a flat file. ... ... <code>How can i extract data from flat file to oracle table with plsql ? </code>
- Analytics question ... ... <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 ----- --- ------- ----------...
- Tuning SQL Statements Using Explain Plan ... ... <code>Hi Tom , I am new in tuning sql statements. Can u give a methodology of tuning the sql statements and to predict the output of explain plan. When i use explain plan for a particular query, i am able to understand what the result means. can u p...
- SQL Query ... ... <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...
Ask Tom MOST POPULAR