| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi Guys,
Could really do with you assistance here!
I have table test
test_id number(11) PK
test_name varchar2(100)
start_time date
trub3101
|
04-18-2009 10:34 PM
Michael Austin  | 5 | 72 |
| | | Hi,
I need to create an app where any given employee may nominate up to
TWO other employees per year for an award. This number could change.
Now I...
livefreeordie
|
04-18-2009 03:27 PM
Robert Klemme | 4 | 86 |
| | | I recall that it was possible somehow.... that one could read out the
content of a view with a (simple) sql sentence
can anyone specify?
I use...
jodleren
|
04-18-2009 07:49 AM
William Robertson | 3 | 85 |
| | | I have a set of oracle tables which were set up by people no longer
available for consultation.
When I select from the all_indexes table, asking...
Larry W. Virden
|
04-15-2009 05:13 PM
joel garry | 7 | 143 |
 | | I'm trying to view all the indexes in an Oracle table. I try the
command "select * from USER_INDEXES" and I get no results. I no there
area tons of...
steff007jim@gmail.com
|
04-14-2009 03:01 PM
Malcolm Dew-Jones | 2 | 227 |
| | | I have a table that stores machine test results in the following form:
MachineId, TestDate, TestType, Pass_Fail, ReadingsCode
where
MachineId is...
hilljm1974@gmail.com
|
04-10-2009 09:32 PM
Charles Hooper | 1 | 78 |
| | | Hi All,
I have a simple subquery:
select ckt_id, charges
from table A
where ckt_id not in (select distinct ckt_id from B) and charges > 0
I know...
Sashi
|
04-10-2009 03:28 PM
William Robertson | 4 | 80 |
| | | The following query will return Triple word from a table like the
following:
pretty, woman, a
a, pretty woman
china,great, wall
wall, great,...
Carl Forsman
|
04-06-2009 02:28 PM
Shakespeare | 4 | 135 |
| | | The following query will return Triple word from a table like the
following:
pretty, woman, a
a, pretty woman
china,great, wall
wall, great,...
Carl Forsman
|
04-05-2009 09:19 PM
Michael Austin | 1 | 104 |
| | | High Quality Online Computer Training at low cost
We offer individualized training in a hands-on environment and
flexible schedules: Full time,...
vennarinfotek
|
04-03-2009 04:51 PM
ddf | 1 | 183 |
| | | On Apr 2, 10:17*am, "WWW.urbanhippoturban.COM shoes whaler"
<urbanhiphoturban... (AT) 126 (DOT) com> wrote:
ddf
|
04-03-2009 01:40 PM
ddf | 0 | 71 |
| | | hi ng,
it is a bit difficult to explain and more difficult to analyze and we
look for a hint where to search for our problem.
We use Oracle...
Andreas Mosmann
|
04-02-2009 02:40 PM
jgar the jorrible | 4 | 117 |
| | | On Apr 1, 4:34*am, "thvign... (AT) gmail (DOT) com" <thvign... (AT) gmail (DOT) com> wrote:
ddf
|
04-01-2009 03:08 PM
ddf | 0 | 72 |
| | | I have the following Oracle function from a vendor:
CREATE OR REPLACE
FUNCTION test_warn3
RETURN VARCHAR2 IS
ERRORS ab_curs.error_list;
startdate...
Bryan Ax
|
03-30-2009 04:47 PM
Bryan Ax | 2 | 98 |
| | | Ok, this is probably a dumb question, but, I have this code:
CREATE OR REPLACE PROCEDURE cj_trials_log (
p_newsletter_id ...
amerar@iwc.net
|
03-30-2009 10:04 AM
ddf | 6 | 178 |
| | | I have a situation where I'm trying to compare information in two
different columns in a where clause. The information in question are
last...
Larry W. Virden
|
03-28-2009 07:48 AM
Ed Prochak | 9 | 180 |
| | | Will a regular web host suffice for an Oracle web app, or does one need a
special Oracle-enabled web host?
Thanks.
tharpa
|
03-26-2009 02:39 AM
William Robertson | 7 | 137 |
| | | Specifically, I would like to take some columns or other data and
create a well-formed cvs string, including proper handling of
embedded quotes,...
mh@pixar.com
|
03-25-2009 12:45 PM
Paulie | 2 | 99 |
| | | Inside of Oracle Sql *plus
i use the commands alter table tablename
modify columname varchar2(10)
;
to change the field size to 10
When I open up...
BookerT
|
03-25-2009 08:25 AM
BookerT | 11 | 251 |
| | | We have this query, which is actually put together dynamically within
some PL/SQL code and opened via REF CURSOR. The WHERE clause is built
using...
amerar@iwc.net
|
03-23-2009 03:06 AM
Shakespeare | 7 | 98 |
| | | Last week I had an interesting problem with OID: I need to find all
users who are members of two given groups (so they must be in BOTH
groups). I am...
Shakespeare
|
03-21-2009 04:23 AM
Shakespeare | 0 | 130 |
| | | Hi All,
Can someone help me with this issue?
We have three tables with the following structure.
SELECT * FROM market;
comp_no comp_name
100 ABC
sumit
|
03-19-2009 02:41 AM
William Robertson | 2 | 134 |
| | | Hi,
we are using this...
Norbert Winkler
|
03-18-2009 07:36 AM
Paulie | 7 | 131 |
| | | I was asked to look into the concept of oracle's support of logical
deletes for rows.
The background is that the current set of tables are small,...
Larry W. Virden
|
03-17-2009 05:03 PM
Mark D Powell | 3 | 115 |
| | | Dear all,
I face a problem with this package
what is the target?
I have table "xch_t" (exchange rate table) to convert the currency to
'SAR'.
for...
NOVA
|
03-17-2009 02:17 PM
ddf | 5 | 117 |
| | | Hi,
I killed my last post and am posting a new one with an updated query.
Hopefully the other one was deleted.
Anyhow, I want to retrieve 2 records...
amerar@zacks.com
|
03-16-2009 04:36 PM
sybrandb@hccnet.nl | 7 | 123 |
| | | Hi,
can one tell me how would we write down relational calculus query for
one in which we have group by and having clauses...
miten.mehta@morganstanley.com
|
03-15-2009 04:09 PM
Paulie | 5 | 140 |
| | | Hi,
I've at this for a couple of days and have had no luck looking on the
internet. We have 10gR2. I have this query:
SELECT customer_id,...
amerar@zacks.com
|
03-14-2009 01:38 AM
sybrandb@hccnet.nl | 1 | 95 |
| | | Hi NG,
I am currently trying to install a dotnet Web Service within IIS which
uses odp.net to connect to the oracle database on a Windows Server...
Albert Greinoecker
|
03-13-2009 10:12 AM
Laurenz Albe | 1 | 115 |
| | | Qualify for Your Free Subscription Here...
http://ebooksick.tradepub.com/free/orm/
Published bimonthly and distributed to more than 550,000 of the...
Mike
|
03-13-2009 07:17 AM
Mike | 0 | 79 |
| | | Hello all,
What is the easiest way to replace part of a string in a VARCHAR2
column with another string?
My strings span multiple lines and I just...
lora
|
03-13-2009 05:33 AM
gareth@jamms.org | 3 | 170 |
| | | Dear Recruiters,
NCS US, Inc is seeking a challenging candidate for a Sr Recruiter
Position. Please read the job description below & send across...
Venu
|
03-12-2009 11:08 AM
gareth@jamms.org | 1 | 85 |
| | | Dear all,
If I have table like this
A aa B bb
1 5
2 7
1 7
3 ...
NOVA
|
03-11-2009 10:18 PM
Dave | 6 | 116 |
| | | especially one that doesn't have the 256 max chars/line
and 1000000 max chars/buffer limitation.
any hints and pointers...
mh@pixar.com
|
03-11-2009 03:22 AM
Magnus Bengtsson | 2 | 200 |
| | | Is there a significant performance penalty if dbms_output.put_line()
statements are not removed from code that goes to Production?
Nomen Nescio
|
03-10-2009 05:49 PM
William Robertson | 5 | 101 |
| | | I have the following set of tables and columns
T1:
Key1
Name
Dept.
T2:
Key2
Name
Larry W. Virden
|
03-10-2009 01:20 PM
Shakespeare | 10 | 161 |
| | | I have 2 tables: Input and Output.
Input table stores records in this manner:
recno, prod_first, prod_span, prod_last
1, 1, 1000, 1000
2, 1001, 700,...
coral.ressources@gmail.com
|
03-09-2009 10:17 AM
coral.ressources@gmail.com | 5 | 124 |
| | | Dear all,
I have this table as as example
select 'A' C1, 5 C2 from dual union all
select 'B', 8 from dual union all
select 'C', 2 from dual union...
NOVA
|
03-09-2009 09:19 AM
Mark D Powell | 4 | 109 |
| | | Dear all,
I have this table as as example
select 'A' C1, 5 C2 from dual union all
select 'B', 8 from dual union all
select 'C', 2 from dual union...
NOVA
|
03-07-2009 08:40 AM
NOVA | 0 | 205 |
| | | Hi all,
I desperately need your help:
I have a (complex) SQL statement here which runs fine on our internal
development database (R 9.2) but crashes...
Dirk Schwarzmann
|
03-07-2009 06:36 AM
Robert Klemme | 3 | 120 |
| | | I am using a myscript.cgi, written in Perl, to query an Oracle table,
and display a few fields in a browser. One field is of the type LONG
or CLOB,...
dn.perl@gmail.com
|
03-06-2009 09:34 AM
dn.perl@gmail.com | 2 | 127 |
| | | Is it possible to create a trigger that will show me the following:
Which user performed the update
Who procedure performed the update
The SQL...
amerar@zacks.com
|
03-05-2009 09:59 AM
Mark D Powell | 2 | 226 |
| | | On Sun, 11 Jan 2009, Maxim Demenko wrote:
Thanks,
I didn't think to look at the _data type_ documentation, I was looking at
the conversion...
Malcolm Dew-Jones
|
03-05-2009 03:24 AM
CarlosAL | 4 | 198 |
| | | On 03.03.2009 09:31, Jens Müller wrote:
Not sure whether that would work but you could try to use analytic SQL -
particularly ROW_NUMBER with...
Robert Klemme
|
03-03-2009 04:44 AM
Shakespeare | 1 | 114 |
| | | Hi
Is there any way one can query for a specific procedure's source code,
rather than the entire package body that it's within?
I know I can query...
Adam Cameron
|
03-02-2009 04:47 PM
jgar the jorrible | 6 | 134 |
| | | Hello Everybody,
I'm still having a hard time with the snapshots (materialized views)
in the Oracle 10g since we migrated from 9i.
I really need...
CenturionX
|
03-02-2009 03:32 PM
CenturionX | 1 | 182 |
| | | I have two relatively large procedures that differ only
by the contents of an "in (...)" clause, e.g.
create proc1 as
...
select foo from bar where...
mh@pixar.com
|
03-02-2009 05:13 AM
William Robertson | 3 | 90 |
| | | hello.
At work we have a Oracle 9 database and our report develpment
uses Report Builder 6.xxx
My questio is, which of the later versions of report...
Arthur 51
|
03-01-2009 04:30 AM
Arthur 51 | 0 | 116 |
| | | On Feb 27, 9:20*pm, Dave U. Random <anonym...@anonymitaet-im-
inter.net> wrote:
I think the most practical approach would be to sample the...
Mark D Powell
|
02-28-2009 10:31 AM
Mark D Powell | 0 | 96 |
| | | The following query will return 3 word in 3 "TABLE COLUMN", How can I
modify the query to return "NO 3 words are the same"?
the following Table will...
Carl Forsman
|
02-28-2009 05:29 AM
Maxim Demenko | 7 | 125 |
