| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | We are a software development company based in the Netherlands. For
projects in Belgium we are looking for a Oracla Database Developer
(knowledge of...
Jobs @ Redline-systems.com
|
07-05-2004 06:11 AM
Jobs @ Redline-systems.com | 0 | 79 |
|  | WHERE d1 >= trunc(add_months(sysdate,-1),'month')
Joe Powell
|
07-02-2004 10:13 AM
Wit Serdakovskij | 10 | 126 |
|  | I'm working on an application where the user would like the capability
of creating new data elements, enter a value, and store the
information on a...
Joe C
|
07-02-2004 09:56 AM
Mark D Powell | 1 | 84 |
|  | a new user of oracle 10g.
tried the following statements on scott/tiger with tablespace x
create table mytest (
a varchar2(30)
);
alter table...
Andy
|
07-02-2004 04:49 AM
zhu chao | 1 | 82 |
|  | I have a problem with the regexp_like method.
How do i use it when i want to know if a text contains a word?
Example:
The text 'hi, how are you?'
If...
winnant
|
07-02-2004 02:11 AM
winnant | 0 | 145 |
|  | I plan to change the datatype from long raw to blob as from tables
stud_photo and cimpant _image below. But i am not sure if it is a good
idea. pls...
tracy
|
07-01-2004 03:22 PM
cs | 2 | 98 |
|  | Hallo
i am a beginner into Oracle Technologies.I would like to make backup
of my database,but i dont know how.Is there tools?Can i schedule...
Cristina
|
07-01-2004 03:10 PM
cs | 3 | 103 |
|  | Hi all
We're in the process of porting a system written for MySql to Oracle.
I would like to find out what the Oracle licensing issues are....
Sporge
|
07-01-2004 12:13 PM
Hans Forbrich | 7 | 85 |
|  | Hi,
I'm having a nightmare when trying to insert records into an Oracle
database that contain dates. I've believe I should be using the
to_date()...
Paul Long
|
07-01-2004 09:55 AM
Mark D Powell | 1 | 135 |
|  | Daniel Morgan <damorgan@x.washington.edu> wrote in message
Daniel is currently consulting for a bitch and/or converting to a bitch and
looking to...
omlet@omlet.org
|
07-01-2004 08:50 AM
Pete's | 1 | 58 |
|  | I currently have some trouble because of a misconfigured storage. The
technicans are involved, but the reconfiguration will requires several...
Markus Breuer
|
06-30-2004 08:34 AM
Markus Breuer | 0 | 65 |
|  | Hello,
I'm using Oracle 9.2 and would like to automatically save a copy of
each deleted record in XML format to another database table. There
would...
DaveS
|
06-29-2004 04:14 PM
DaveS | 0 | 83 |
|  | Connect /as sysdba;
@?/rdbms/admin/prvtxdb.plb
exit.
Rajeev
|
06-29-2004 09:42 AM
Mark D Powell | 1 | 95 |
|  | omlet (AT) omlet (DOT) org wrote:
Just curious - in your words, what is in this 'complete monitoring package'
that is not in Oracle Enterprise...
Hans Forbrich
|
06-28-2004 03:21 PM
omlet@omlet.org | 2 | 75 |
|  | please give me a mail.3q
phpbird
|
06-28-2004 02:02 PM
Ed prochak | 1 | 74 |
|  | Hi,
I was wondering if anyone could answer the following questions:
I'm using Oracle 8i and MS SQL Server 2000 by the way.
In oracle you can...
Dav
|
06-28-2004 01:39 PM
Dav | 0 | 73 |
|  | Hi
Please Help me that I faced this Question in an interview but I cant
Get The Proper Answer from Any Where..
SQl> Select * from emp where rownum <...
Prabu Krishnan
|
06-28-2004 11:09 AM
Bent Stigsen | 2 | 83 |
|  | Dear All,
I am faceing a problem in sql output in SQLPLUS screen.I am explaining
the...
Arijit Chatterjee
|
06-28-2004 07:52 AM
Arijit Chatterjee | 2 | 123 |
|  | Hello,
I have an Oracle Forms/Reports application made up of 44 forms, 7
reports and 4 stand alone forms that can be called independently or
from...
ptreves
|
06-28-2004 12:06 AM
ptreves | 0 | 119 |
|  | got a nice security set up in my test schema. updated the
text to reference the next level up in the schema hierarchy.
installed through SQL*Plus as...
robert
|
06-26-2004 10:37 AM
robert | 1 | 102 |
|  | Hi
i would like to have suggestions for optimizing select query so that
it runs faster.Besides using indexes on key columns what are...
hariom sharma
|
06-26-2004 01:23 AM
hariom sharma | 0 | 79 |
|  | cross posted to comp.database.oracle by mistake.
I'm getting the infamous ora 12154 - TNS could not resolve connect
identifier error.
My computer is...
George
|
06-25-2004 07:25 PM
George | 0 | 76 |
|  | I would like to EXPORT the DATABASE INSTANCE Named "GATES" and...
HARI OM
|
06-25-2004 06:11 PM
HARI OM | 0 | 93 |
|  | Table Name : Emp
EID ENAME
------ ----------
1001 John
1002 Gokul
1003 Daniel
1004 John
1005 Gokul
1006 Daniel
Prabu Krishnan
|
06-25-2004 12:29 PM
Ed prochak | 2 | 87 |
|  | In 11i Oracle has replaced the Expense distribution report APXEDRBS with a
Payables account analysis report. and the users strongly prefer the...
Gene Maillet
|
06-25-2004 10:23 AM
Greg Forestieri | 1 | 79 |
|  | Tom,
Suggest we try and get there for 1PM - by the time they've shown us how
the boat works and taken us on the 'trial cruise' they mention...
David Rolfe
|
06-25-2004 07:50 AM
David Rolfe | 0 | 85 |
|  | Hi,
I am using jsp page to connect to oracle database. We are using a
Borland Enterprise Server 5.2 application server and a web server
running on...
Vijai Kumar
|
06-25-2004 06:49 AM
sybrandb@yahoo.com | 1 | 123 |
|  | Is there a way to customize the SQLPLUS login banner ? ( e.g in
addition to the regular Copyright messages, is it possible to display
additional...
abhay
|
06-25-2004 05:46 AM
Romeo Olympia | 1 | 72 |
|  | Hello,
When I try to connect to my Oracle instance on the W2K server that it
is installed on, using SQLPLUS (ie, SQLPLUS user/password@instance),...
The CQMMAN
|
06-25-2004 05:33 AM
The CQMMAN | 8 | 142 |
|  | hi,
i worry about people doing something they shouldn't to my db and I
would like to track any structural changes (who and which)to my db. I
am using...
LC
|
06-25-2004 03:48 AM
tracy | 3 | 92 |
|  | Hi!
I followed the installation instructions from the oracle 9i built in
documentation and started the installation with the Result of this
output on...
Tamer
|
06-25-2004 03:39 AM
Frank van Bortel | 3 | 132 |
|  | Hi.
I wrote some stored procedures used by a web application. As I am
fairly new to Oracle, I am missing some concepts when creating...
Robert Scheer
|
06-25-2004 12:43 AM
hrishy | 1 | 77 |
|  | Hey,
how can I get ORA-..... error messages in languages other than
english.
I did a
alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1';
but...
Michael John
|
06-24-2004 02:34 PM
Michael John | 3 | 110 |
|  | I am relatively new to the DBA role. I am 8i OCP, and have a solid technical
background. Where I'm weak is on design. I'm aware that there is more...
Dale DeRemer
|
06-24-2004 09:07 AM
Dale DeRemer | 2 | 98 |
|  | Hi all,
We're looking at a vendor who uses the InterSystems Cache Database
Platform, but our IT department has zero experience with this...
Alex
|
06-23-2004 09:15 AM
Wolf Koelling | 4 | 152 |
|  | Hi,
I need help urgently. Yesterday i move a tables and indexes to
different tablespace using these command:
alter table my_table move tablespace...
tracy
|
06-23-2004 04:06 AM
LC | 2 | 103 |
|  | (Using Oracle 8)
I have 4 tables, which I describe below: CUSTOMERS, BOOKS, ORDERS,
ORDERITEMS. These should be pretty self-explanatory, although in...
Mark
|
06-22-2004 10:59 PM
Romeo Olympia | 1 | 70 |
|  | in my query can I convert a string to int
select convert(int,str_col) from table
I just need the order by, if there's a different way.
select...
Cindy Lee
|
06-22-2004 09:36 PM
Romeo Olympia | 1 | 119 |
|  | Hi All,
Do u know how to make 22nd column a primary key if there is a table of
100 columns and you don't know the names of the columns?
If u do...
Prabodh
|
06-22-2004 04:51 AM
Douglas Hawthorne | 1 | 81 |
|  | Hi.
I have a java stored procedure whose spec is as follows:
CREATE OR REPLACE FUNCTION DECODE_SEQUENCE(SEQUENCE VARCHAR2)...
Min-Koo Seo
|
06-22-2004 12:29 AM
Jim Kennedy | 1 | 85 |
|  | Hello everyone,
We are looking for beta-testers for our new product - Scribe Report
Generator. At this moment, Scribe supports 6 relational...
Alexandr Molochnikov
|
06-22-2004 12:27 AM
Jim Kennedy | 1 | 67 |
|  | I have a question about the design of a database structure.
I have a customer that has a pricegroup:
Customer PriceGroup
1234 2
3245 3
I have a...
Michael
|
06-21-2004 06:04 AM
Douglas Hawthorne | 1 | 77 |
|  | Hi,
We have a problem in our mobile calls billing software. To solve it, I
need an outer join in a complicated query. Following are the
simplified...
jain-neeraj@lycos.com
|
06-21-2004 03:57 AM
jain-neeraj@lycos.com | 3 | 113 |
|  | Has anyone upgraded from 8.0.5 to 10g without using the updated
10g OCI calls?
Page 1-18 of the Programmer's Guide for 10g states that the old...
Bob Campbell
|
06-20-2004 10:11 PM
Bob Campbell | 0 | 69 |
|  | We want to write a small web page that will connect to Oracle and do some
basic admi stuff.
Can anyone recommend a way to do this ?
steve mew
|
06-20-2004 10:48 AM
Jim Kennedy | 2 | 73 |
|  | hi all,
would you please help me to do a bitwise or .
i need to findout the bitwise or of a variable and 1 to 7 numbers.
is there any built in...
Res
|
06-20-2004 03:55 AM
Douglas Hawthorne | 1 | 96 |
|  | I have two databases (8.1.7), one master and one replicated. I'm getting different results in my explain plan from the same query. Both dbs have...
Paul
|
06-19-2004 07:55 PM
Paul | 6 | 68 |
|  | I am new to tuning and I am having some trouble with my Oracle
9.2.0.1. I have a database that I am trying to gain consistent
performance out of but...
Dan
|
06-19-2004 07:19 PM
Justin Cave | 1 | 85 |
|  | How can I fetch a LONG type into a C variable using Pro*C compiler?
What´s wrong with this code?
typedef struct TAGmy_raw
{
long len;
unsigned...
Pedro Oguri
|
06-19-2004 04:06 PM
anacedent | 1 | 87 |
|  | I am a relatively new user on Oracle 9.2.0.1 and I am having trouble
performance tuning this production database.
I am running a large query that...
Dan
|
06-18-2004 01:20 PM
Mark D Powell | 3 | 84 |