| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Completely agree
And things like Hibernate tend to make this situation even worse as people ge the impression they don't need to think about the...
Thomas Kellerer
|
12-15-2009 11:39 AM
Gerard H. Pille  | 12 | 209 |
 | | the pawerfull book to learn oracle 10 g free download for a limited
time don't miss this
http://tinyurl.com/y9pfppe
aghla brahim
|
12-15-2009 08:18 AM
aghla brahim | 0 | 87 |
| | | Hello,
Urgently looking for Oracle client 8.1.7.2 installation package for
windows. Or just imp.exe. and exp.exe from this version.
Can anybody...
robi67
|
12-15-2009 04:53 AM
gazzag | 4 | 131 |
| | | Here are all the Imp tables used in oracle Financials
http://www.ezdia.com/Basic_Tables_in_Oracle_Financials/Content.do?id=81
Additya
|
12-14-2009 05:55 AM
Additya | 0 | 106 |
| | | a b c time
a b d time
a b e time
a b c time
a b x time
a b d time
I want to count all the c -> x transitions found in adjacent rows.
The table is...
cate
|
12-12-2009 10:09 AM
cate | 2 | 113 |
| | | This one is kind of confusing. The max length of a VARCHAR2 is
4000. So, I call a stored procedure passing is a value that is 3278
characters...
The Magnet
|
12-12-2009 07:24 AM
Gerard H. Pille | 6 | 140 |
| | | Hi all,
Let's say I have the canonical employee table. Let's say I have a
dept_id field.
Let's say that there are 1000+ employees in each...
Sashi
|
12-11-2009 02:15 PM
Sashi | 2 | 113 |
| | | So, the max length of VARCHAR2 is 4000 bytes. So, in PL/SQL, if you
need to declare a variable longer than 4000, what can you use? We
need to...
The Magnet
|
12-10-2009 03:07 PM
Dan Blum | 8 | 238 |
| | | Ben Finney wrote on 28.11.2009 00:12:
This can be done a lot easier including the surpressing of repeating values
(works in Postgres and...
Thomas Kellerer
|
12-08-2009 07:38 PM
Ben Finney | 27 | 333 |
| | | Greetings,
I have a table format as below
sec value type
X 100 T
X 200 S
Y 300 ...
Pankaj
|
12-05-2009 08:12 AM
Gerard H. Pille | 5 | 157 |
| | | I have a database that was cloned a bit ago. I was looking at v
$log_history on the Data Guard side of things and found some wierd
stuff.
RECID ...
eAddict
|
12-02-2009 05:11 PM
ddf | 1 | 124 |
| | | Hello,
when I hibernate my windows xp pc with a open Forms 6 appllication, when
it comes back to life I have to close the form and reopen it.
Is...
Andreas Moroder
|
11-30-2009 11:07 AM
Andreas Moroder | 0 | 108 |
| | | In DB2 you can do something like the following:
SELECT *
FROM MYTABLE
WITH UR;
If you have, say, a batch application that is inserting a lot of...
Frank Swarbrick
|
11-27-2009 07:45 PM
Mark D Powell | 4 | 122 |
| | | I've got an application being put together with cake/php. It's
pretty nice, but their data pager does this:
SELECT COUNT(*) AS COUNT
FROM foo...
mh@pixar.com
|
11-27-2009 07:39 PM
Mark D Powell | 11 | 212 |
| | | As promised in October, we are back with the latest refreshing issue
of Oracle Connect - Oracle Newsletter with the current topics
surrounding the...
iware
|
11-26-2009 08:51 AM
iware | 0 | 97 |
| | | Do you know of any newsgroups where I might ask about performance related
questions. .
Database Version
============
Oracle9i Enterprise Edition...
Trevor Benedict
|
11-25-2009 11:26 AM
Mark D Powell | 2 | 110 |
| | | Hello!
My client told me that one Oracle form behaves strangly.
We (as programmers) use Oracle Forms ver 6 with all patches released...
N.M.
|
11-25-2009 04:47 AM
Shakespeare | 5 | 106 |
| | | Hi,
ich will in einem RichEdit einfach ein Stückchen Text anzeigen, so eine
Art Programmbeschreibung. Diese sollte aber eben formatiert sein...
Andreas Mosmann
|
11-20-2009 12:50 PM
Andreas Mosmann | 1 | 129 |
| | | Hi,
I have a Java app that connects to an Oracle DB and I'm having
problems when saving data that include some characters that are only
available in...
Barney
|
11-20-2009 02:30 AM
Laurenz Albe | 1 | 112 |
| | | Hi,
When tracing SQL statements from SQLPLUS to see consistent gets and
such, if the query contains bind variables or constants, how do...
The Magnet
|
11-19-2009 03:37 PM
Charles Hooper | 3 | 121 |
| | | We at Nob Hill Software are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on the...
Mia
|
11-18-2009 05:19 PM
Robert Klemme | 1 | 126 |
| | | Hi sql gurus,
I need some help and also curious on how to write this in single sql
statement, requirements goes like this
Table...
RA
|
11-18-2009 10:19 AM
Frank van Bortel | 6 | 177 |
| | | So far I had been mostly satisfied with Pro*C/C++. It is a huge
improvement from by previous programming environment (OCI. I can't
believe I ever...
Ramon F Herrera
|
11-18-2009 10:13 AM
Frank van Bortel | 4 | 118 |
| | | Hi all, I'm trying to write where appears to be a simple query but
can't get it right.
Here's the intent.
update A set (a1,a2,a3) = (select...
Sashi
|
11-17-2009 11:10 PM
Sashi | 8 | 164 |
| | | Hi ng,
I hope, there is someone with a good idea concerning the following
question:
There is a sorted Table (or view) like the...
Andreas Mosmann
|
11-17-2009 11:48 AM
Andreas Mosmann | 9 | 157 |
| | | Hi,
I was poking around and took a look at v$waitstat:
CLASS COUNT TIME
------------------ ---------- ----------
data block...
The Magnet
|
11-13-2009 04:50 AM
Vladimir M. Zakharychev | 2 | 144 |
| | | Hi,
I'm not sure that this is a proper forum for this question but...
I'm having a problem with setting the InitialLOBFetchSize to -1 in
order to...
gotpewi
|
11-12-2009 10:16 AM
Mark D Powell | 1 | 109 |
| | | Our department is uses 10g.
We will be loading PDF files and/or pictures into our database.
What are the pros and cons verses Bfile and Blobs. What...
Rich
|
11-12-2009 10:14 AM
Vladimir M. Zakharychev | 5 | 156 |
| | | Greetings,
Table structure
test_users
Data:
role user
12 James
Pankaj
|
11-11-2009 07:42 PM
Pankaj | 6 | 141 |
| | | Hi all, I have a dmp file that contains about 9 million rows.
Is there a utility/technique that will split the file into two (or
more) so that I can...
Sashi
|
11-11-2009 06:26 PM
joel garry | 6 | 105 |
| | | I've got some simple reports to generate. It would be nice if they
could be put on the web and also generate PDFs.
These reports are for internal...
mh@pixar.com
|
11-10-2009 01:09 PM
joel garry | 2 | 96 |
| | | Hi all,
I have a table with a time stamp with timezone column:
CREATE TABLE TEST_TZ
(
DATE_TIME_TZ TIMESTAMP(3)
);
Björn Wächter
|
11-06-2009 04:39 PM
Robert Klemme | 2 | 122 |
| | | As promised in Sample Questions Set I, we are back with Siebel 8.0
Consultant Certified Expert Exam - Sample Questions Set II (Exam...
iware
|
11-05-2009 07:57 AM
iware | 0 | 105 |
| | | Download free Oracle books
BOOK 1
http://tinyurl.com/ylba2ta
BOOK 2
http://tinyurl.com/yfg3lm6
ENG
|
11-05-2009 06:26 AM
ENG | 0 | 111 |
| | | Hi,
I want to get the column_name of the maximum value of a row. To
simplify, the table has the following format and values, with
input_date being...
Ninja Li
|
11-05-2009 04:55 AM
modu | 7 | 184 |
| | | Hi there,
I have been scouring the Oracle website, but cannot find any download for
the Oracle9i Client.
I want to use MS Access to make a ODBC...
Frederick Smith
|
11-04-2009 12:17 PM
joel garry | 8 | 167 |
| | | Hi,
I need some help.
Shell script counter. i need to add condition to check if counter is
more than 10 and longer than 3 hours? it runs every 5...
orion
|
10-29-2009 09:53 AM
Mark D Powell | 1 | 107 |
| | | We have 10 redo logs each of 150M in size and 2 members in each group.
We have been constanly getting a message of CHECKPOINT NOT
COMPLETE.
What can...
Michael
|
10-29-2009 08:58 AM
Frank van Bortel | 1 | 94 |
| | | I am trying to duplicate a production database - version 10.2. 0.1.0.-
in a different server and I started the instance with nomount. Then...
Michael
|
10-29-2009 08:22 AM
Frank van Bortel | 3 | 111 |
| | | complete ccnp(E Books,video,dumps)
http://mynetworkplanet.blogspot.com/2009/10/complete-ccnpe-booksvideodumps.html
CISCO IOS...
sabya
|
10-29-2009 03:09 AM
sabya | 0 | 78 |
| | | I've got a program that uses OCI Change Notification callbacks.
On my test system, everything works perfectly... I get a callback
every time I...
Mark Harrison
|
10-28-2009 04:17 PM
Mark Harrison | 0 | 80 |
| | | Version information:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
We have a materialized view that takes approximately 3 hours to...
kes
|
10-28-2009 01:53 PM
kes | 2 | 105 |
| | | Oracle Connect Newsletter
To view this click on the following link or copy paste below link on
the...
iware
|
10-27-2009 11:22 AM
joel garry | 1 | 76 |
| | | hello to all.
if i am working in a client side and suddenly lost the connection
between me and oracle server, then what the server do to...
karim
|
10-22-2009 09:45 AM
Mark D Powell | 1 | 102 |
| | | All my database accesses are done through Pro*C/C++.
Sometimes my code needs to verify whether a table exists. Years ago, I
was about to post that...
Ramon F Herrera
|
10-20-2009 07:17 AM
Noons | 24 | 226 |
| | | i need a six months project related databse in oracle 10 g
m student of BEIT in final semster so plssssssssssss tell me about a
good...
sardar1
|
10-19-2009 05:09 PM
joel garry | 1 | 113 |
| | | Hi Guys
I have Report which display in Below format
Project Name:XYZ
Descrption ChargeNumber Start
End Mon ...
Purvik
|
10-19-2009 03:11 PM
Purvik | 0 | 88 |
| | | Current stories of Bollywood stars,Gossips,Horoscops,Music,Wallpappers
& much more.......visit
http://www.Bollywoodmasalainhindi.blogspot.com
abdul
|
10-19-2009 01:38 PM
abdul | 0 | 86 |
| | | Hi all, I'm trying to do something like this.
update myTable
case length(duration)
when 8 then set hours = substr(duration,1,2)
else set hours =...
Sashi
|
10-15-2009 10:48 PM
Sasikanth Malladi | 2 | 93 |
| | | Dynamic queries suck! But, our setup is that we have a table with
application stored queries. PHP calls a stored procedure, passing it
parameters...
The Magnet
|
10-14-2009 01:17 PM
joel garry | 6 | 102 |
