| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi Folks,
I have an interesting problem. Basically, I have an oracle job that I
need to speed up as we are exceeding our allocated time window....
nisfar@gmail.com
|
10-21-2008 09:18 AM
nisfar@gmail.com  | 0 | 72 |
 | | Does Oracle 10g have a so called "natural sort" feature? E.g.:
foo1
foo2
foo10
foo100
.... rather than:
foo1
Álvaro G. Vicario
|
10-20-2008 07:25 PM
mh@pixar.com | 32 | 199 |
| | | Where I can find online articles that explain rules to transform entity
relationship diagram to object logic model?
Shearer
|
10-20-2008 10:52 AM
ddf | 4 | 66 |
| | | suppose I have a table t1 with one column and several rows of data:
name
----
foo
bar
baz
and that I want to insert some rows into another...
mh@pixar.com
|
10-20-2008 03:47 AM
mh@pixar.com | 24 | 226 |
| | | Title: Integration Analyst
Required_skills: Defence Logistics business knowledge,
Working knowledge of Unix scripting.
Practical knowledge of Oracle...
Amrut
|
10-17-2008 10:41 AM
Amrut | 0 | 43 |
| | | Hi,
I have a strange problem with oracle connection. It gives a "ERROR
ORA-12154 TNS: could not resolve the connect identifier specified"
srror on...
beta
|
10-16-2008 02:31 PM
Frank van Bortel | 56 | 452 |
| | | Accelerated PMP®
LIVE Virtual PROJECT MANAGEMENT Training
PMSOFT Consultancy Pvt. Ltd.
PMI REP, Global
Contact: pmsoftglobal (AT) gmail (DOT)...
makarand
|
10-16-2008 08:34 AM
ddf | 4 | 54 |
| | | I'm still playing with this one and looking for some solution in the
Oracle docs, but, can I have a UNION query and tell it which rows to
return and...
artmerar@yahoo.com
|
10-16-2008 12:52 AM
Peter Nilsson | 24 | 251 |
| | | Hi
I have a table T with columns A, B, C and an index I over all three
columns. Further, I have a query which uses columns A and B, but not
C,...
digory
|
10-14-2008 12:34 PM
sybrandb@hccnet.nl | 32 | 244 |
| | | Oracle Database 11g
http://oracle-certification-guide.blogspot.com/2008/10/oracle-database-11g-administrator.html
Oracle Database...
Oracle Certification Guide
|
10-13-2008 06:35 AM
Oracle Certification Guide | 0 | 47 |
| | | Hi,
during an simple INSERT into table in a stored function,
a ORA 1426 is raised. Thats OK, I already identified the
column that is exceeded.
I am...
Carsten Broschek
|
10-11-2008 03:15 AM
Carsten Broschek | 0 | 53 |
| | | Hello,
I have created a simple function for use in an update statement. The
fuction is
FUNCTION myfnc(p1 IN t1.c1%TYPE)
RETURN VARCHAR2
IS
BEGIN
IF...
Kevin S
|
10-10-2008 09:51 AM
Kevin S | 40 | 402 |
| | | Hi,
I have oracle 11g database and PHP application on my machine(A). One
of my PHP orogram need to connect to oracle 9g DB on a machine(B). Do
I...
beta
|
10-10-2008 03:19 AM
Laurenz Albe | 12 | 224 |
| | | Our company use rac 10g (10.1.0.4),we have two nodes,recently node one
always reboot,I guest maybe dead lock
,can anyone help me how to solve this...
choubou
|
10-09-2008 12:45 AM
sybrandb@hccnet.nl | 4 | 69 |
| | | I have a job that calls a stored procedure, specified
like this:
job_type => 'PLSQL_BLOCK',
job_action => 'begin qrunner_util.purge;...
mh@pixar.com
|
10-09-2008 12:39 AM
sybrandb@hccnet.nl | 4 | 169 |
| | | Suppose you have a table with a status column, and
the status can be one of "queued", "inprogress",
"failed", or "completed".
This can be enforced...
mh@pixar.com
|
10-08-2008 08:05 PM
mh@pixar.com | 12 | 126 |
| | | You can automate the installation and configuration of Oracle
software, either fully or partially, by specifying a response file
when you start the...
tritya
|
10-08-2008 06:13 PM
tritya | 0 | 59 |
| | | I'm try installing Oracle 10g on a pSeries RHEL 4.
I'm on the "Database Configuration Assistant" screen and the "Clone
database creation...
jim
|
10-08-2008 05:57 PM
Shakespeare | 48 | 225 |
| | | Hopefully this is not a dup post. I had to kill my last one to do
some typos.
I'm still playing with this one and looking for some solution in...
artmerar@yahoo.com
|
10-08-2008 03:43 PM
artmerar@yahoo.com | 0 | 174 |
| | | <mmf.stavelot (AT) gmail (DOT) com> wrote
Jim
gym dot scuba dot kennedy at gmail
|
10-07-2008 08:59 PM
Malcolm Dew-Jones | 16 | 116 |
| | | Hi,
To what can find an equivalent for function CONTAINSTABLE in Oracle?
MSSQL:
SELECT select_list
FROM table AS FT_TBL INNER...
mmf.stavelot@gmail.com
|
10-03-2008 05:41 PM
Malcolm Dew-Jones | 36 | 372 |
| | | I'm trying to install Oracle 10g Enterprise server on a Power series
RHEL 4 system. The installation guide says I...
jim
|
10-03-2008 03:29 AM
Laurenz Albe | 4 | 170 |
| | | Hi,
How to Identify Oracle Client version is 32bit OR 64 bit.
I need to idetify this as Application build with Oracle 64 bit
libraries does not work...
deepakhaldankar@gmail.com
|
10-03-2008 03:27 AM
Laurenz Albe | 12 | 340 |
| | | Hello everybody,
I created a package to build a query. This query has a bui dynamic
quantity os calculated fields and it overflows a simple...
CenturionX
|
10-02-2008 09:14 PM
Maxim Demenko | 16 | 89 |
| | | Tom Gugger
Independent Recruiter
tgugger (AT) bex (DOT) net
419-537-9447
Oracle Warehouse Management/ Functional/ Perm
We are currently searching...
Tom Gugger
|
10-02-2008 01:24 PM
Ed Prochak | 4 | 34 |
| | | Comments embedded.
On Sep 30, 6:51*pm, jms <jesus.m.sa... (AT) gmail (DOT) com> wrote:
Implements JDBC 2.0 result set functionality.
It does what...
ddf
|
10-01-2008 11:11 AM
ddf | 0 | 42 |
| | | Hi folks,
I'm running into a strange (at least to me) problem. I have
implemented a small document management system into an existing
Oracle10g...
Claus
|
10-01-2008 05:25 AM
Claus | 32 | 180 |
| | | Any such thing? I would like to passively capture and decode
the traffic going between oracle clients and the server.
Many TIA,
Mark
--
Mark...
mh@pixar.com
|
10-01-2008 12:57 AM
Michel Cadot | 4 | 39 |
| | | I have this query:
SELECT customer_id, co.order_id, p.product_id, ol.status, p.code,
p.subproduct_id,
FIRST_VALUE(ol.status)
OVER (PARTITION BY...
art@mickeyschicago.com
|
09-30-2008 08:47 AM
art@mickeyschicago.com | 20 | 330 |
| | | Hi,
I am beginning to like these analytical functions. Especially with
10g they seem to have a lot of options. Anyhow, I have a simple query
like...
mike@adlineservices.com
|
09-30-2008 12:54 AM
Peter Nilsson | 16 | 132 |
| | | I am trying to get the same resultset with an original query but one
last column less.
For example the original query is "select x,y,z from table1...
dt1649651@yahoo.com
|
09-29-2008 10:09 PM
Malcolm Dew-Jones | 56 | 273 |
| | | I have this query:
SELECT customer_id, co.order_id, p.product_id, ol.status, p.code,
p.subproduct_id,
FIRST_VALUE(ol.status)
OVER (PARTITION BY...
art@mickeyschicago.com
|
09-29-2008 04:33 PM
art@mickeyschicago.com | 0 | 73 |
| | | I am wondering if I can create a complex query in oracle that
simulates an Access crosstab. The data is comprised of measurments
created from fish...
Timo
|
09-29-2008 01:04 PM
ddf | 20 | 91 |
| | | http://www.365jobs4u.com/idevaffiliate/pages/2204.php
sonu
|
09-28-2008 01:17 PM
DA Morgan | 4 | 41 |
| | | I am testing a 2 node RAC setup and want to try using a SAN for the
dedicated storage (instead of a dedicated local storage disk array
located within...
macdba321
|
09-27-2008 01:13 AM
DA Morgan | 44 | 258 |
| | | Global business intelligence vendor Yellowfin is investing in the best
available Java technologies and people to stay at the forefront of web-
based ...
JTP PR
|
09-26-2008 06:21 AM
JTP PR | 0 | 60 |
| | | Hi,
I am learning Oracle, my PM asked me the following question, Please
help me on this :
You are a new employee at the company and the only Oracle...
raja
|
09-25-2008 12:19 AM
gym dot scuba dot kennedy at gmail | 4 | 122 |
| | | Given a table FOO, what is the easiest way to create a
table COPY_OF_FOO that has identical schema, indexes, etc.?
Preferrably something that can be...
mh@pixar.com
|
09-24-2008 04:49 PM
mh@pixar.com | 12 | 95 |
| | | What I'm trying to do is this:
Write a script that will pull a list of filenames with a specific
extention, from a specific directory, into an...
blindsey
|
09-24-2008 05:29 AM
Thomas Blankschein | 8 | 62 |
| | | I’ve learnt that setting an environmental variable called NLS_LANG in
the client computer makes client apps send and receive data in the
correct...
Álvaro G. Vicario
|
09-23-2008 11:17 AM
Álvaro G. Vicario | 8 | 74 |
| | | Hi,
what's the most efficient way to search rows in a (big) table preventing FK
to be created;
we've a table where PK consists of several columns and...
timo
|
09-23-2008 01:40 AM
timo | 12 | 171 |
| | | Hi
I am trying to use WinHttp.WinHttpRequest.5.1 to access an https (ssl)
page on an Oracle-Application-Server-10g and I keep getting a
-2147483638...
Brian Pitt
|
09-18-2008 12:36 PM
Brian Pitt | 0 | 62 |
| | | World Moving & Storage facility Moving services takes ownership of the
supply chain process. We act as an extension of your company to
provide...
World Marketing
|
09-17-2008 11:09 PM
Ana C. Dent | 4 | 46 |
| | | Hi.
I have to open an ado connection from access toward db oracle 11g
It's simple but i have to set oracle db case insensitive
How can i set db...
tiro
|
09-17-2008 06:03 AM
gazzag | 24 | 151 |
| | | I am looking for help in understanding the software/configuration
architecture to connect to an oracle database from a html/javascript web
page.
I...
Louis
|
09-16-2008 05:56 AM
gazzag | 12 | 88 |
| | | California Moving Companies call 310-925-1720
Services offered:
family House or singel studio apartment moving
Employee relocation Nationwide...
World Marketing
|
09-15-2008 08:54 PM
World Marketing | 0 | 46 |
| | | Hi,
I was wondering if I can display data like this:
Original Data
01-JUN-08 Type1 Add 4308
01-JUN-08 Type1 Delete ...
Mtek
|
09-15-2008 12:53 PM
sybrandb@hccnet.nl | 24 | 160 |
| | | Hi,
I saw a similar post by someone else but there was no replies.
I need to write a query that will return columns in the same result
row. The...
Mtek
|
09-15-2008 09:17 AM
Mtek | 0 | 155 |
| | | Hi,
I saw a similar post by someone else but there was no replies.
I need to write a query that will return columns in the same result
row. The...
Mtek
|
09-15-2008 09:00 AM
Mtek | 0 | 51 |
| | | "Dereck L. Dietz" <dietzdl (AT) ameritech (DOT) net> wrote in
news:pgazk.236$pr6.77 (AT) flpi149 (DOT) ffdc.sbc.com:
No programming language knows...
Ana C. Dent
|
09-14-2008 01:09 PM
Ana C. Dent | 0 | 68 |
