Zmrss Reader » Ask Tom MOST RECENT ARTICLES

« Expand/Collapse

Ask Tom MOST RECENT ARTICLES (10 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...

← 疯狂的设计 Ask Tom HOT ARTICLES →

Zmrss Reader » Ask Tom MOST RECENT ARTICLES

Feeds

Ask Tom MOST RECENT ARTICLES (10 unread)