AllExperts > Oracle 
Search      
Oracle
Volunteer
Answers to thousands of questions
 Home · More Oracle Questions · Question Library  · Free Encyclopedia ·
More Oracle Answers
Question Library

Ask a question about Oracle
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
About Suchitra Joshi
(Top Expert on this page)

Expertise
I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience
15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

   

You are here:  Experts > Computing/Technology > Oracle > Oracle

SubjectDate AskedExpert

Describe command in oracle 10g11/19/2009Suchitra Joshi
  Q: Please help me with describe command for oracle 10g. I am getting error ora00900 for 'desc ...
  A: You are getting this error because you must be using it in a SQL statement. 'desc' is not a SQL ...
Using Sql Loader to run multiple instance parallely11/17/2009Peter Choi
  Q: I want to know , how to use the the sql loader to rum multiple instances parallely,Right now its ...
  A: Here's an example of the syntax that invoke three SQL*Loader direct path load sessions on the same ...
regarding CSV upload !11/15/2009Suchitra Joshi
  Q: i would like to upload a CSV format file into my oracle database. As n when the file is loaded, i ...
  A: To load the CSV file you can use the SQL*Loader utility. All the errors related to table constraints ...
compare data in two columns11/11/2009Elliot Mak
  Q: I need to monitor the changes in two columns,example: Table 1 Line Id,Ship Date,Ordered Qty EAK ...
  A: Jing, Assuming that the line_id is the primary key of the table. You can add an additional ...
compare data in two columns11/11/2009Elliot Mak
  Q: I need to monitor the changes in two columns,example: Table 1 Line Id,Ship Date,Ordered Qty EAK ...
  A: Jing, The solution that I had before is assumed the line_id is unique. Without an unique column, ...
Connecting to Oracle server through firewall via VPN11/11/2009Peter Choi
  Q: I have a configuration where my Oracle client is located on my computer (Windows XP) in my office. ...
  A: Two things you may wish to verify on your Oracle client (Windows XP). 1. Host file. Do you have a ...
compare data in two columns11/10/2009Elliot Mak
  Q: I need to monitor the changes in two columns,example: Table 1 Line Id,Ship Date,Ordered Qty EAK ...
  A: Good day Jing, Here is what you can do TABLE1 - data from yesterday TABLE2 - data from today The ...
High load sql11/10/2009Peter Choi
  Q: How can i find out top high load sql queries in oracle. by querying performance views insted of ...
  A: You can use STATSPACK (this is a separately licensed product from Oracle and is NOT free. It does ...
Data Migration11/9/2009Peter Choi
  Q: I have to migrate my oracle database from oracle 9.2 to 10g release 2 on windows platform wht are ...
  A: There are two popular ways (Oracle lists 4): Option A 1. Export your data from Oracle 9.2 2. ...
awr report11/7/2009Suchitra Joshi
  Q: Respected Sir/Mam Question Number (1) drop table table1; FLASHBACK TABLE table1 TO BEFORE DROP ...
  A: Check whether your table is in SYSTEM tablespace. If yes, then flashback drop won't work. Please see ...
awr report11/7/2009Peter Choi
  Q: Respected Sir/Mam Question Number (1) drop table table1; FLASHBACK TABLE table1 TO BEFORE DROP ...
  A: The detailed steps are listed here: ...
awr report11/7/2009Binosh Mullassery-Padman
  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 ...
oracle11/5/2009Binosh Mullassery-Padman
  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 database11/5/2009Elliot Mak
  Q: Respected Sir/Mam I am using oracle10gXe but I am not able to see the my database name. Is ...
  A: Good day San I assume that you are using Oacle10gXE on WIndows Platform. There is no table to ...
RMAN Backup Database Instance11/5/2009Peter Choi
  Q: Can you explain me, is it possible to backup database instance by using RMAN. I have one database ...
  A: What is RMAN? ...
URGENT!!! pleaaaaaaaaaaseeeee11/4/2009Peter Choi
  Q: i've got a *.dmp file that i can't open! i've just read your answer to another question similar to ...
  A: Here's a quick and simple Frequently Asked Question (FAQ) document from OracleFAQ's website. ...
Data Guard Physical database11/4/2009Elliot Mak
  Q: Right now, I'm configuring DG Physical Standby on two separates servers, and I have to create ...
  A: Good day This is what I understand from your question. (1) Configuration of DG Physical Standby ...
Oracle data Guard Physical Standby Database11/4/2009Elliot Mak
  Q: Right now, I'm configuring DG Physical Standby on two separates servers, and I have to create ...
  A: Good day This is what I understand from your question. (1) Configuration of DG Physical Standby ...
save image using oracle10gXE11/4/2009Suchitra Joshi
  Q: Respected mam i am using oracle10gXE I want to store image on oracle 1og using sqlplus i ...
  A: 1) Check that you have read permission on the directory mydir. If not grant it as follows - GRANT ...
