You are here:
Oracle/Questions
| Subject | Date Asked | Expert |
| POS and Accounting | 2/4/2012 | Peter Choi |
| Q: I have an idea from creating a cloud based accounting software, Very similar to the intuit ... A: Good morning Mansoor, You're welcome. I can be reached here on Allexperts.com at anytime (we're all ... | ||
| Extra error messages while execution of trigger | 2/3/2012 | Elliot Mak |
| Q: I want to reraise my question. Last time I asked you,I got the response as below: "Following is the ... A: Good day Prashant To my best knowledge, if you are using it from SQLPLUS (or development tools), ... | ||
| oracle doubt | 2/3/2012 | Suchitra Joshi |
| Q: this is ramana reddy from india.now i am learning oracle.i heared that procedures support differed ... A: Stored Procedure supports deferred name resolution. Example while writing a stored procedure that ... | ||
| POS and Accounting | 1/27/2012 | Peter Choi |
| Q: I have an idea from creating a cloud based accounting software, Very similar to the intuit ... A: Congratulations on your ideal. If you wish to protect your ideal, I would suggest that consult the ... | ||
| EM | 1/23/2012 | Peter Choi |
| Q: my problem is related to enterprise manager, i am getting Enterprise Manager is not able to connect ... A: When you are using the automatic services on Windows, they are started in a specific recommended ... | ||
| Audit Trail using Triggers | 1/20/2012 | Elliot Mak |
| Q: I'm using ORACLE 11gR2. I am working on audit trail for our project. There are some 300 tables in ... A: Good day Ravindra, Sorry for the late reply. I was on vacation after my initial reply. With ... | ||
| Audit Trail using Triggers | 1/19/2012 | Elliot Mak |
| Q: I'm using ORACLE 11gR2. I am working on audit trail for our project. There are some 300 tables in ... A: Good day Ravindra There are other ways to perform audit trail on Oracle RDBMS. I am not too sure ... | ||
| EM | 1/10/2012 | Peter Choi |
| Q: my problem is related to enterprise manager, i am getting Enterprise Manager is not able to connect ... A: [For the purposes of this disucssion, Oracle 11gR2 is the assumed database version. While many of ... | ||
| POS software | 1/7/2012 | Amal |
| Q: I am not a computer egineer or any programmer. recently i was looking at some POS for my business ... A: As you have said that you are not a Computer Engineer nor a Programmer, I would not be able to ... | ||
| which is best? | 12/15/2011 | Peter Choi |
| Q: I AM PURSUING MA ENGG E.C.E 3RD YEAR. IN INDIA (TAMIL NADU ), I AM IN DILEMMA WHETHER TO GAIN ... A: Good day Manikandan, There are 2 questions that you will need to resolve: 1. What are your career ... | ||
| oracle | 12/4/2011 | Peter Choi |
| Q: i'm going to work for a company that capture data from the website to see how user look and ... A: You're looking to build a user experience insight based-application that will combine some customer ... | ||
| confusion in views | 12/2/2011 | Elliot Mak |
| Q: i have a little problem with accessing views, please help I am user 'system', i create a user snow, ... A: The reason why you got this error is because Oracle requires direct grant to the user. that means, ... | ||
| tuning | 12/2/2011 | Suchitra Joshi |
| Q: CREATE TABLE CURRENT_PLANO_NBR NOLOGGING PARALLEL 10 AS SELECT DISTINCT /* + PARALLEL (A,30,1) ... A: I am sorry I cannot help you with this. This task requires testing on similar data size, which is ... | ||
| Pl/sql proc to generate excel file | 12/1/2011 | Suchitra Joshi |
| Q: I have seen the topic regarding Creating Reports in Excel file directly from Procedures using ... A: Sorry for the delay in response. I have not tried any formatting in excel, but you can check this ... | ||
| confusion in views | 12/1/2011 | Elliot Mak |
| Q: i have a little problem with accessing views, please help I am user 'system', i create a user snow, ... A: Good day Ritesh I recreated your scenario on my laptop. Here is what I have done. -- Script Start ... | ||
| views | 11/27/2011 | Peter Choi |
| Q: i have a little problem with accessing views, please help I am user system, i create a user snow, ... A: The user SCOTT is the one who grants permission to access that it owns. So a first test, under the ... | ||
| Beginner Help | 11/26/2011 | Alwyn D'Souza |
| Q: I'm arun,completed MCA. I wants to be Oracle Developer. Learning SQL and PLSQL, i need your guidance ... A: Its always good to have plsql or sql knowledge because most of the applications will always need to ... | ||
| DBA Question | 11/23/2011 | Suchitra Joshi |
| Q: Mam, I want to be a DBA, now I am preparing for OCA(1Z0-047). Is it better for me? please suggest ... A: DBA is always a good area to be in. But you will need more practice and experience in this area in ... | ||
| Oracle vsOpen source | 11/21/2011 | Peter Choi |
| Q: I would like to know that there are many open source database available on net which are very good, ... A: Reference: http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems The ... | ||
| Procedure to change the datatyoe of a column | 11/18/2011 | Suchitra Joshi |
| Q: I am looking for the procedure wherin i can change the datatype of a column from varchar to ... A: Here is the procedure that might help your logic - create or replace procedure (in_from_date date, ... | ||
| SQL Max Count | 11/4/2011 | Suchitra Joshi |
| Q: I have this table CUST_RECIPE, which contains these fields CUST_RECIPE_ID and CUSTOMER_ID. I need to ... A: You can try either of these queries - 1) select customer_id, count(cust_recipe_id) from ... | ||
| query | 11/3/2011 | Suchitra Joshi |
| Q: Can you give me an example and explain a select query showing columns of data from an oracle data ... A: I don't know the exact answer. But you can try to use ODBC and create a database link for SQL Server ... | ||
| Oracle 11g procedure | 11/2/2011 | Elliot Mak |
| Q: How do you populate a table or data in Oracle 11g step by step? A: Good day, Oracle uses SQL DML to populate a table with data. The four most common DMLs are select, ... | ||
| Importing a .dmp file to my oracle database | 10/28/2011 | Elliot Mak |
| Q: I have .dmp file that I want to import to my oracle 10g database through Toad for Oracle client.I am ... A: Good day Ankit, I never used Toad to manage my databases. Therefore, I cannot tell you how to do ... | ||
| PL/SQL | 10/23/2011 | Suchitra Joshi |
| Q: Peace be upon You Mam, Actually I am working as ERP Consultant in Orion ERP, I know the basic ... A: Good to know that you found the site useful. For examples you search the net according to your ... | ||
| PL/SQL | 10/17/2011 | Suchitra Joshi |
| Q: Peace be upon You Mam, Actually I am working as ERP Consultant in Orion ERP, I know the basic ... A: You can get all the documentation on this site - ... | ||
| function and procedure | 9/27/2011 | Elliot Mak |
| Q: create or replace function calc_avg_mark (roll_num in number) return number is avgm number; m1 ... A: Good day, As I said in the previous reply, you will need to have a cursor declare in the declare ... | ||
| function and procedure | 9/27/2011 | Elliot Mak |
| Q: create or replace function calc_avg_mark (roll_num in number) return number is avgm number; m1 ... A: Good day, In your anonymous pl/sql block, you have a typo in the function call. You have ... | ||
| Pl/SQl | 9/27/2011 | Suchitra Joshi |
| Q: Suchitra I am Abhishek a 2011 b.tech(ece) batch passout and i am currently working with a software ... A: Its good to hear that you are enjoying software field. For any field, I would suggest you start ... | ||
| set timestamp format in table | 9/26/2011 | Elliot Mak |
| Q: Can we set timestamp format like dd-mon-yyyy, hh:mi am/pm in table. Please explain me with example ... A: Hafsa, You don't need to set the timestamp format in table. There is only one format when store in ... | ||
| Variable | 9/26/2011 | Alwyn D'Souza |
| Q: Cheers Aleyn, I have the below listed. Myis there a way to display the variables in a SELECT ... A: Since it is a local variable, the scope of the variable will be inside the anonymous block and you ... | ||
| set date format and limit to enter data in table | 9/25/2011 | Elliot Mak |
| Q: hell sir, Currently, I am working on a project which i have to submit at my collage in time. I have ... A: Good day Let me rephrase your question. You have a table where there is a date column. Your ... | ||
| Oracle_DBA_Interview | 9/13/2011 | Elliot Mak |
| Q: . I will ask u more question as i will have some doubt... Please correct me if I am wrong. ... A: I see there are two questions here. (1) What is a package? (2) how does it compile? What is a ... | ||
| ORACLE_DBA_INTERVIEW | 9/13/2011 | Elliot Mak |
| Q: I have attended an interview they have asked the below questions. 1. How to give SELCT and INSERT ... A: There is no one easy way to tell you how to estimate the size of the SGA/PGA. There are some ... | ||
| Query regarding OCA certification | 9/11/2011 | Peter Choi |
| Q: i would like to know complete details on OCA certification. could you please tell me which version ... A: Good morning Vinee, The official Oracle certification information can be found here: ... | ||
| ORACLE_DBA_INTERVIEW | 9/11/2011 | Elliot Mak |
| Q: I have attended an interview they have asked the below questions. 1. How to give SELCT and INSERT ... A: You are very welcome. The parameter you need to set is DISPLAY. For example Bourne, Bash, or Korn ... | ||
| ORACLE_DBA_INTERVIEW | 9/10/2011 | Elliot Mak |
| Q: I have attended an interview they have asked the below questions. 1. How to give SELCT and INSERT ... A: 1. How to give SELCT and INSERT grants to the 1000 users? That is a double edge question. The ... | ||
| Oracle Spatial | 9/2/2011 | Alwyn D'Souza |
| Q: How do you set up a database for solids in oracle spatial? A: Oracle Spatial can be installed via the Oracle installer, DBCA or from the command line interface. ... | ||
| Oracle | 8/22/2011 | Vikash Pattnaik |
| Q: What are the various versions of Oracle & which is currently being used & coming version & i want to ... A: Oracle has multiple set of product suites. I assume you are interested in Oracle database (RDBMS) ... | ||
| oracle apps or sap | 8/16/2011 | Suchitra Joshi |
| Q: I have completed oracle D2k forms and reports 6i but i hardly find any jobs in the market. I have ... A: If you have done Forms and Reports, then Oracle Apps is good. It contains both - the Oracle GUI and ... | ||
Oracle
Elliot Mak
Top Expert on this page
Expertise
I can answer questions with regarding to Oracle DB (8i, 9i, 10g, 11g) installation, configuration, administration, Data Guard, SQL, and PL/SQL (Procedures, triggers, functions).
Experience
I am an Oracle DBA, Senior PA, Project Manager, and Data Architect with 10 years of experience.
Education/Credentials
Bachelor of Science in Management System
©2012 About.com, a part of The New York Times Company. All rights reserved.