You are here:
| Subject | Date Asked | Expert |
| Generic database extract | 12/16/2011 | Suchitra Joshi |
| Q: We use software that visualizes XML files of a specific format, which can be generated from any ... A: ETL is used to extract, transform and load data from various database systems. You can check various ... | ||
| PIPELINE FUNCTIONS IN ORACLE | 12/15/2011 | Suchitra Joshi |
| Q: Can you explain me about PIPELINE or Table Functions? Under which scenario it will be used? Please ... A: Please find below links that will help you understand these functions - ... | ||
| DATABASE PERFORMANCE MONITORING | 12/10/2011 | Suchitra Joshi |
| Q: My Question is DB Performance monitoring. I have three database mounted in a instance. Out of which ... A: You can check these links - http://docs.oracle.com/cd/B19306_01/server.102/b28051/tdppt_manual.htm ... | ||
| dbms | 10/22/2011 | Suchitra Joshi |
| Q: Sir I am reading file system drawbacks.Data isolation is one draw back.I have studied some books ... A: You can get more information on isolation on this site - ... | ||
| database | 9/21/2011 | Suchitra Joshi |
| Q: could you give a practical example for hierarchial data model? if possible please explain with some ... A: Sorry for the delay. Here are some links to know the hierarchical model - ... | ||
| Need to KNOW the difference btwn ORACLE LEFT OUTER JOIN and ANSI JOIN | 5/26/2011 | Suchitra Joshi |
| Q: Suchitra, I am trying to perform a left outer between ships and ports table. Ship table consits of ... A: Generally the ANSI (Left outer) join and the standard Outer join (with (+) ), are syntactically ... | ||
| Need to KNOW the difference btwn ORACLE LEFT OUTER JOIN and ANSI JOIN | 5/25/2011 | Suchitra Joshi |
| Q: Suchitra, I am trying to perform a left outer between ships and ports table. Ship table consits of ... A: You have to modify your query as follows to get the desired output - select s.shipid, ... | ||
| Need to create a website for work | 5/3/2011 | Suchitra Joshi |
| Q: I am a caseworker for a contract company. I have a supervisor and then it is just me. I create my ... A: This is a great idea. But I am not aware of how to create a website or anything related to frontend. ... | ||
| sql query | 4/19/2011 | Suchitra Joshi |
| Q: can u tell me a query to get details of a all the rows whose column value is nth highest / lowest ... A: I got your question. But need more information about your expected result. So please send me the ... | ||
| Access Database Design | 2/5/2011 | Marty Landman |
| Q: I am trying to design a database that will allow me to track my costs per workorder I complete. So ... A: Cassie, I am not experienced with MS Access, although in principle it's an SQL based database like ... | ||
| Access Database Design | 2/5/2011 | Marty Landman |
| Q: I am trying to design a database that will allow me to track my costs per workorder I complete. So ... A: Cassie, Attachments don't work on the site that I know of. However in general you would write your ... | ||
| mirroring | 12/28/2010 | Suchitra Joshi |
| Q: I have trade (import and export) data for several countries. My table includes 5 fields; product ... A: Considering Oracle database, here is the query that might help you - select a.product_cd, ... | ||
| Mastering the DB Designing and queries | 11/10/2010 | Suchitra Joshi |
| Q: Could you please guide me as to how to master Database Designing ..more precisely....something ... A: Your database must include tables with all the necessary fields that will be used in your multiple ... | ||
| normalization | 10/29/2010 | Marty Landman |
| Q: I've a question about normalization(up to 3nf). Could you guide me how can I normalize this table: ... A: Tina, Given the data you've shown me the only further normalization I would suggest at this point ... | ||
| Database creation? | 9/22/2010 | Marty Landman |
| Q: My name is Kenya and I am an art student that was recently hired by a dog training professional to ... A: Kenya, I suggest installing Drupal on the website and then possibly using the CCK (content creation ... | ||
| Database for Slot Booking | 6/1/2010 | Suchitra Joshi |
| Q: I am Software Engineer in Agra @ Dayalbagh Educational Institute. Here I have to develop an web ... A: Assuming you have a user table (user_id and other columns), I suggest the following basic structure- ... | ||
| Database construction | 5/27/2010 | Suchitra Joshi |
| Q: I need have a database built to track simple legal matters. The database must be accessible by web, ... A: Sorry for the delayed reply. If you want web based application, you can use Java (language) and ... | ||
| Help with programming | 5/13/2010 | Suchitra Joshi |
| Q: I am setting up a new business. I have a website currently being designed however, there is a ... A: This will require a detail system analysis. Here are some points you can follow - 1) Design table ... | ||
| Database Design Layout | 5/6/2010 | Suchitra Joshi |
| Q: ) I'm looking for some input on how this layout looks as I'm brand new to databases. address - ... A: It would be better to have guardians table seperate, because many tables have student_id as foreign ... | ||
| search date from MS access Database using Vb.net, Ado.net, Oledb, Sql | 4/21/2010 | Suchitra Joshi |
| Q: My Search Date Query is not working, i want to search date from MS Access Database file Table, using ... A: I have not used MS Access in a long time. But after searching I found the following query that you ... | ||
| Design Question | 4/14/2010 | Reginald Lim |
| Q: Carlson, Trying to design a Star/Snowflake schema for analytical processing with M/S SQL Server ... A: You could do option 1, but that seems to change the grain or the fact definition of visit. For ... | ||
| 3NF and primary and foreign key structures | 4/6/2010 | Suchitra Joshi |
| Q: I have a question regarding reducing tables to 3NF form and the way they should be structured to ... A: You will need to designate foreign keys between certain tables to get the appropriate link ... | ||
| Finding Information | 2/10/2010 | Marty Landman |
| Q: Good afternoon, thanks for the help. I'm hoping you can steer me in my search. I'm not sure this is ... A: Interesting perspective. I know when my neighbor's house sold last year I just had to call the ... | ||
| Finding Information | 2/10/2010 | Marty Landman |
| Q: Good afternoon, thanks for the help. I'm hoping you can steer me in my search. I'm not sure this is ... A: Tom, I guess even though the info you need is public, it isn't all available online - if I ... | ||
| DB by PHP & MySQL | 1/22/2010 | Iain M Watson |
| Q: I'm looking for a best friendly and easy Administrative front-end Database using PHP & MySQL. I ... A: I know AppGini is free and I have heard good things about it, although I have never used it myself. ... | ||
| Relational Database Design | 1/18/2010 | Suchitra Joshi |
| Q: I'm in a class and have learned the very basics and have done some practice exercises. The ... A: If you use multiple tables for plant status, size, registration hybridizer etc, that means you are ... | ||
| Relational Database Design | 1/17/2010 | Suchitra Joshi |
| Q: I'm in a class and have learned the very basics and have done some practice exercises. The ... A: To create a relational database, you will have to create multiple tables, each storing data related ... | ||
| Access filter based on multiple criteria | 1/9/2010 | Suchitra Joshi |
| Q: I have a question on building filters based on multiple criteria using combo boxes. I have a qry ... A: Since you are not getting the folders, I think this may be due to the special characters / or \ in ... | ||
| embed video in a database | 1/7/2010 | Iain M Watson |
| Q: Hey, I recently got into web designing and decided to make a website to stream videos and I just ... A: Yes you will need an OBJECT database like ORACLE to embed video, graphics audio, graphs, and photos ... | ||
| Spreadsheet Database | 12/11/2009 | Suchitra Joshi |
| Q: Can the use of spreadsheets as a "mini database" be a problem for companies? Or is there a better ... A: The best way to store data is a relational database. Following are the reasons - 1) No restriction ... | ||
| Question about query | 11/15/2009 | Iain M Watson |
| Q: I have the following query: SELECT * FROM PickListDetails WHERE Quantity=(SELECT MAX(Quantity) from ... A: Your problem is that you need a GROUP BY statement at the end of the SQL statement for the columns ... | ||
| database | 11/10/2009 | Suchitra Joshi |
| Q: what is the out put SELECT (NVL(NVL(NULL,3),4)) FROM DUAL ANSWER: Hi Ani Soni, The answer is 3. ... A: Using the Data Definition Language (DDL) triggers, the Oracle DBA can automatically track all ... | ||
| database programming | 11/10/2009 | Suchitra Joshi |
| Q: PL/SQL does not support arrays. However which construct is equivalent to array A: PL/SQL supports 3 types of arrays - Index-by tables (Associative arrays) - let you look up ... | ||
| conceptual database design | 10/4/2009 | Iain M Watson |
| Q: I have a question on a homework problem asking me to Identify the mandatory/optional dependencies ... A: this look like a relational databases question ?? If so then we are talking about existence ... | ||
| SQL Query | 9/23/2009 | Iain M Watson |
| Q: In a view I want to count the number of activities (CMTR_WR_ActivityType) per person ... A: I am not sure which database you are using, but most SQL is the same in relational databases. You ... | ||
| Which program to use | 9/11/2009 | Iain M Watson |
| Q: I have built an Access database that I want to re-write in a different program for resell as web ... A: If you want to use the database thru a webserver/browser yuo should probably use MySQL and apache ... | ||
| access 2003 inventory database | 8/19/2009 | Iain M Watson |
| Q: My question is that I need to create and inventory database that can be added to and subtracted from ... A: I am not completely clear on what you need. But a basic Inventory database has an Inventory table ... | ||
| Dbms | 7/17/2009 | Iain M Watson |
| Q: what is the basic difference between DBMS & RDBMS? A: RDBMS is "Relational database management system", DBMS is the same minus the relational. There are ... | ||
| calculations in databases | 7/13/2009 | Iain M Watson |
| Q: how do i create an expression that affects two fields in two different tables in a form A: You can use the POST_TRIGGER command. You can have a block level POST_INSERT trigger on one table ... | ||
| Database and caller id | 7/10/2009 | Iain M Watson |
| Q: My friends parents run a small cleaning company. They have some database that was written by someone ... A: This is not an area of my expertise, but there are a few companies that I have found on the ... | ||
Answers by Expert:
Top Expert on this page
I can answer questions related to database (mainly Oracle), database architecture, design and programming. I can also answer questions related to SQL, Import/Export, SQL Loader etc.
Over 15 years of experience in Oracle database design, development and support.
Education/Credentials
B.Sc (Electronics)
DCA (Diploma in Computer Applications)

©2012 About.com, a part of The New York Times Company. All rights reserved.