Regarding PL-SQL Developer Requirement11/3/2009Suchitra Joshi
  Q: I am having 2.10Yrs of experience in Application Support including PL-SQL.I have done OCP(DBA) and ...
  A: Even if your project was only data related, you can add some points to indicate that you have used ...
forms 6i11/3/2009Suchitra Joshi
  Q: I hav developed a form in forms 6i. This form is having one tabular layout data block say D1. No of ...
  A: You can try the following code in your 'when-button-pressed' trigger on blk D2. go_block('D1'); ...
Active sesions Problem11/3/2009Peter Choi
  Q: we are using 10g server, Every day from 10Pm to 11Pm Active sessions are increasing and effecting ...
  A: Do you have any batch processing scheduled to run at or around 10PM? By scheduled batch process, it ...
oracle 8i installation10/28/2009Suchitra Joshi
  Q: After installation, the SQL plus is started with scott/tiger.But once system restarts again the ...
  A: I will require more information on this like what is the error shown for connection failed, which OS ...
SQL Tuning10/27/2009Suchitra Joshi
  Q: I need you favor to tune the SQL, See below. The same kind of SQL is running parallely (9 SQL's) ...
  A: You can check the following to fine tune this query - 1) Index created on table MCCDSS_QTR_HPFU_STG ...
Oracle (No of Rows Into Single row)10/24/2009Suchitra Joshi
  Q: In Oracle I want to select No of rows into Single Row. For example (In the huge records) Name ...
  A: There are multiple ways to get this result. The possible ways are listed at this site - ...
oracle tuning10/24/2009Suchitra Joshi
  Q: Respected Sir I want to become a tuning expert of oracle but i dont know that which ...
  A: Here are some links for performance tuning - ...
oracle tuning10/24/2009Binosh Mullassery-Padman
  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 ...
Oracle10/23/2009Peter Choi
  Q: How to connect another machine Oracle database using Oracle SQL developer? I am using Oracle 11g. ...
  A: http://download.oracle.com/docs/cd/E11882_01/doc.112/e12152/intro.htm#CHDHIFGJ and ...
Csv data into oracle10/22/2009Suchitra Joshi
  Q: at present i am using mysql database but i want to convert my whole "mysql data" into oracle data ...
  A: I am not sure of MySQL. But you could try a mysqldump to take backup. Basically create a customised ...
Csv data into oracle10/22/2009Peter Choi
  Q: at present i am using mysql database but i want to convert my whole "mysql data" into oracle data ...
  A: Take a look here: ...
Csv data into oracle10/22/2009Suchitra Joshi
  Q: I want to load data from csv file into oracle database can u tell me step by step process for this
  A: You will have to use SQL*Loader to load csv file to Oracle tables. For this you will have to create ...
Csv data into oracle10/22/2009Binosh Mullassery-Padman
  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 ...
Csv data into oracle10/22/2009Edson
  Q: I want to load data from csv file into oracle database can u tell me step by step process for this
  A: SQL Loader SQL*Loader (sqlldr ) is the utility to use for high performance data loads. The data can ...
Oracle 11g install laptop spec10/21/2009Elliot Mak
  Q: Elliot, I wish to port my ORACLE 11g application and for demonstration purposes onto a laptop. what ...
  A: Good day Debra, AS you know, Oracle database is mostly run on memory. Therefore, I will recommend ...
howto map a user to a shared schema10/16/2009Peter Choi
  Q: we are using oracle 8.0.5...we have all tables in one schema called I_local..how can i map all users ...
  A: You can create public synonyms and then grant privileges (SELECT, INSERT, UPDATE, DELETE) to a role. ...
Creating multiple tables with Shell Script10/12/2009Suchitra Joshi
  Q: I'm looking for a pure sql Cum Shell solution to the problem described below. I'm a beginner in ...
  A: Since I do not have access to any Unix m/c, I cannot try and test this code. But I suggest you do ...
Creating multiple tables with Shell Script10/9/2009Suchitra Joshi
  Q: I'm looking for a pure sql Cum Shell solution to the problem described below. I'm a beginner in ...
  A: Try the following - [code] #! /bin/bash tname="table" for i in * do sqlstr="create table $tname$i ...
date in forms10/9/2009Suchitra Joshi
  Q: In my form there is 3 field 1)header_id 2)so_date 3) description here header_id is a disabled feild ...
  A: I will require more details for this - 1) Is date field required field ? If yes, are you entering ...
openings10/8/2009Suchitra Joshi
  Q: how are you? I required some information from you about opportunities on oracle. i am planning ...
  A: You have many opportunities in Oracle - PL/SQL Developer, Oracle Forms/Reports developer, Oracle DBA ...
oracle10/7/2009Suchitra Joshi
  Q: what are the differences between oracle 10g and 11g version? how can i check version of oracle from ...
  A: 1) You can check the Oracle 11g features so that you can identify the differences with 10g for each ...

Page:   1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10  |  Next      All


Questions by
Active Experts:
Elliot MakKaustav NeogyPeter Choi
AmalEdsonBinosh Mullassery-Padman
Suchitra JoshiVikash Pattnaik 

Email this page
     
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2006 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.