AllExperts > Experts 
Search      

Oracle

Volunteer
Answers to thousands of questions
 Home · More 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 and some basic dba activities or performance tuning for Oracle 8i database. I cannot answer questions related to major dba activities, backup and recovery.

Experience
10+ years
D2K

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

   

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

SubjectDate AskedExpert

Procedure7/7/2008Suchitra Joshi
  Q: I just faced a question from oracle corp that Whenever a procedure is called inside a package ...
  A: The main reason is that the stored procedures/packages are loaded once into the SGA and remain there ...
import data from .dmp file7/5/2008Elliot Mak
  Q: I have a vdata.dmp file created in oracle 9.0.1.1.1. I do not know any user,password and any ...
  A: Good day Munna Here is what I will do in this situation 1. Write the DDL from DMP file 2. Examine ...
oracle download7/4/2008Elliot Mak
  Q: could you please guide me on how to download oracle 10g and oracle 11g from their download ...
  A: Good day ddy, There are only two ways to obtain Oracle binaries, they are 1. Through ...
Recovery with RMAN7/4/2008Elliot Mak
  Q: I'm doing a recovery of a database with RMAN but I've a problem: When I recovery until time1, I've ...
  A: I have never done this before, but from what I understand about RMAN configuration, you can ...
Performance of a Stored Procedure7/3/2008Suchitra Joshi
  Q: How to check the performance of a stored procedure. and how to check the performance of a query? ...
  A: 1) You can check performance of the stored procedure by either of the 2 ways - - SQL_TRACE and ...
Index7/3/2008Suchitra Joshi
  Q: 1>How to check a query is utilizing a particular index. 2>If a table consists of 2 or 3 indexes ...
  A: 1) You can check the query execution using EXPLAIN PLAN. More info at following site - ...
Oracle IMP utility7/2/2008Elliot Mak
  Q: I have created two databases in oracle on the same PC. Now If I run IMP command how can I select a ...
  A: Good day Pankaj In order for you to perform the import, you will have to set the ORACLE_SID ...
SQL Loader7/2/2008Suchitra Joshi
  Q: I need to create a .CTL file for a given table and in the data file the columns are scattered here ...
  A: The Filler option is used only when there is a column in the table, but no corresponding column in ...
important7/2/2008Elliot Mak
  Q: Error coming as Ora600 while import the dmp file. help me in resolving the issue.
  A: Sorry for the previous message. It was responding to another issue. By have put this in yours by ...
describe all tables in database7/1/2008Edson
  Q: i am thivya. i want to know whether is there any privilege to describe all the tables in my datbase ...
  A: There is not a thing such that. What you can do is to make a script: SET HEAD OFF SPOOL ...
profile in unix6/30/2008Suchitra Joshi
  Q: We can see database entry by using oratab and profile command..what is difference between oratab and ...
  A: Oratab ------- "oratab" is a file created by Oracle in the /etc or /var/opt/oracle directory when ...
Profile6/30/2008Edson
  Q: We can see database entry by using oratab command and profile command..what is difference between ...
  A: "oratab" is a file created by Oracle in the /etc or /var/opt/oracle directory when installing ...
ORA-12545 connect failed target host or object does not exist6/27/2008Elliot Mak
  Q: we are doing a project in VB with oracle8i as back end. when i try to run the command "tnsping ...
  A: Sorry for the late reply. I just got access to internet just now. To answer your questions. It ...
Oracle8i- TNS could not resolve service name6/26/2008Edson
  Q: i am thivya working as a software developer. we got a project with VB as front end and oracle8i ...
  A: It can be many things, but there are some more possible: 1) The file TNSNAMES contains the ...
Oracle8i- TNS could not resolve service name6/26/2008Peter Choi
  Q: i am thivya working as a software developer. we got a project with VB as front end and oracle8i ...
  A: An ORA-12154 covers a lot of possible errors. For starters, can you connect to the database using ...
output statement6/25/2008Elliot Mak
  Q: can i print my output in pl/sql in a single line please write statement for this ANSWER: Good day, ...
  A: In order for you to write a program like this, the program will need to: - know how many rows it ...
