I want a script which would list all the dependencies of a table
For example:
If I pass the name of the table, the script should list
1. The primary key
2. The dependant table(s) that use ...
I found a lot of sessions are hung. I killed the processes on AIX, but the Oracle sessions seemed to be running still. How do you kill sessions to make sure that none of hung processes/jobs ...
What does wait event - library cache lock is ? how to resolve it ?
Hello
Below is a stored procedure that does work and my question is how can I incorporate a temp table within this stored procedure. Lets say, as an example, my temp table would read as foll...
How do I connect to Oracle version 92062 using ODBC in vb.net? I tried this ConnectionString:
"Driver={Oracle in v92062};Server=<servername>;Uid=<userid>;Pwd=<pass>"
I keep getting this ...
Hello
Below is my stored procedure which works - but, what I would now like is to create a table (see commented out two lines below IS) and then use this table later in my procedure then drop...
I run the following query to find the sid who has a lock and the waiting sid but the query runs very slow in our test environment even when there are no records in v$lock view. Any reason why...
Export terminated successfully with warnings.
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number # with name "" too small
Despite the warning ab...
When to use a merge join instead of nested loops and vice versa. We have Oracle 9i, can we change the optizer's plan using SQL hints. If yes then how ?
I have Oracle 9.2.0.5 DB and Coldfusion UI.
To be exact I'm using Railo (free coldfusion server alternate).
I have a simple query
Select someColumns,
TO_CHAR(TRACKING_START_TIME,...
I have the following query which i am trying to execute, but throws an error. I used 2 single quotes so that i can have 'Stop' in the database. Not sure what is causing the error is it the for...
Within an Oracle database, I would like to query on a selected record to see 'all' tables that this record exist, owned by a particular schema owner. Example:
Record is a work order in a co...
I have a query that looks like this and it works fine. The Large XML document breaks down into individual rows the way I like it.
SELECT VALUE(p)
FROM load_pubmed_xml_tmp w,
TABLE...
Hi,
I am new to pl/sql in Oracle, and am trying to create a loop through a named-list in my pl/sql procedure.
Example:
I have the set ('Dog,'Cat','Mouse'), and I want to substitute each ele...
I have got during
select * from Table;
ORA-29275 partial multibyte character and no result.
Message:
ORA-29275 partial multibyte character
Cause: The requested read operation could not ...
Hello,
Hereis my problem:
There is some data which we need to move from a vendor database to our Oracle database. The vendor has provided us with the exported data from their database. The...
How to check the current DB / tables in oracle?
I would like to check the size of DB and tables in oracle?
We have a database that we're working with and do not have any design info.
One of our developers has:
TOAD (Tool for Oracle Application Developers)
We access the database through a VPN...
What's the difference between using
(a) CREATE INDEX and ALTER TABLE... ADD CONSTRAINT
and (b) CREATE UNIQUE INDEX ?
This questions is a follow-up from http:Q_22793798.html
I created an oracle (9i) "after update" trigger. I need to log any errors if the update fails to a log table. Below is my trigger.
The problem is that errors are not falling into either of...
I have a table Company with columns like Phone_Num, Fax and email where they can have multiple values.
These values should be return in a single row.
The table below shed more light on the ...
I have a datetime field where I want to select only the times >= 8:00:00 and <= 18:00:00 - e.g
date_field
23/04/2007 09:40:27
25/05/2007 17:59:59
how do I do this?
Thanks
how to drop all the tables in a schema??without dropping schema
Thanks
Hi All,
I have a question regarding how to delete rows.Here is the question:
1.I have a table with around 11,000 rows.
2.Table sql statement is :
CREATE TABLE M_10
( ID1 NUMBER(6,0...
Problem Statement:
I am performing an outer join between 2 tables. On the rows where are no matching values, NULLs are in the column. All this is expected.
Now what I would like to...
