Oracle/Expert Profile

Average Ratings

• Knowledgeability 9.66
• Clarity of Response 9.57
• Timeliness 9.79
• Politeness 9.87

• Number of Questions (in Past 24 Hours) 0
• Max Questions to be Asked (in 24 Hour Period) 5
• Total Questions (since joining AllExperts) 249
• Volunteer Since 2007-10-31
• Prestige Points 1560

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness

User	Date	K	C	T	P	Comments
Jing	11/11/09	10	10	10	10	Thank you very much!
Jing	11/11/09	10	10	10	10	VERY quick reply and very helpful
Jing	11/10/09	10	10	10	10	Very quick reply and very helpful
prath	08/28/09	9	9	9	10
sharad	08/24/09	10	10	10	10

Recent Answers from Elliot Mak

2009-11-11 compare data in two columns:

Jing, Assuming that the line_id is the primary key of the table. You can add an additional statement to the original code (in the first reply) to get the data that are added in Table2 (today). SELECT

2009-11-11 compare data in two columns:

Jing, The solution that I had before is assumed the line_id is unique. Without an unique column, there is no way to identify if new data is added or data has changed from table1 and table2. What is

2009-11-10 compare data in two columns:

Good day Jing, Here is what you can do TABLE1 - data from yesterday TABLE2 - data from today The following query will return -- Added to table2 -- Remove from table2 but exist in table1

2009-11-05 oracle database:

Good day San I assume that you are using Oacle10gXE on WIndows Platform. There is no table to store the name of all the DB on your computer. However, in the Services (Start->Settings->Control Panel->Administrative

2009-11-04 Data Guard Physical database:

Good day This is what I understand from your question. (1) Configuration of DG Physical Standby (2) Physical Standby will only act as Read-only database (3) Need to create Standby Redo log files