Zmrss Reader » Ask Tom MOST RECENT ARTICLES » September 2009

Feeds

12122 items (12122 unread) in 19 feeds

Blog (67 unread)

• ~依米岛~ (67 unread)

Google (2118 unread)

• Google 黑板报 -- Google 中国的博客网志 (1136 unread)
• 疯狂的设计 (982 unread)

Oracle (3670 unread)

• Ask Tom MOST RECENT ARTICLES (2743 unread)
• Ask Tom HOT ARTICLES (359 unread)
• Ask Tom MOST POPULAR (46 unread)
• Ask Tom MOST POPULAR (10) (46 unread)
• Mark Rittman's Oracle Weblog (273 unread)
• Oracle Professional (203 unread)

OracleERP (1645 unread)

• AppsBI : Applications Business Intelligence (188 unread)
• Oracle BI Publisher Blog (523 unread)
• AMIS Technology blog (934 unread)

ReadBlog (1890 unread)

• 王建硕 (384 unread)
• DBA's notes (1026 unread)
• Chanel [K] (480 unread)

nix (386 unread)

• FreeBSD Project News (386 unread)

OpenSource (370 unread)

• Open Technology and Business Forge (370 unread)

TechNews (1829 unread)

• BusinessWeek Online -- Tech Beat (1829 unread)

Design (147 unread)

• UCDChina.com (147 unread)

Ask Tom MOST RECENT ARTICLES (19 unread)

• September 05, 2009
• 8:42

  SQL*Loader data from first record must be inserted in all rows

   » ‎ Ask Tom MOST RECENT ARTICLES
  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...
• 8:42

  GetPrivateProfileString call from PLSQL

   » ‎ Ask Tom MOST RECENT ARTICLES
  <code>Hi Tom, I can't read text file in Unicode format, can you help me ? I have problems when I read ini file (text unicode format). In my program, I created a library : create or replace library kernel32 as 'C:\Nist\lib\kernel32.dll'; and ...
• 8:42

  Datafile error and Log Archive

   » ‎ Ask Tom MOST RECENT ARTICLES
  <code>Dear Tomacle, Hope you are well. I have 2 questions: 1. If I want to backup Database in Archive log mode, do I need to backup only archive logs and control files? Do I need redo log files? But I must backup full database ( Offline backup)...
• September 03, 2009
• 10:48

  join double-counting

   » ‎ Ask Tom MOST RECENT ARTICLES
  Tom, I am joining two tables. Table CHARGE can have zero or more rows for each row on the EVENT table. I need to sum up a column from each table, and what is making it interesting is that the group by does not include my join column. If I do a sim...
• September 02, 2009
• 8:04

  Code Reviews between Java Developers and DBA

   » ‎ Ask Tom MOST RECENT ARTICLES
  Hi Tom, This is a somewhat 'mature' shop, but we are just now in the process of establishing policies, etc. regarding the DBA role in code reviews (and design reviews) with the Java Developers. It is a given that the DBA's should review all the...
• 8:04

  Consolidating small databases into RAC / 2 Instance environment

   » ‎ Ask Tom MOST RECENT ARTICLES
  Our company is trying to bring around 10 small databases( 1GB) each with its own application, into RAC 11G environment - The idea is to move all these small databases as separate schemas in 1 database, 2 instances /2 node RAC Environment. My quest...
• 8:04

  Problem faced with searching strings using IN

   » ‎ Ask Tom MOST RECENT ARTICLES
  Hi Tom Thanks a lot for answering the question regarding IN and = ANY, The actual reason for asking that question is Our application is an web based application where the front end is java and backend is oracle, when an user clicks on a link ...
• 8:04

  Rownum quey with sorting

   » ‎ Ask Tom MOST RECENT ARTICLES
  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...
• 8:04

  Getting Foreign and Primary Key syntax from the Database

   » ‎ Ask Tom MOST RECENT ARTICLES
  <code>Hai Tom, Need your help in getting the following syntax. This is the example output which I would like to use for my Database Tables. Are there any built in procedures to be used if so what are they and how to use them. Can this data be retriv...
• 8:04

  embedding a variable in a string

   » ‎ Ask Tom MOST RECENT ARTICLES
  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...
• 8:04

  SQL In Presentation Layer

   » ‎ Ask Tom MOST RECENT ARTICLES
  Hi tom, We are writing a small application. Which has few screens (Can say as master screens ). The main operation is generally like Add, Modify, Delete and Search. So generally each master screen is goint to be associated with a master table. ...
• September 01, 2009
• 1:17

  Constraints or Triggers

   » ‎ Ask Tom MOST RECENT ARTICLES
  Hi Tom, We have two third-party application, lets us call them appA and appB, data is transferred from app A to B, some columns in appA have length larger than columns in appB because of which sometimes we get the following ORA-12899: value to...
• 1:17

  Index Organized Tables - when not to use it

   » ‎ Ask Tom MOST RECENT ARTICLES
  Dear Tom, I have a question about Index Organized Tables while reading your book - "Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions". I understand there are situations where IOT has its advantage over tradit...
• 1:17

  Performance of IN and ANY

   » ‎ Ask Tom MOST RECENT ARTICLES
  HI Tom This has been a doubt for me from long time, In performance wise which is better among IN and =ANY. why most people tend to use IN rather than =ANY when both does the same. Can you please let me know what is internal logic oracle uses when ...
• 1:17

  disable/enable indexes every day

   » ‎ Ask Tom MOST RECENT ARTICLES
  Dear Tom, I have a <u><b>daily process</b></u> which inserts into table A from table B (table B is accessed via a dblink). In order to make this process fast I am doing this in a package 1. execute immediate 'disable A indexes' 2. insert...
• 1:17

  Executing static insert queries stored in a table in a procedure...

   » ‎ Ask Tom MOST RECENT ARTICLES
  I am currently working on a Oracle procedure that runs 30+ insert queries on a database and populate another database after some calculations are done on the source data. Storing these <b>long</b> insert queries in my procedure will make it very b...
• 1:17

  Database

   » ‎ Ask Tom MOST RECENT ARTICLES
  Hai Tom, Are there any options in utl_smtp package so that a mail will come back to the sender if mail has not been delivered to the receipient.?
• 1:17

  Queries with OR

   » ‎ Ask Tom MOST RECENT ARTICLES
  Hi Tom, I have a huge table (non-partitioned) with about 400 Million records in it. The structure of table is Create table t_link ( ID Number(38) Primary key, TID1 Number(38) Not null, TID2 Number(38) Not null, Amt N...
• 1:17

  RMAN MetaData Storage in Controlfile

   » ‎ Ask Tom MOST RECENT ARTICLES
  The question is does 100% RMAN metadata reside in the controlfile even when you are using the RMAN catalog? The question is does 100% RMAN metadata reside in the controlfile even when you are using the RMAN catalog? We are trying to see if we...