| Subject | Date Asked |
|
| awr report | 11/7/2009 |
Q: Respected Sir/Mam Question Number (1) drop table table1; FLASHBACK TABLE table1 TO BEFORE DROP ...
A: Hey San, How are you doing? Q1: Please run the following sql and check the value of VALUE ...
|
| oracle | 11/5/2009 |
Q: Respected Sir/Mam I am using oracle10gXe but I am not able to see the my database name. Is ...
A: How are you doing? If you want to see all the users in your database, then run the following ...
|
| oracle tuning | 10/24/2009 |
Q: Respected Sir I want to become a tuning expert of oracle but i dont know that which ...
A: How are you doing? These are the books I am using. And these are my bible for tuning ...
|
| Csv data into oracle | 10/22/2009 |
Q: I want to load data from csv file into oracle database can u tell me step by step process for this
A: These are the steps. lets take the example of DEPT table in scott schema Description of this ...
|
| sql query | 9/26/2009 |
Q: I want to know that how to use flash back query if anybook please tell me I want to rollback The ...
A: Good to see you again. How are you doing? I believe your requirement is to restore a table if ...
|
| oracle plsql | 9/20/2009 |
Q: Please see the following code. Actually what my aim is incremental loading... In incremental loading ...
A: How are you doing? Sorry for the delayed response as i haven been busy so I could not check my ...
|
| DATE Format Problem in ORacle 10g Release 1 | 8/25/2009 |
Q: Binosh Mullassery We are facing a strange problem in our application & need your suggestion. We ...
A: How are you doing? I think you need to specify date format the column of UI. You can give this ...
|
| pl/sql progrram | 8/24/2009 |
Q: i have a table Plot_table plot_iD ID SECTION_ID GRAVE_ID ------ --------- ...
A: How are you doing? Here the section_id in interments table is repeating on section 35. So the sql ...
|
| Query with Headers | 8/18/2009 |
Q: Here below is a working query: select t1.row_id ||'|'|| t1.desc_text ||'|'|| t1.name ||'|'|| t1. ...
A: How are you doing? The error is showing because when you concatenate all of the concatenated ...
|
| concatenation | 8/18/2009 |
Q: Mr. Binosh first I'd like to generate a random subject code in the following form: 'cccc999', ...
A: How are you doing? My apologies for the delayed response. I had been very busy at work. First ...
|
| oracle | 8/13/2009 |
Q: is there way to connect oracle to SQL.i want insert data from oracle to SQL Server tables.
A: How are you doing? This is more of a DBA question and I have not much expertise in this. But I found ...
|
| Doubt in pl/sql | 8/3/2009 |
Q: CREATE OR REPLACE PROCEDURE add_dept (p_dept_name VARCHAR2 DEFAULT 'place', p_location VARCHAR2 ...
A: How are you doing? This code will insert into employee table place as PLACE and location as NEW ...
|
| sql query | 7/31/2009 |
Q: GM sir SELECT count(*), deptno FROM employees GROUP BY deptno HAVING count(*) = (SELECT ...
A: Sorry for the delayed response. You can make use of Oracle Analytical functions to get the ...
|
| sql query | 7/27/2009 |
Q: date empcode1 empcode2 workdone 11/7/09 emp001 emp002 14 12/7/09 emp002 ...
A: How are you doing? Really sorry for the delayed response. I had been having a 18 hour work schedule ...
|
| oracle pl/sql | 7/23/2009 |
Q: i want a function that will recompile the materalized view..dbms_mview.REFRESH('viewname') is not ...
A: Please provide the create materialize view statrement. And are u talking about when you run begin ...
|
| Using IN to restrict queries | 7/16/2009 |
Q: I have a table which looks like this: ID PropertyID Value Group ...
A: How are you doing? Let me explain what I understood from your requirement. You want to select All ...
|
| Diff between Nested and Correlated subqueries | 7/16/2009 |
Q: Could you tell me the difference b/w Nested/Correlated subqueries. Thanks in advance! ~gudluck
A: A correlated Subquery runs for the rows selected from the outer query. It takes the value from the ...
|
| ORACLE SQL COMMAND LINE PROBLEM | 6/26/2009 |
Q: sir.......when am entering the commands like create table...etc it automatically ..line like ...
A: Ashok, First of all the create table command is wrong. There is no table name and instead of ...
|
| Count Updated Records by User | 6/24/2009 |
Q: I'm new to Oracle sql. I have 2 tables and I would like to know how many RECORDS from each ...
A: You can make use of Oracle's analytical function to archive the result set that you desire. SELECT ...
|
| Need select statement | 6/23/2009 |
Q: i have input in following way PRDCT_FUND_INTRST_RATE_ID RNWL_RT_STRT_DT RNWL_RT_END_DT ...
A: Really sorry for the delay in answering the question. I had been really busy and had a long working ...
|