How to move database from Microsoft SQL Server 2005 to Oracle 9i?6/25/2008Peter Choi
  Q: I have a question regarding moving from another platform to Oracle 9i platform. Is there a tool ...
  A: Oracle does have a migration path for SQL Server to Oracle 10g and 11g (although it's similar for ...
oracle6/24/2008Peter Choi
  Q: i just passed the OCP exam, can i get the entry level job or internship in USA.
  A: Congratulations on passing your OCP exam. You can certainly apply for position in your local market ...
output statement6/21/2008Elliot Mak
  Q: can i print my output in pl/sql in a single line please write statement for this
  A: Good day, You can print your PL/SQL output in a single line using concatenation. Here is an ...
export security6/21/2008Peter Choi
  Q: If i have dump file from other schema i can easily create newuser and write imp newuser/password ...
  A: I was referring to the Oracle ROLES (DBA_ROLES, USER_ROLES) that are associated and granted to ...
Cluster Index and Non Cluster Index6/19/2008Suchitra Joshi
  Q: Mam what is the difference between clustered Index and Non Clustered Index.Do they come under ...
  A: I am not sure I can explain this in detail, but you will get more information on indexes at the ...
Call a Function inside sql6/19/2008Suchitra Joshi
  Q: How to call a function inside a sql statement whereas we cannot call a procedure. please give me a ...
  A: Here is the sample code to call a function from SQL (Assuming you have table project having columns ...
export security6/18/2008Peter Choi
  Q: If i have dump file from other schema i can easily create newuser and write imp newuser/password ...
  A: Oracle assumes the individual taking the backup will be responsible for securing the dump file. ...
DML statement with Dynamic Query or Execute Immediate6/17/2008Suchitra Joshi
  Q: Can I use Select or DML statements with Dynamic Query or Execute Immediate Statement. Scenario I ...
  A: Dynamic query is mainly used when we do not know the tablenames or where conditions in advance. So ...
Oracle commands from Windows command line...6/16/2008Peter Choi
  Q: Peter, a couple of years ago you asked the"Is there a way to run oracle commands *directly* from the ...
  A: With Oracle 8i and higher, you can now invoke SQL*PLUS from a MS-DOS command line in Windows. The ...
Oracle - list databases6/16/2008Suchitra Joshi
  Q: What command line do you use to list the databases and tables in an oracle instance and also ...
  A: To view database, instances, tables and columns, you have to use different queries as follows ...
Oracle exp and import6/13/2008Peter Choi
  Q: I have 2 questions : 1.I want to export and than import specific sequences ( only some of the ...
  A: Here's an answer from Ari Kaplan, one of many Oracle gurus: When exporting on the TABLE level, ...
Oracle 9i to 10g upgrade6/12/2008Elliot Mak
  Q: .We are planning to upgrade Oracle from 9i to 10g.We are currently using Weblogic Application ...
  A: Good day Naresh In order to upgrade Oracle from 9i to 10g Release 2, there are a lot of planning ...
Calling SQL Stored procedure from PLSQL function6/11/2008Suchitra Joshi
  Q: As a follow-up, I could not reply back to the previous thread. The only option that successfully ...
  A: In that case, I would suggest you write the procedure/function tempsqlsp in oracle instead of sql ...
Calling SQL Stored procedure from PLSQL function6/11/2008Suchitra Joshi
  Q: I have created a simple PLSQL function to return a value that is pulled back from SQL server. ...
  A: Remove the RNPS level from the pragma and check whether it compiles. Following is the explanation ...
Calling SQL Stored procedure from PLSQL function6/11/2008Suchitra Joshi
  Q: I have created a simple PLSQL function to return a value that is pulled back from SQL server. ...
  A: I am not quite sure of this. But you can try writing a packaged function as follows - CREATE OR ...
union syntax6/11/2008Suchitra Joshi
  Q: how to fetch fields from three tables in a single statement The Query(select ...
  A: The error indicates that there are some duplicate column names in some of the 3 tables. For eg. ...
creating a CSV file from oracle 10g database6/9/2008Elliot Mak
  Q: I am using oracle 10g with unix server,what i need is to export the database into a CSV file and ...
  A: It looks like the Oracle cannot access the directory specified due to the following: 1. Oracle does ...
question related to import .dmp file6/6/2008Peter Choi
  Q: .. I recently installed oracle9i in to my system.and I am having one .dmp file.I want to import .dmp ...
  A: 1. Can you connect to your database using SQL*Plus? If yes, then 2. The syntax for the command-line ...
ORA-229056/5/2008Peter Choi
  Q: I'm trying to install the Oracle Warehouse Builder but when I'm configuring the Repository, appear ...
  A: http://www.orafaq.com/forum/t/70983/0/ It may be possible that the version of OWH that you are ...
pl/sql6/4/2008Suchitra Joshi
  Q: what are the types of procedures? what is the difference between stored procedures& stand-alone ...
  A: As you pointed out, there are only two types of procedures - stored and stand alone. Stored ...
dba questions6/3/2008Peter Choi
  Q: Can one load data into multiple tables at once? What tuning indicators can one use? . What should ...
  A: 1. Generally, Oracle DBA perfer to load tables one at a time. While it is possible to load multiple ...
some dba questions6/3/2008Elliot Mak
  Q: How does one use the import/export utilities? Can one resize tablespaces and data files? Can one ...
  A: Good day Shanthi I assume that you are using Oracle 10g R2 or above. Question #1: How does one ...
creating a CSV file from oracle 10g database6/3/2008Elliot Mak
  Q: I am using oracle 10g with unix server,what i need is to export the database into a CSV file and ...
  A: Good day, Tom Kyte has provided a very good example in how to perform the extract using PL/SQL that ...
insert with select command6/2/2008King
  Q: I have a problem with insert statement with select. I have two tables named tbl1 and tbl2 with 5 ...
  A: Here is the solution: INSERT INTO tbl_temp2 ...

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


Questions by
Active Experts:
AmalElliot MakEdson
Kaustav NeogyKingSuchitra Joshi
Peter Choi  

     
About Us | Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.