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) ...
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...
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...
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 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...
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...
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 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 am using oracle 10g, I have a parent table Table 1, child table table 2 and a third table Table 3, where I want to insert the data into from Table 1
There is also data from the child table...
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...
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...
I'm trying to fire this trigger but I get ORA-04091: table ... is mutating, trigger/function may not see it
since I'm querying the same table the trigger is firing on.
I tried declaring pra...
I have a table from 8 Columns in Oracle 10G, this table has two indexes... sometimes and because of continuos loading and queries the response become very slow...
1) Could you please clarif...
Hi!
I have two hosts running on "Windows Server 2003". One is the PCO199, where the Oracle Application Server (OAS) & the Oracle Identity Manager (OIM), both 10g Release 2, are running. Bot...
Hey Guys, I am trying to use oracle regexp_replace to convert the first letter of any name to uppercase but cannot work out how to do it. I have the pattern matched well and works for all inst...
Hi Experts,
I have been asked to update a stored procedure by our application vendor and when I load the supplied code in Toad I get a syntax error. A selection of the code being run is as...
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 ...
All,
It's been a while now...but what is the process of command in a sql file to execute an Oracle stored procedure or function?
This file will be invoked with the @ on a SQLPLUS line. ...
How to Install Oracle 10g Rac on Sun Solaris 10 X86 using Vmware
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...
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 can compile the each procedure individually with no errors, however whenI refresh the package the body displays and X.If I compile the whole package we get 3 errors. If we recompile the bodi...
