| Subject | Date Asked |
|
| Use LIKE in subquery | 10/1/2008 |
Q: I would like to be able to use the results of a subquery in the where clause of the outer query ... A: You cannot embed subquery within INSTR. INSTR expects the string or the column name to be passed ...
|
| Use LIKE in subquery | 9/30/2008 |
Q: I would like to be able to use the results of a subquery in the where clause of the outer query ... A: You cannot use LIKE in such a way. However, you can use instr to give you the same result. Here is ...
|
| protocol adapter error in sql*plus | 9/26/2008 |
Q: I installed in two different folders I logged itto database using sql*plus using oracle9i database.i ... A: The tnsnames.ora for your 9i developer suite is misconfigured. HOST names is the name of your ...
|
| protocol adapter error in sql*plus | 9/26/2008 |
Q: I installed in two different folders I logged itto database using sql*plus using oracle9i database.i ... A: It looks like you are trying to use IPC to connect to the database from the developer suite. You ...
|
| retrieve table constraints | 9/23/2008 |
Q: I am working in Oracle8i. How can I retrieve the constraints associated with tables in Oracle.From ... A: I don't think there is a change between 8i and 10g, and since I don't have 8i installed, I use 10g ...
|
| STRTDB80.EXE problem | 9/17/2008 |
Q: Sir, I have installed oracle8i in my system on windows XP home edition.I am not an expert. I am ... A: It seems to me that there is some issue with the installation. Since you are unable to remove ...
|
| Data guard | 9/16/2008 |
Q: Can we dataguard a 9.2.0.8 database to a 10.2 database? In other words, I have a 9.2.0.8 primary ... A: Good day Kaz, I have not virtualized an oracle physical database, and I have not heard any of my ...
|
| error while loggin | 9/14/2008 |
Q: i have installer oracle9i on my machine(windows Xp )after typin user name and password it shows ... A: Good day Ram, It seems that there are some services and/or configuration have not been done. Here ...
|
| oracle differences | 7/14/2008 |
Q: I have done oracle 8i a couple of years back.now i want to get a job on oracle. so I have to learn ... A: Good day John, There is quite a bit difference between 8i, 9i, and 10g. I will provide you their ...
|
| Oracle 10g login | 7/12/2008 |
Q: I have the problem while logging to the SQL*PLUS. after i entered the username and password as ... A: Good day Anil, Here is what you need to do: 1. Logon to the database using SYSTEM or SYS account 2. ...
|
| import data from .dmp file | 7/5/2008 |
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 download | 7/4/2008 |
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 RMAN | 7/4/2008 |
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 ...
|
| Oracle IMP utility | 7/2/2008 |
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 ...
|
| important | 7/2/2008 |
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 ...
|
| ORA-12545 connect failed target host or object does not exist | 6/27/2008 |
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 ...
|
| output statement | 6/25/2008 |
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 ...
|
| output statement | 6/21/2008 |
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 ...
|
| Oracle 9i to 10g upgrade | 6/12/2008 |
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 ...
|
| creating a CSV file from oracle 10g database | 6/9/2008 |
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 ...
|
| some dba questions | 6/3/2008 |
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 database | 6/3/2008 |
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 ...
|
| creating a CSV file from oracle 10g database | 5/30/2008 |
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 Amit, I have been using this code created by Mark Powell to generate CSV file from Oracle ...
|
| installing oracle 9i for personal use | 5/29/2008 |
Q: i would like to configure oracle 9i for my personal use .should i need to install oracle server in ... A: Good day Palani Kumar You can find the following document be particular helpful to you. ...
|
| transfer of .csv file | 5/26/2008 |
Q: my question is: "how can we tranfer .csv file to oracle server" thank you seema A: Good day Seema, Thank you for your question. To answer your question, transferring CSV file to ...
|
| oracle error 27101 | 5/26/2008 |
Q: As per you previous suggestions iam not able to find the services where the problem for which iam ... A: Good day Deepak, Based on what I see from the output you provided, it does not seem like another ...
|
| oracle error 27101 | 5/23/2008 |
Q: As per your previous suggestion given, can explain the three questions which you had asked me to ... A: Good day Deepak 1. Is there another database instance runninn on the server using simutaneously? ...
|
| oracle error 27101 | 5/22/2008 |
Q: as per your previous solution for the location of the alert log i found a file named alert_orcl in ... A: I reviewed your log, and I have noticed that the database instance failed at around 1:10 to 1:20 ...
|
| oracle error 27101 | 5/21/2008 |
Q: where can i find the alert.log file because as per your previous solution you had told to see what ... A: Good day Deepak To find where the alert.log is, there are multiple ways 1. Go to your ...
|
| oracle error 1034: 2701 error | 5/20/2008 |
Q: I have installed fresh windows 2000 server & oracle 9i on a server but every day when we try to run ... A: Good morning Deepak ORA-27101: shared memory realm does not exist message is generally caused by ...
|
| Move LOBSEGMENTS | 5/15/2008 |
Q: , I try to rebuild a LOB INDEX (Index type LOB) and I can't do it: ERROR at line 1: ORA-02327: ... A: Given that I don't have enough information to troubleshoot it for you. However, here is what I have ...
|
| BCNF Normalization | 3/20/2008 |
Q: I have a question regarding BCNF normalization. What I understood so far is that with BCNF ... A: BCNF is a more stringent form of 3NF, in most cases, 3NF meets the requirements of BCNF. The only ...
|
| hardware requirements for installing oracle10g | 3/6/2008 |
Q: what are the hardware requirements for installing oracle 10g XE. will my system get slow after ... A: Good day Rishika My assumption is that you are installing on Windows Platform. The hardware ...
|
| which version of oracle??? | 3/6/2008 |
Q: i m a student developing a live project which has to work on minimum 5 computers.i am using java as ... A: It is really depending on what you need it for and what of hardware you want to put this on. The ...
|
| data guard | 3/6/2008 |
Q: what do u mean by data guard,how does it help us, ANSWER: Good day Ibbu, Data Guard (DG) is an ... A: There are quite a bit of steps need to do to setup DG. I have enclosed the instruction from Oracle ...
|
| Oracle | 3/4/2008 |
Q: Can you give the major differences between oracle 10g and oracle 11g? A: Here are some highlights of 11g improvement 1. Automatic Memory Tuning 2. SQL Performance Analyzer ...
|
| data guard | 3/3/2008 |
Q: what do u mean by data guard,how does it help us, A: Good day Ibbu, Data Guard (DG) is an effective and comprehensive data availiability, data ...
|
| QueryWhere | 2/25/2008 |
Q: I have successfully used &A > ’14-FEB-08’, but if I wanted to say NOW DATE Plus 70 Days. Can this be ... A: It is very easy to do that in Oracle. Here is an example for your reference. If the datatype of ...
|
| QueryWhere | 2/24/2008 |
Q: Appreciate your help as a user-end rather then programmer I would like help with retrieving data on ... A: It is very easy to do that in Oracle. Here is an example for your reference. If the datatype of ...
|
| QueryWhere | 2/23/2008 |
Q: Appreciate your help as a user-end rather then programmer I would like help with retrieving data on ... A: Good day Kiran, Oracle 10g Release 2 by default, the date is in DD-MON-YY format. Therefore, if ...
|
| re | 2/22/2008 |
Q: ORA-06553: PLS-213: Package STANDARS not accesible problem shown at the time of user/table creation A: Good day, It seems like you have some problem with your shared_pool_size. Can you do the ...
|
| Oracle 10g -> 9i backout | 2/20/2008 |
Q: Can you let me know how to back out if something goes wrong with Oracle 9i-10g upgrade using DBUA A: Good day Anoop To perform an upgrade, here is what I recommended. 1. Install your new Oracle ...
|
| help me | 2/20/2008 |
Q: i have installed oracle 8i i cant log in into oracle i tried scott n tiger while installing oracle ... A: Since there isn't additional information (like error messages) you have provided, it is very ...
|
| syntax | 2/18/2008 |
Q: i want to import a data into a table which i have manually created through a dat file. there are ... A: Good day Rahman The fastest way to import the data is to use SQL*Loader that comes with Oracle ...
|
| Oracle global variable | 2/18/2008 |
Q: I having an oracle 3 tier design, i have a hp-ux based oracle database, and windows 2003 base oracle ... A: Good day, I am not expert in Oracle Application server and application. But from what I can see ...
|
| Pl/sql | 2/15/2008 |
Q: I am having view,procedure,synonym,index. The all schema objects depends on Table, if i drop the ... A: Good day, Index is coupled with the tables. Therefore, if you drop a table, the index will be ...
|
| Oracle 9i, 10G or 11i? | 2/15/2008 |
Q: I am 3 Years experienced in IT. I am into ERP(JD Edwards). I want to learn Oracle Database. So among ... A: It is great to hear that you have installed Oracle 10g on your PC, and I hope that you didn't ...
|
| Oracle 9i, 10G or 11i? | 2/14/2008 |
Q: I am 3 Years experienced in IT. I am into ERP(JD Edwards). I want to learn Oracle Database. So among ... A: Good day Swathi, Welcome to the world of Oracle database. I work in PeopleSoft myself. Oracle ...
|
| Question abt simple sql query | 2/11/2008 |
Q: I am new to sql programming....What is the use of || symbol in sql programming? plz can u explain ... A: Good day Vijju The '||' is for concatenation. What it does is to string multiple variables into a ...
|
| oracle | 2/7/2008 |
Q: Why after 9i to 10g why not 10i? A: Good day Manish That's a very good question. "i" in 8i and 9i stands for "Internet". "g" in 10g ...
|
| difference between oracle 9i and oracle 10g for simple usage | 2/1/2008 |
Q: I have windows vista on my laptop so I can only use oracle 10g with vista. I have used oracle 9i in ... A: Follow up: Good day, I have noticed that i have not answered the last question about Oracle 9i with ...
|
| difference between oracle 9i and oracle 10g | 1/26/2008 |
Q: I can get the answer from reading the oracle documents. but please i want the real differences ... A: Good day, As Oracle has enchanced many functionality between each releases, Oracle document is ...
|
| oracle 11i | 1/24/2008 |
Q: I want to install oracle 11i in my stand alone system..for that tcp/ip config and domain name config ... A: Good day I have not installed Oracle 11i on a stand alone system, but I have spoken with some of my ...
|
| imp oracle8i server procedure | 12/21/2007 |
Q: How can i import the oracle8i server dump? I want to upload the dump from windows directory (ie. ... A: Good day In order for you to perform the importdo it using command line, in this case, MS-DOS ...
|
| After the oracle upgrade from 9i to 10g Db performance is very very slow. | 12/18/2007 |
Q: Recently we had an upgrdae from 9i to 10g. After that the mview normally used to get built in 10 ... A: Good day, Without knowing your database and its structure and setup, it is very difficult for me to ...
|
| Oracle 10g | 12/13/2007 |
Q: AM working in a small corporate,my task is to dump all my employee databases on to my system,so that ... A: Good day, I will try to answer your question as best as I can, giving that the question is a little ...
|
| Number data type query | 12/12/2007 |
Q: My question goes as follows. I have a column with data type Number(22,4). When i try to store some ... A: Good day, In Oracle perspective, 20.00 or 20, both of them represent the same number, i.e. 20. It ...
|
| password renew | 12/11/2007 |
Q: how can change system password? A: Good day Suresh, To change SYS and/or SYSTEM have no difference than any other users. The syntax ...
|
| Oracle9i installation | 12/10/2007 |
Q: I have got oracle9i client version installed in my home pc. but i am not able to access the HR ... A: Good day Ramesh In order for you to access an Oracle database, you will need to setup your ...
|
| Table in SQL | 12/6/2007 |
Q: i am new to sql, i have currently created database in oracle, i have put the fk and pk on all table ... A: Good day Ash, There are three ways to perform that (to my best knowledge). You will need to add a ...
|
| Creating user identified externally | 12/6/2007 |
Q: CREATE USER XYZ IDENTIFIED EXTERNALLY In this command after creating user how it can be used? Please ... A: Good day, There are several things you will need to setup the database and the operating systems so ...
|
| Basic difference between Oracle 9i and 10g | 11/28/2007 |
Q: What are the main difference between Oracle 9i and 10g application. A: Good day Ranvijay There are a lot of differences and enhancement between Oracle 9i and 10g, for ...
|
| Slow execution | 11/22/2007 |
Q: I was using ORACLE 8.1.6. on OS Windows 2000. Somehow, my PC got corrupted & stopped working. I ... A: Good day, There are couple things I will suggest you to take a look at, and they are as follows: ...
|