| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | My aa.sql file contains code on the lines of ...
--------------------
create or replace procedure proc_aa as
begin -- {
statements
end --...
dn.perl@gmail.com
|
08-12-2006 02:27 PM
Sybrand Bakker  | 2 | 92 |
| | | Can anyone help me to get results from this tricky query:
Select Recnum, trim(Both From Family_ID), trim(Both From DOB)
From abc
Where File_Key =...
Amritha.Datta@gmail.com
|
08-12-2006 08:17 AM
Ana C. Dent | 3 | 92 |
| | | Does oracle provides search replace string functionality?
e.g. lets say i have data into column as '(A + B + C) - (D + E)'
I would like to have...
Anil G
|
08-11-2006 11:12 PM
Anil G | 8 | 110 |
| | | Hey Everybody,
I am trying to run the following query on oracle 10g & I endup with an
error
ORA-01799: a column may not be outer-joined to a...
Harnek.Manj@gmail.com
|
08-11-2006 08:42 PM
DA Morgan | 1 | 107 |
| | | GENERAL PURPOSE
This position is for a senior Microsoft SQL Server DBA with between 3-5
years experience with production MS SQL Server environments. ...
Oracledude
|
08-11-2006 05:21 PM
Oracledude | 0 | 68 |
| | | What is wrong with this?
create or replace PACKAGE DAL_TABLE_METHODS AS
TYPE T_CURSOR IS REF CURSOR;
PROCEDURE GET_EMP (
p_EMPNO IN NUMBER,
cur_EMP...
tni@nc.rr.com
|
08-11-2006 04:31 PM
DA Morgan | 2 | 81 |
| | | GENERAL PURPOSE
This position is for a senior Oracle-focused technologist to work in a
presales capacity to support Centium's Oracle...
Oracledude
|
08-11-2006 04:27 PM
DA Morgan | 3 | 99 |
| | | If a table is exclusively locked and someone else tries an insert on
it, will Oracle simply wait forever for it to be unlocked before doing
the...
mike7411@gmail.com
|
08-11-2006 03:53 PM
DA Morgan | 2 | 90 |
 | | I need to create structured XML based on a simple parent/child
relationship. Take a table with three columns as an example:
Objects Table:
Unique_ID...
Tim@McHale.info
|
08-11-2006 02:17 PM
dataplex | 2 | 317 |
| | | GENERAL PURPOSE
This position is for a senior SAP "technical" consultant to work in
a presales capacity to support Centium's SAP...
Oracledude
|
08-11-2006 11:53 AM
Oracledude | 0 | 93 |
| | | GENERAL PURPOSE
This position is for a senior SAP BASIS Consultant with between 5-7
years experience with production SAP R/3 and SAP NetWeaver...
Oracledude
|
08-11-2006 11:00 AM
DA Morgan | 1 | 86 |
| | | Hi,
I was wondering how I should convert a timestamp to compare it to
'01-AUG-2006'.
Is any of the following right?
TO_CHAR(TRUNC(MYTIMESTAMP)) <...
Faby
|
08-11-2006 02:56 AM
Faby | 5 | 116 |
| | | Hi,
I am using Oracle 10g with windows XP. I've a service name USERDB and
the database userdb is in shared server configuration. I works fine if
I...
gurinder.kabbay (AT) gmail (DOT) com
|
08-11-2006 01:59 AM
T | 6 | 133 |
| | | I have package specification having TYPE as
TYPE some_rec IS RECORD(
col1 varchar2(100),
col2 varchar2(100)
);
TYPE some_ntbl IS TABLE OF...
Anil G
|
08-10-2006 06:40 PM
DA Morgan | 1 | 86 |
| | | Iīm looking for a SQL script to add Oracle userīs responsibilities,
bypassing Oracle forms.
Is there any way ?
Iīm using:
Oracle Applications :...
AT
|
08-10-2006 04:12 PM
DA Morgan | 3 | 90 |
| | | Hello all! I cannot figure out if/how I can do this with an SQL query.
I would like a result which totals the weight for each quality whenever
the...
Ture Magnusson
|
08-10-2006 04:08 PM
DA Morgan | 7 | 72 |
| | | Dear DBA,
You are cordially invited to test and review our windows native and
100% pure Java Oracle 10g Monitoring & Security Application (Xg).
Xg...
AT
|
08-10-2006 01:33 PM
AT | 0 | 98 |
| | | Hi@all,
I have the following problem:
After an insert on my table a trigger calls some procedures calculating a
value. If this is below a given...
Florian Eberl
|
08-10-2006 01:11 PM | 2 | 86 |
| | | Aloha,
I am trying to create a PL/SQL procedure to recognize non-supported
filetypes that is stored as a BLOB in my database; more accurately it
is...
eriben
|
08-10-2006 11:59 AM
Mark D Powell | 1 | 78 |
| | | I want to create a PL/SQL procedure that takes about 30 Oracle database
tables and copies them to a remote server. However, I'm not sure how
to deal...
AT
|
08-10-2006 10:44 AM
DA Morgan | 4 | 179 |
| | | vp_alltotals returns several million rows
sf_qual_paycodes contains 30 rows
This takes about 30 minutes to run:
select...
AT
|
08-09-2006 03:19 PM
Martin T. | 6 | 90 |
| | | Hello all!
Basically, what I want is the following.
Num -> Str
1 -> '1'
10 -> '10'
1.01 -> '1.01'
Is there a possible Number Format Model that will...
Martin T.
|
08-09-2006 03:14 PM
Martin T. | 7 | 223 |
| | | Folks,
Any help with creating a SP that denormalizes the below table to the
desired output will be appreciated.
Current Input Table...
AT
|
08-09-2006 02:58 PM
DA Morgan | 1 | 74 |
| | | At what point does Oracle enforce referential integrity?
For instace, if you have autocommit off and execute a series of
statements, will it check...
AT
|
08-09-2006 01:33 PM
DA Morgan | 2 | 71 |
| | | Is there a way for Oracle to queue up changes to a materialized view
and then only transmit those changes across a DB link once a day?
It is...
AT
|
08-09-2006 11:54 AM
Vladimir M. Zakharychev | 1 | 73 |
| | | Hello,
I'm trying to upload a Java class into an 8.1.7 database as a Java
Stored Procedure. I issue the following command:
loadjava -u...
AT
|
08-09-2006 08:37 AM
AT | 6 | 112 |
| | | We seem to be having an issue where SQL statements that call a function
written in java behave very differently than the same sql without the
java...
Dan
|
08-08-2006 07:41 PM
DA Morgan | 1 | 73 |
| | | Hello,
I need some help with code. I need to create and loop a cursor1 and
then use cursor2 in order to store the rows that I am selecting in
order...
Big George
|
08-08-2006 07:40 PM
DA Morgan | 1 | 90 |
| | | I'm trying to connect to an oracle 10g database with javascript using
os authentication. For now, I'm running the script on the...
Wyatt
|
08-08-2006 07:38 PM
DA Morgan | 3 | 191 |
| | | A table has been locked and I want to free it. I have
looked at v$lock and v$session objects, but I don't know
what entry to delete from where. What...
dn.perl (AT) gmail (DOT) com
|
08-08-2006 06:38 PM
joel garry | 7 | 110 |
| | | DECLARE
v_userTabColumns INT;
BEGIN
SELECT COUNT(*) INTO v_userTabColumns
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME ='T'
AND COLUMN_NAME ='ABCD';
IF...
Vinay Bhushan
|
08-08-2006 01:26 PM
HansF | 9 | 92 |
| | | Hi,
What would be better (faster):
1.have a stored procedure loop thru a list of values and execute a
statement:
update customers
set active =...
max
|
08-08-2006 12:48 PM
DA Morgan | 8 | 91 |
| | | Hi there!
We have some problems using Jinitiator 1.3.1.22.
Our users don't have administrator rights on their WinXP systems. We
use software...
AT
|
08-08-2006 05:43 AM
AT | 0 | 103 |
| | | Hi,
I need to make queries from one schema to others without having to add
that other schema as prefix in the select order, and I have heared that
I...
AT
|
08-08-2006 03:09 AM
sybrandb | 1 | 69 |
| | | Hello,
I am a University Distance student and I am taking a data base
management class. For our first assignment, we have to install Oracle
9i.
I...
AT
|
08-08-2006 02:23 AM
Martin T. | 2 | 66 |
| | | I was having a discussion with a fellow wherein he remarked that changing a
value in one of a view's originating table(s) causes the views defining...
Charles M
|
08-07-2006 02:30 PM
Charles M | 9 | 90 |
| | | Hello
We will be using Oracle Application Express (OAE) to upload a tab
delimited text file. After performing some simple validations on the
data...
John Burke
|
08-07-2006 12:55 PM
Pete | 2 | 77 |
| | | Hi there,
Looking for some suggestions for something probably pretty easy in
PL/SQL. Unfortunately the one dummies book I have on PS/SQL...
swaxolez
|
08-07-2006 12:14 AM
DA Morgan | 3 | 67 |
| | | Tough one here, I think. The following data set is building inspection
visits. It consists of multiple visits (2+) made to the same building on
the...
DFS
|
08-06-2006 12:20 PM
DA Morgan | 12 | 116 |
| | | Hello.
I have one problem with oracle select. Let have this simplified select
select * from
(
select
itms.CIT_SEARCHCODE searchcode,
inc.INC_ID...
AT
|
08-06-2006 09:00 AM
Charles Hooper | 3 | 151 |
| | | It is time to Xg at www.oraclexg.com
AT
|
08-06-2006 08:18 AM
AT | 0 | 83 |
| | | Hello All,
I am trying to write an application for Student Transfer Articulation.
I have 3 fields(1st one is a drop down menu for "Subject", 2nd one...
AT
|
08-06-2006 06:10 AM
Mark C. Stock | 8 | 86 |
| | | Hello All,
I have a cursor as follows.
cursor StvsbgiC(p_inst varchar2 default null) is
select *
from stvsbgi
where stvsbgi_code = p_inst or p_inst...
AT
|
08-05-2006 04:21 PM
AT | 0 | 69 |
| | | Hi,
I am trying to get solution for this. I need to get settlement every
two weeks and it alwyas happens on "Wednesday"
Example :To Day's Date Jul...
AT
|
08-05-2006 06:53 AM
rjayanth | 13 | 378 |
| | | I am using the following code:
Select trunc (To_Date (call_start_dt)),
count(*)
from IVRREPORTING.CALLDETAIL
where
(call_start_dt > '2006-07-01...
AT
|
08-05-2006 05:09 AM
Martin T. | 4 | 263 |
| | | When a column is defined as not null for a table, count(*) and
count(column) should return the same result. Correct?
However I am getting different...
raghu
|
08-04-2006 07:44 PM
Mark C. Stock | 1 | 87 |
| | | I have a table t1 : time1 unique, qty
Entries : (1, 10) (2, 20) (3,30) (32,20)
I want to find out the time1 values where qty is the...
dn.perl (AT) gmail (DOT) com
|
08-04-2006 06:44 PM
DA Morgan | 6 | 68 |
| | | Hi,
I got this question on an interview, but was unsure of the answer.
Could you help?
What are the two types of indexes and how are they stored...
AT
|
08-04-2006 06:24 PM
DA Morgan | 4 | 94 |
| | | So, we've got some inter-database portability issues we're trying
to address.
sqlite uses: select * from foo limit 1;
oracle uses: select * from foo...
Mark Harrison
|
08-04-2006 03:26 PM
Gints Plivna | 6 | 145 |
| | | Is there a way to check the last time a table was modified?
Is this a built-in Oracle field for all tables?
Thanks.
AT
|
08-04-2006 02:16 PM
Graham Wallace | 3 | 110 |
