You are here:
Oracle/Questions Answered by Expert Binosh Mullassery-Padman
| 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 ... | |
Oracle
Binosh Mullassery-Padman
Top Expert on this page
Expertise
I can answer any questions on Oracle SQL and PL/SQL. The following are the topics I am an expert in Writing SQL using SQL 92 standards Oracle Advanced Groups Analytical Functions Hierarchial Queries Partition Objects and Collections Oracle XML Oracle regular Expressions Exception Handling Bulk Binding Dynamic SQL and PL/Sql Procedures Functions Packages Triggers Advanced Queueing Implicit and Explicit Cursors Oracle sql functions(CAST, CURSOR etc) Oracle SQL Tuning Oracle Execution Plans
Experience
10 Years as Developer and DBA
Organizations
Currently working with a Health Care industry
Education/Credentials
Masters in Computer Applications
©2012 About.com, a part of The New York Times Company. All rights reserved.