| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
I'm looking around for an example of this. Can you update a table
with a DECODE statement which gets values from another table?
So, something...
Mtek
|
06-24-2008 01:39 PM
Terry Dykstra  | 7 | 19 |
 | | 10.2.0.2 EE aix 5.2
we have a server that somehow got behind in time by 5 minutes. I
mentioned it to the sysadmin and next thing I knew she had...
Ben
|
06-24-2008 11:52 AM
Juha Laiho | 28 | 39 |
| | | Hi,
is there a possibility to use the dbms_stats package on schema level
to just see which tables would be affected by the gather_auto option?
I...
michael.spoden@web.de
|
06-24-2008 10:38 AM
fitzjarrell@cox.net | 42 | 76 |
| | | I used "alter system set nls_sort = binary_ci scope = spfile" to
change the default value of the parameter nls_sort.Then I restarted
the service of...
gzjacklee@gmail.com
|
06-24-2008 03:40 AM
gzjacklee@gmail.com | 14 | 30 |
| | | Hi Group,
Oracle 10G - This is my problem:
There's a table containing a time series like
date,val
1.1.08,2
2.1.08,1
3.1.08,4
steph
|
06-23-2008 02:18 PM
steph | 21 | 46 |
| | | Hello,
I'm looking for the RDBMS 10.2.0.3 patchset for Windows 2003 Server
for 64Bit x86 on Metalink. It appears that
it it keeps defaulting to the...
howard
|
06-23-2008 12:18 PM
bdbafh | 7 | 24 |
| | | "Marcin Wróblewski" <m_wroblewski (AT) gazeta (DOT) pl> wrote
1. Very poor application design to use auto commit.
2. Sql= stands for Structured...
bobdurie@gmail.com
|
06-23-2008 11:25 AM
bobdurie@gmail.com | 28 | 45 |
| | | Is there any way to determine from the RMAN catalog what MML was used to
create a backup set? We are in the process of switching from TDPO to...
Chuck
|
06-23-2008 11:19 AM
Steve Howard | 14 | 31 |
| | | Hi,
I need to create a function that does the following.
I/P is "LONDON,CHICAGO,SANFRANCISCO"
O/P is 'LONDON','CHICAGO','SANFRANCISCO'
This is...
vharicharan
|
06-23-2008 09:09 AM
fitzjarrell@cox.net | 7 | 16 |
| | | On Jun 21, 11:39*pm, "Dereck L. Dietz" <diet... (AT) ameritech (DOT) net> wrote:
I have got a same problem before it was because of the...
vijay
|
06-23-2008 04:08 AM
yusaku.furuhashi@gmail.com | 14 | 46 |
| | | Oracle 10.1 here. I know there is built in pivoting in Oracle 11, but
until we get it...
I found two wonderful pieces of code that can ALMOST do...
trbosjek
|
06-22-2008 09:01 AM
trbosjek | 84 | 145 |
| | | <chris.brown (AT) providentinsurance (DOT) co.uk> schreef in bericht
news:2a44625e-546f-453a-9387-9e0935d09052 (AT) 25g2000hsx (DOT)...
Shakespeare
|
06-21-2008 02:37 PM
Mladen Gogala | 32 | 47 |
| | | "Dereck L. Dietz" <dietzdl (AT) ameritech (DOT) net> schreef in bericht
news:F3D6k.10505$uE5.689 (AT) flpi144 (DOT) ffdc.sbc.com...
Grant select on...
Shakespeare
|
06-20-2008 12:47 PM
Mark D Powell | 7 | 18 |
| | | Looking for assistance in unregistering old dbid's from the rman
catalog. The db in question is a test db that is duplicated from a
production db...
Chuck
|
06-20-2008 09:58 AM
Chuck | 14 | 39 |
| | | One of the systems we are testing on is a quad core xeon 32 gig ram
running OEL 5.1 64 bit. I have both 10.2.0.4 64 bit and 11g 64 bit.
Using EMC...
hpuxrac
|
06-20-2008 08:38 AM
hpuxrac | 7 | 20 |
| | | Hi,
Oracle10g 10.2.0.1 (32 bit) - Recovery Catalog version
Oracle10g 10.2.0.2 (64 bit) - target database version
RHEL AS 4.4
I have a requirement...
wagen123@yahoo.com
|
06-20-2008 07:33 AM
sifobo | 7 | 24 |
| | | On Jun 19, 4:08 pm, Donkey Hot <s... (AT) plc (DOT) is-a-geek.com> wrote:
Yeah, I was hoping to avoid creating a function.......but if it the
only...
Mtek
|
06-20-2008 03:26 AM
Mladen Gogala | 70 | 84 |
| | | Hello, Oracle 10.2.0.3 on SUSE Linux here.
Since yesterday, the archiver seem not to be able to archive logs
anymore. The database is set up to...
yossarian
|
06-18-2008 01:00 PM
joel garry | 56 | 66 |
| | | Hi,
Quick question here, if I have a WHERE clause with an IN condition -
WHERE var IN (1, 2, 3)......
What if the list is dynamic? How would you...
Mtek
|
06-18-2008 04:15 AM
yossarian | 63 | 97 |
| | | "buu" <aha@a.com> wrote
This is expecially true if you have a multi column primary key and you are
retrieving data via the leading edge of the key....
buu
|
06-18-2008 02:38 AM
Robert Klemme | 49 | 67 |
| | | Dear all,
Sifobo Enterprise Manager for Oracle And SQL Server is an MMC based
Oracle and SQL database backup manager for Windows and available...
sifobo
|
06-18-2008 12:50 AM
sifobo | 0 | 15 |
| | | I run 10.2.0.1.0 and use Administration Assistant for Windows.
It worked fine
Then the error was:
Snap-in failed to...
test_1t@hotmail.com
|
06-17-2008 03:15 PM
Frank van Bortel | 21 | 33 |
| | | Hello,
I have RAC 10g R2 on Win 2003 and I am trying to find a way to backup
the D:\oracle. I don't really
want to use a third party backup client...
howard
|
06-17-2008 02:14 PM
joel garry | 35 | 52 |
| | | On Jun 13, 10:32 pm, AGT <usenetpersonger... (AT) gmail (DOT) com> wrote:
The zones are here to stay. We sell a turnkey solution that runs...
groups.broberg@gmail.com
|
06-17-2008 09:07 AM
mpacheco_brazil@hotmail.com | 49 | 75 |
| | | Hi quick question
We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.
Exported from 9i...
jeremy
|
06-17-2008 06:05 AM
gazzag | 147 | 173 |
| | | Hello
i am looking at V9 and try to figure out the equivalent command in
oracle
of update statistics high for table mytable(mycolumn) in...
Superboer
|
06-17-2008 05:22 AM
Superboer | 28 | 49 |
| | | Hi All,
I have been trying to connect by using DOS/command Prompt to my
database, but I get an TNS--03505 error. What is weird is I get
connection...
BeginnerDBA
|
06-16-2008 03:36 PM
fitzjarrell@cox.net | 7 | 12 |
| | | For an accounting / banking database, I have the following in a two
transaction tables showing what someone spends or credits:
Transaction Table...
jmDesktop
|
06-16-2008 03:06 PM
Ed Prochak | 7 | 13 |
| | | I am using 10.2.0.3 on HP UNIX 11i. I set cursor_sharing=exact.
I created a stored outline using:
alter session set...
zigzagdna@yahoo.com
|
06-15-2008 04:53 PM
zigzagdna@yahoo.com | 7 | 13 |
| | | WOW!! Get seen -- get paid! You can now get paid to drive your car,
wear T-shirts, and more! Just join the EyeEarn Advertising Network and
start...
PRINCE
|
06-15-2008 07:30 AM
PRINCE | 0 | 13 |
| | | Hi,
Oracle 9.2.0.6 W2000
When I run : administration assistant for windows NT
then process information
info on threads are empty
do you know why...
astalavista
|
06-15-2008 04:33 AM
astalavista | 0 | 16 |
| | | Find all the help you need here ...
http://niknatnetb.dba2006.hop.clickbank.net/
Nik
|
06-14-2008 08:21 PM
Nik | 0 | 14 |
| | | Hi,
Can Oracle 10g XE install in Windows Embedded point of service?
Ming
leo@tech-trans.com
|
06-14-2008 11:25 AM
leo@tech-trans.com | 28 | 45 |
| | | Dog Grooming
Those of us who are groomers are aware of what a stressful job
grooming can be. Dogs can be barking, the phone can be ringing,...
vaticans.org
|
06-14-2008 07:48 AM
vaticans.org | 0 | 18 |
| | | About a year ago, the company that I work for purchased another
company. We're a large SQL Server shop, but this new company has a
mix of SQL Server...
Tracy McKibben
|
06-14-2008 06:16 AM
Frank van Bortel | 154 | 188 |
| | | Training Classes for Oracle10g, 9i, 8i
Certification training in Oracle10g and 9i: DBA, Developer,
Discoverer. training conducted at your location...
Jack
|
06-14-2008 06:13 AM
Frank van Bortel | 7 | 17 |
| | | Financial Access Controls
Are your daily business operations protecting you against fraud, theft
and unfavorable audits? ExpenseWatch offers online...
Jack
|
06-14-2008 06:11 AM
Frank van Bortel | 7 | 14 |
| | | Online Oracle Classes
Find online Oracle training courses. Search schools, get program info.
http://a.uuload.com/Oracle.htm
Pass Your Oracle Exam -...
Winder
|
06-14-2008 01:16 AM
Winder | 0 | 15 |
| | | Hi,
Do anyone have Cisco VPN Client for Vista?
Thanks,
DK
DK
|
06-13-2008 07:34 PM
hpuxrac | 35 | 58 |
| | | On Fri, 13 Jun 2008 09:27:07 -0400, Walt wrote:
Sales rep delays one customer until there is no more "duplicate key in
index" issue or the customer...
Mullin Yu
|
06-13-2008 04:40 PM
Mladen Gogala | 21 | 41 |
| | | Hi,
We are looking at securing our Oracle Databases containing customer
Data with Oracle Database Vault and Audit Vault. Are there any...
prashk2005@gmail.com
|
06-13-2008 01:26 PM
DA Morgan | 42 | 85 |
| | | What are the main differences between NUMBER(p) and INTEGER for
storing integer values? Is there any difference with space or
performance?
I...
dananrg@yahoo.com
|
06-13-2008 01:08 PM
joel garry | 21 | 41 |
| | | What is the maximum extent size possible in locally managed
tablespaces (LMT) with autoallocate?
Let me clarify the question: I am interested in...
Vsevolod Afanassiev
|
06-13-2008 11:14 AM
Anurag Varma | 28 | 39 |
| | | Is it possible to create a view based off DBA_ROLES so that a non-DBA
user can keep track of which users belong to roles associated with...
dananrg@yahoo.com
|
06-13-2008 10:54 AM
dananrg@yahoo.com | 28 | 42 |
| | | Hi All,
We are developing web application on Oracle DB 10g and Oracle Apps
Server (ADF) on RH Linux. We have requirement as follow :
Users from all...
krislioe@gmail.com
|
06-12-2008 10:24 PM
krislioe@gmail.com | 0 | 14 |
| | | I have a 7.3.4.5.0 instance, that does hot backups to another machine via
NFS. The NFS server had issues this weekend, and I believe that...
Stan Brown
|
06-12-2008 03:18 PM
Stan Brown | 42 | 57 |
| | | Hi,
I was wondering if anyone could help me with the below strange
occurance?
We have a Pro*C application running on our DB server (jurassic...
malcolm
|
06-12-2008 02:39 PM
joel garry | 28 | 40 |
| | | On Jun 9, 8:20*pm, "Dereck L. Dietz" <diet... (AT) ameritech (DOT) net> wrote:
A clustered hash table by default allows duplicate key values to...
Mark D Powell
|
06-11-2008 10:57 PM
Michael Austin | 5 | 13 |
| | | Hi,
Is possible to optimize the tainted query below ?
(explain plan at bottom)
Thanks for your help (10.2.0.3)
astalavista
|
06-11-2008 10:15 PM
Steve Howard | 14 | 22 |
| | | I am using Oracle 10.2.0.3 on Windows 2003. My project
Currently uses cursor_sharing=force which nesures after syntheitised
bind variables are...
zigzagdna@yahoo.com
|
06-11-2008 08:28 PM
zigzagdna@yahoo.com | 0 | 18 |
