| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I've got Oracle XE installed on my desktop so I can explore and learn
Oracle preparatory to converting our apps from Sybase to Oracle. I
also have...
Tim Slattery
|
07-19-2008 05:15 PM
Ruud de Koter  | 16 | 69 |
 | | Oracle 9i Install How to
Oracle 9i DBA Guide .pdf
Oracle 11i concepts .pdf
Oracle Documentations
Oracle OCP Admin Exam doc
Advanced Oracle PL/SQL...
Oracle Help
|
07-19-2008 01:07 AM
Oracle Help | 0 | 31 |
| | | How can I encrypt a field in a Oracle table ( Oracle 8i) so that apart
from any specific user it will show the encryted figure to the rest
while...
baadsha2008@gmail.com
|
07-18-2008 01:14 PM
Mark D Powell | 4 | 23 |
| | | I'm trying to import a fixed-length ASCII file using SQLLDR.
The end-of-line is 0D 0A, as usual.
But some notes fields in the data use 0D 0D 0A...
blindsey
|
07-18-2008 02:36 AM
Laurenz Albe | 8 | 37 |
| | | Hello
I am a junior dba. I was wondering if anyone could point me how to do
the following?:
I am currently trying to verify/calculate the size of...
ph3ng
|
07-17-2008 01:06 PM
Ed Prochak | 12 | 50 |
| | | Oracle9i Application Server
http://freedownloadablebooks.blogspot.com/2008/02/oracle9i-application-server.html
Summary of Oracle...
anitha
|
07-16-2008 01:11 PM
joel garry | 4 | 24 |
| | | My platform is
Windows 2003 Server Enterprise Edition
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
I'm using Oracle Objects for OLE,...
vSzemkel@o2.pl
|
07-16-2008 11:46 AM
vSzemkel@o2.pl | 0 | 33 |
| | | Choose your requirement from the following list of IDES Software
SAP IDES for Your Personal Practice at Home.
I. SAP ECC 6.0 SR2 12DVDs +...
balakumar
|
07-16-2008 10:51 AM
balakumar | 0 | 26 |
| | | Hi,
Ok, I need help with this. Here is my data:
TABLE A
---------------
2468
3690
1357
Mtek
|
07-16-2008 08:48 AM
Ken Denny | 12 | 44 |
| | | Hi,
I can't do a create table in a package procedure. A drop jedoch is
possible.
With google I doesn't find any hint for a necessary...
Norbert Winkler
|
07-16-2008 02:21 AM
Norbert Winkler | 24 | 76 |
| | | Hello, anyone know of any good quality tutorials for PL/SQL or
medium/advanced SQL? I'm looking for something like videos with example
source code...
seannakasone
|
07-15-2008 09:26 PM
seannakasone | 0 | 29 |
| | | My platform is
Windows 2003 Server Enterprise Edition
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
I'm using Oracle Objects for OLE,...
Marcin Buchwald
|
07-15-2008 07:36 AM
Marcin Buchwald | 0 | 36 |
| | | how can i design a front end in oracle
neeraj jain
|
07-14-2008 04:11 PM
joel garry | 8 | 20 |
| | | This should be so simple, yet it is not working. I am trying to do an
insert into a table where the values inserted are gathered from a select
from...
sheldonlg
|
07-13-2008 11:14 AM
sheldonlg | 24 | 60 |
| | | Hi,
I need to test if an entity exist in a document set. For instance, test
if there is any "Location" in a given set of 42 documents. I don't...
Hugo
|
07-11-2008 01:40 PM
joel garry | 28 | 61 |
| | | Is there a way to write a sqlplus batch file to "recompile all invalid
objects", or at least compile a specific object? I know the capacity
exists in...
Ubiquitous
|
07-11-2008 10:45 AM
DA Morgan | 45 | 294 |
| | | I have a statement that executes in SQL*Plus but not within Pro*C.
I'm guessing it has to do with where the nested select is (I know it
works from...
Brandon
|
07-11-2008 09:20 AM
Brandon | 0 | 40 |
| | | Hi all,
10.2.x on Linux ...
Is there a "neater"/more efficient way of selecting the maximum value for
a column based on the maximum value of...
Geoff Muldoon
|
07-10-2008 11:53 PM
Geoff Muldoon | 0 | 28 |
| | | Can you set the currval in a sequence without having to drop and recreate
the sequence? I rather not have to drop and recreate something because...
seannakasone
|
07-10-2008 08:02 PM
joel garry | 12 | 45 |
| | | Hi,
My requirements have been changed. I want to know if a query can be
created that does the following, or am I stuck creating a function...
Mtek
|
07-10-2008 11:18 AM
Michael D O'Shea | 8 | 24 |
| | | Hi,
Does anybody know if there is any difference between ‘*’ and ‘.*’
regular expressions in Oracle? Both seem to work similarly.
Best regards,
lp
popko.lukasz@gmail.com
|
07-10-2008 11:06 AM
popko.lukasz@gmail.com | 8 | 23 |
| | | Hi,
how can I find out when the last synchronization of the context index
was done? I'm using the ctxsys.ctx_ddl.sync_index package.
In dba_objects...
michael.spoden@web.de
|
07-08-2008 08:43 AM
Tim Arnold | 4 | 35 |
| | | Hi,
I'm using context indexes in my database. For synchronization the
ctxsys.ctx_ddl.sync_index package is used. How can I find out when the
last...
michael.spoden@web.de
|
07-08-2008 05:26 AM
michael.spoden@web.de | 0 | 26 |
| | | Hi all,
I set up two dbs with streams replication (A and B)
A gets all inserts that are replicated to B.
When replication stops and is started again...
adirtymindisajoyforever
|
07-08-2008 04:42 AM
adirtymindisajoyforever | 0 | 22 |
| | | Hi all,
I'm trying to update a materialized view:
EXECUTE DBMS_MVIEW.REFRESH('NED_PRODUCT_CARD_MV', 'C');
This commands hangs for a very long time...
Sashi
|
07-07-2008 12:30 PM
Sashi | 4 | 36 |
| | | Dear Freinds
I came across a website which conducts Free Webinars on PMP
Certification (Project Management Institute, USA) Awareness and...
makarand
|
07-07-2008 09:25 AM
makarand | 0 | 27 |
| | | Hello,
Is it possible to download somewhere JDBC Driver 8.1.6 ?
I would need to connect an old Oracle 7 database
(The oldest one I found is...
Michel
|
07-05-2008 02:52 PM
Robert Klemme | 4 | 22 |
| | | I'm looking to see if anyone knows where I can get a used copy of the Oracle
8i to 10g training materials.
Thanks,
Oracle DBA
Oracle DBA
|
07-03-2008 08:49 PM
Oracle DBA | 0 | 22 |
| | | What is the best way to export any of the following:
1. Whole Schema, or
2. All Tables with Row Header information, or
3 Individual tables with...
BookerT
|
07-02-2008 10:30 AM
timmg | 48 | 99 |
| | | (CDT) Tue Jul 1, 2008 10:45am -- Announced today, the next release of
Yellowfin Business Intelligence, 4.0 is scheduled for the end of July.
Whilst...
Yellowfin
|
07-02-2008 07:32 AM
Yellowfin | 0 | 22 |
| | | This code will compare a column to a variable:
declare myx number;
begin
select * from foo where x=myx;
end;
but suppose I have a variable with the...
mh@pixar.com
|
07-01-2008 06:40 PM
Maxim Demenko | 24 | 53 |
| | | Hi Guys,
I need a little help putting a query together as I'm pulling my hair
out. I'm getting two values, one from each table. Table 1 has...
DeanL
|
06-25-2008 10:36 PM
DeanL | 0 | 25 |
| | | On Jun 25, 2:24*pm, Krzysztof Jamróz <SpAMkrzyh000J... (AT) ZLYo2 (DOT) pl>
wrote:
Also of possible interest on the topic of creating or extracting...
Norbert Winkler
|
06-25-2008 02:40 PM
Mark D Powell | 12 | 48 |
| | | Hello All
In oracle ERP BOM, I want to Copy engingeer BOM from a
organization to other organization, How can I do?
frank
|
06-25-2008 04:20 AM
frank | 0 | 27 |
| | | I am preparing for 1z0--047 now. There is one question I can not
understand.
View the Exhibit and examine the structure of the ORDERS...
OracleDream
|
06-25-2008 02:54 AM
Shakespeare | 4 | 22 |
| | | Hai all, I like to share my oracle DBA Blog. Visit it and check if it
is useful for you. Thank you.
http://arjudba.blogspot.com
To know about How to...
Arju
|
06-24-2008 09:13 PM
DA Morgan | 20 | 82 |
| | | Getting this message may mean that port 389 and port 636 are not
available to the oracle installer. If tunneling over stunnel, be sure
to allow both...
bl8n8r
|
06-24-2008 04:29 PM
bl8n8r | 0 | 29 |
| | | I have two problems I think are related. When I click go to oracle
database from the desktop I get can not find page. If I change the ip
adress to...
Brian Blair
|
06-24-2008 04:25 PM
Frank van Bortel | 8 | 22 |
| | | Hello,
I have basic questions on how one best organizes primary keys (and
also foreign keys) and data integrity in an enviroment where one...
Hans Mayr
|
06-24-2008 06:36 AM
Hans Mayr | 0 | 23 |
| | | Hi,
I am trying to get an answer for 'Is it required to create a temporary
lob before doing an in/out operation on a lob being passed as...
sachin.garge@gmail.com
|
06-24-2008 02:29 AM
Vladimir M. Zakharychev | 4 | 35 |
| | | I am using 10g.
Below is a crude example of what I am trying to do
Procedure
( pi_input as interger
)
is
General Fear
|
06-20-2008 06:54 AM
General Fear | 12 | 39 |
| | | What would cause a trigger to have an invalid state? Do triggers
become invalid if you alter a table (but do not add/drop any columns
that trigger...
rzaleski
|
06-18-2008 09:15 PM
Mark D Powell | 4 | 28 |
| | | Hi,
I'm looking to parse an email. Say I have an email like this:
johnjones (AT) gmail (DOT) abc.def.ghi.com
I basically want johnjones (AT)...
Mtek
|
06-18-2008 07:29 PM
Malcolm Dew-Jones | 20 | 65 |
| | | 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 01:15 AM
sifobo | 0 | 22 |
| | | Home Remodeling Improvement Locksmith Smart Home Moving & relocation
Related Links:
Moving Companies...
World Marketing
|
06-17-2008 07:20 PM
World Marketing | 0 | 20 |
| | | Hello,
Recently we installed Oracle Enterprise Manager. We keep the processes
of this tool running (so we didn't stop them with emctl), but...
VDK
|
06-17-2008 04:57 PM
wodenic | 8 | 22 |
| | | Hi,
I may be answering my own question, but I want to make sure.
Say I have a ref cursor that has a dynamic where clase, and in
addition a bind...
Mtek
|
06-17-2008 12:36 PM
Dan Blum | 24 | 60 |
| | | Hi,
I'm been playing with using Filemaker Pro to generate and send sql to an
Oracle 10g database. The following works fine:
UPDATE...
William Maslin
|
06-17-2008 12:08 PM
William Maslin | 32 | 83 |
| | | I am trying to bind a parameter as the parameter to the existsnode()
function.
select...
ajmastrean
|
06-17-2008 11:35 AM
ajmastrean | 12 | 77 |
| | | Hi,
We use TOAD as our GUI to see the database. I put in a query that
selects from V$SQL, but I get a missing expression. The same query
works...
Mtek
|
06-17-2008 08:40 AM
Mtek | 24 | 150 |
