I am using Oracle 10.2. How do I set up the relationship between parent table and child tables so that when
record is deleted from the parent table it should also delete all the records in t...
I have a timestamp column in a table that I need back as a date because the Microsoft OleDb provider for ASP.NET 1.1 does not support timestamps. So to experiment in TOAD, I try the following:...
I'm using Imp "dmp" file to import into my existing database. I've been told that I can drop all the tables via a "drop schema" command within the Oracle 10g Enterprise Manager gui, but I can...
I have a user (user A) in oracle who has a lot of objects under their schema, I wish to give access to these tables to another user (user B).
I want to avoid the following if possible
1. c...
I have an Oracle .dmp file I need to import to my database. I am new to Oracle and unfamiliar with the data import and export procedures. The orginal database and mine are Oracle 10g. How do I...
Experts,
How can I add new column in middle of the table using ALTER TABLE Temp ADD COLUMN AFTER or BEFORE?
How can I do that in Oracle?
Thanks.
I use Oracle 10g express. As I try to create a table with following script, I got error.
Script:
create table USERS (
ID NUMBER(19) not null,
CREATION_DATE TIMESTAMP(3) ...
Hello...
I'm running Oracle 10g (10.2.0.1) on RHEL4. My listener, database and Oracle HTTP Server are up and running. The sole purpose of this database is to run Oracle Application Express ap...
Any ideas on the below listed error?
Version is 10.2.0.2 on Linux Redhat
Could it be a parameter issue in the inti.ora? If so I can attache init.ora
ORA-12801: error signaled in paralle...
Can you please provide the detailed steps that one needs to take in order to upgrade an Oracle 10g Database (10.2.0.3 to 10.2.0.4) on Microsoft Windows Vista? If you have the patch numbers th...
Environment Oracle 10.2.0.1
This is a hard limitation by the software vendor, so patching, upgrading version is not an option.
I'm having problms with Full Outer Joins. I'm getting all ...
I am trying to create a simple stored procedure in Oracle where I pass it a value (a county number) and it returns with the county name. The code has compiled successfully, but I am not able t...
Hi,
can someone help me write a function to split a string separated by '/' into separate values, please? (Oracle 10g)
say, I have 'one/two/three/four' and need
1
2
3
4
Thanks!
I cant seem to connect using TOAD 9.6. I have oracle 10g XE installed, and until very recently I was able to connect with no problems. As far as I know nothing has changed, and other machines ...
Hi.
Does Oracle 10g have a Pivot function?
I need to convert table's rows (values) into columns.
Thanks.
I can't find the download for Oracle Database 10g Release 2 (10.2.0.1.3) Enterprise/Standard Edition for Linux x86.
There is only the download for Oracle Database 10g Release 2 (10.2.0.1.1), ...
I have installed Oracle 10g XE and the installation seemed to go OK. When I try to go to the Oracle Home Page, though, I am told the page is not available. I have local admin rights, I do no...
Hi Experts ..
I'm trying to obtain OracleProvider from (3rd party package (dll)),
and am got the following exception:
Could not load file or assembly 'Oracle.DataAccess, Version=2.111.5...
I have couple of SQL statements that does an INSERT, UPDATE, DELETE operations.
Now, I would like to create a shell script to automate the process in UNIX.
Can you please help me in construc...
We have a client asking us about the "default character set" for an Oracle 10g install. I'm having trouble finding that information. Is it WE8ISO8859P1, by chance? If not, what is it??
T...
Dear Experts -
I've intalled oracle 11g on Windows Vista 64bit. I've Toad 9.7.x.
I'm getting the following error when i tried to connect to oracle from Toad.
Cannot load OCI DLL: C:\app\st\...
Hey folks i have alittle problem, I just installed oracle RDBMS and i forgot to unlock scott account, is there any way i can unlock this?
thanks in advance
Hi All,
I'm hoping that someone might be able to give me some advice on this problem or if possible help me resolve it.
i have a small program which queres the db and is used as part of a v...
Hello,
I am in the process of porting a Sql Server database to an Oracle 10.2.0.3 db. I've run into one issue with left versus inner joins several times. I think I must have a fundamental m...
ORACLE 10 G
Hi
I have created a strored procedure and it compiles fine but Im not able to see any results so therfore it must not be executing. Ive done a very basic one to test but it...
