dbTalk Databases Forums  

Sponsored Links

comp.databases.oracle.misc comp.databases.oracle.misc

Discuss in the comp.databases.oracle.misc forum.

Post New Thread
Threads in Forum : comp.databases.oracle.misc Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hi Gods of Oracle, I'm in need of something like: select * from colourtable where colour in :somecolours Obviously :somecolours would be...
06-27-2003 09:25 AM
Niall Litchfield Go to last post
3 158
Ok, folks. Here's the deal. Basically, I have a Stored Procedure in Oracle that inserts data into a table. Simple enough. I want to call this sp...
06-27-2003 08:54 AM
Billy Verreynne Go to last post
1 311
"koert54" <nospam (AT) nospam (DOT) com> wrote More opinions/reviews about "Art and Science of Oracle performance Performance tuning " will be...
06-27-2003 08:10 AM
michael ngong Go to last post
7 143
Apparently, your problem is the results of the PL/SQL procedure is not displayed. Don't forget to use SET SERVEROUTPUT ON before the PL/SQL block (it...
06-27-2003 12:28 AM
Stéphane LEJAY Go to last post
6 159
Andy Hassall <andy (AT) andyh (DOT) co.uk> wrote You are right...I am running within a SQLPLUS session Yep From TOAD I copied the following...
Ecce Nihil
06-26-2003 06:22 PM
Andy Hassall Go to last post
1 210
Andy, I changed the column to long varchar and everything worked fine. The Unix guys did the build I will check with them about the Oracle...
Ken Chesak
06-26-2003 01:14 PM
Andy Hassall Go to last post
3 208
Has any experienced the following error when upgrading from Oracle8i to Oracle9i and running a 'batch' SQL Loader...
R. Hutchinson
06-26-2003 10:26 AM
Hans Forbrich Go to last post
1 148
"Jérôme VUIBERT" <jerome.vuibert (AT) fleximage (DOT) fr> wrote Brian's suggestion wasn't in fact to use the compress option (which rejigs storage...
Sybrand Bakker
06-26-2003 10:03 AM
Niall Litchfield Go to last post
4 160
Thanks Daniel, I've worked at companies and done the bend over bit. It hurts. Worked at one company where they would not hire support people....
Jim Kennedy
06-26-2003 09:50 AM
programmer Go to last post
2 155
Hi, Is it possible to concatenate multiple rows of data in a single select statement. For example, if my table was FIELD1 ------ aaa bbb ccc
D. Alvarado
06-26-2003 09:28 AM
programmer Go to last post
2 161
hello first off I am taking a course on Database Modelling with little emphasis on triggers and/or stored procedures so dont percieve that this is...
dave m
06-26-2003 09:10 AM
Rauf Sarwar Go to last post
2 139
"Jaret Lafoudravecmonhnez" <toto (AT) toto (DOT) com> wrote Prepare a drop script for the procedures; run the export; perform the import; and then...
Mark D Powell
06-26-2003 03:56 AM
Jaret Lafoudravecmonhnez Go to last post
4 178
Ryan Gaffuri wrote: If it has value ... yes. To be a physician requires a college degree, an internship and a certificate. To be an attorney...
Daniel Morgan
06-25-2003 06:18 PM
Daniel Morgan Go to last post
2 144
DBA FIGHT (Multi-page thread 1 2 )
Anurag Varma wrote: The point of my demo ... and the point of my comments here ... is not to influence people to write code one particular way or...
06-25-2003 04:53 PM
Anurag Varma Go to last post
13 242
Hey, I'm last year student Informatics at an university. My project for my graduation consist of building an Oracle database and making a Java...
06-25-2003 02:41 PM
Rauf Sarwar Go to last post
2 162
I am trying to upgrade my OCP 6/6i application developer certification to 9i. I want to find any books or training materials. Any information will...
06-25-2003 02:16 PM
Ryan Gaffuri Go to last post
1 184
Hi All {Platform Win2kPro and Oracle8i), I am having some problems with executing dynamic sql from within a function. If i copy the code into...
Adam C
06-25-2003 09:51 AM
Greg Forestieri Go to last post
2 190
On Tue, 24 Jun 2003 08:20:46 -0700, Daniel Morgan <damorgan (AT) exxesolutions (DOT) com> wrote: Its is not Homework. I need it really. Oracle...
06-24-2003 01:20 PM
Daniel Morgan Go to last post
8 193
TM wrote: Put in other terms ... DB2 has no security unless one purhases Tivoli or other products in addition to the database. Every product has...
Daniel Morgan
06-24-2003 01:13 PM
Xpressy Go to last post
5 249
Mark, Don't rely on the implicit string to date conversion. Explicitly convert it. eg AND reportdatentime >= '25-Mar-2003' AND reportdatentime <...
Jim Kennedy
06-24-2003 09:52 AM
MThomas Go to last post
1 216
Using Oracle 8i We have a report server which runs a bunch of reports for a bunch of clients. The reports and various info about each report are...
01-13-2003 05:05 PM
Tony Go to last post
1 224
"Frank" <fbortel (AT) home (DOT) nl> wrote I put it into .profile but nothing change, always the same error.
01-13-2003 04:13 PM
Seb Go to last post
1 265
There are implementations of SAP system on IBM's DB2, too. Best regards, Ognjen Antonic - Ogo
Ognjen Antonic
01-12-2003 04:41 PM
DA Morgan Go to last post
1 226
HI, I want to know how to return a resultset in a proc which must be received in a Java servlet Thx for responses
s Lehaire
01-10-2003 11:17 AM
DA Morgan Go to last post
1 209
"aurum" <alz72 (AT) rambler (DOT) ru> wrote external procedures run from the server *ONLY* sorry Sybrand Bakker Senior Oracle DBA
Sybrand Bakker
01-10-2003 01:07 AM
aurum Go to last post
3 249
We currently running patch 8 on Win2K Adv. Srv. SP2. Hardware is compaq quad 900 MHz and 8GB RAM We are able to use more than 4 GB RAM with...
01-09-2003 09:45 PM
Dan Yusuph Go to last post
4 736
Do you have permissions to modify omsconfig.properties - which is where the encrypted credentials are stored. Also check the Enterprise Manager logs...
01-09-2003 09:48 AM
James Go to last post
3 199
Is this any help? http://otn.oracle.com/products/bi/pdf/o9ir2_compression_twp.pdf -- Niall Litchfield Oracle DBA Audit Commission...
Niall Litchfield
01-09-2003 04:36 AM
Cesar Otero Souto Go to last post
1 229
Hi. In the project I'm working on now each developer have its own user account towards the database. The application we are doing generates logging...
Helge Hauan
01-08-2003 05:19 AM
Jim Kennedy Go to last post
1 251
There are several FAQs about the Oracle database scattered around the Internet, and many ways of finding answers to the simpler questions about...
Jonathan Lewis
01-06-2003 01:36 AM
Jonathan Lewis Go to last post
1 177
Hi there, Has anybody here successfully installed Oracle 8i ( release 3 ( 8.1.7 ) ) on Solaris x86 version 8 ? I am confused ( among other things )...
frederick smith
12-22-2002 01:51 PM
pheonix1t Go to last post
1 194
Thanks for the reply. My primary objective is to query SQL Server on demand. I agree it would be infinitely easier to send the data from SQL to...
12-20-2002 09:49 AM
Timbo Go to last post
1 183
Hi all, has anybody ever simulated a distributed transaction failure? I would like to make some test, and in order to have the...
Brit Pop
12-18-2002 10:15 AM
Jonathan Lewis Go to last post
1 291
Fri, 13 Dec 2002 15:30:28 -0500, pmatt69 said (and I quote): It's just getting truncated. Check the length of varchar or long output setting in...
Nuno Souto
12-14-2002 07:03 PM
Tim X Go to last post
2 198
hi all, i am using oracle 9.2.0 and i need to create a very large database to accomodate a large influx of data. i have the following two partitions...
B. Kloppt
12-14-2002 05:13 PM
Bert Bear Go to last post
1 255
I am learning dataGuard 9i, but I can not afford two machines. Has anybody tried to put both instance on the same machine? Will that work? Thanks...
Joe Sath
12-11-2002 02:15 AM
Howard J. Rogers Go to last post
5 285
If I install an oracle database 8i, and created a database with name abc, the system's password is manager. Why I can't use sqlplus as this and log...
Song Zhang
12-10-2002 05:25 AM
Howard J. Rogers Go to last post
2 194
Hi, I have problem performing full backup of Oracle9i under redhat Linux 8.0 kernel 2.4.18-14 on Pentium 4 with 1280 MB RAM. Symptom: 1....
12-06-2002 08:05 AM
Yuri Zelenski Go to last post
1 195
Posting the error messages (if any) might help. And posting the output from the archive log list would too. Also, I'd like to see the exact...
Howard J. Rogers
12-05-2002 08:54 AM
michael ngong Go to last post
1 205
Post New Thread

Display Options
Showing threads 7301 to 7339 of 7339
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.