| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Juan Guillermo Fernández V. wrote:
Read about DBMS_JOB
Anna C. Dent
|
07-14-2003 04:59 AM
Michael Willer  | 2 | 80 |
| | | Hi - we are upgrading our old Oracle7.3.4 environment to Oracle9. Our
current HACMP environment consists of two AIX4.3.3 servers (64-bit)
configured...
Bruce
|
07-13-2003 07:29 PM
Nuno Souto | 5 | 71 |
| | | Praveen wrote:
The oracle clients don't care what charset the database server has
as long as the client charset is a full subset of the...
Svend Jensen
|
07-12-2003 11:26 AM
Svend Jensen | 0 | 87 |
| | | Hemant Desai wrote:
HUH?
what is "ms"?
what is "s"?
NO!
Anna C. Dent
|
07-12-2003 08:39 AM
Anna C. Dent | 0 | 79 |
| | | I want to search for a string in the values of all the columns of all
the accessible Tables. How do you do that in SQL(sqlplus)?
qazmlp
|
07-11-2003 11:48 AM
Daniel Roy | 1 | 80 |
| | | Hello all,
I have made a procedure which is running a very, very long time (about
20 hours)
Within the procedure I put some output-lines, to show...
Andre
|
07-11-2003 11:42 AM
Daniel Roy | 1 | 81 |
| | | Hello all,
How can I check (within a pl/sql-procedure) if a database link is active or not??
I am using oracle 8.1.7
Thanks and regards,
Andre van...
Andre
|
07-11-2003 11:26 AM
Jusung Yang | 1 | 104 |
| | | rounding question....
I have this:
1 select cltv
2 from empower.mtgterms
3* where lnkey = '304076'
kboudreau
|
07-11-2003 09:40 AM
Ivica Dimjasevic | 2 | 94 |
| | | TEXT_IO for client, DBMS_OUTPUT for server.
When I create store procedure, package, how I know where it would be run ?
Julia Sats
|
07-11-2003 05:46 AM
andrewst | 1 | 84 |
| | | ambalikavikash (AT) yahoo (DOT) co.in (Ambalika) wrote in message news:<247bcd5.0307102257.4155a7a9 (AT) posting (DOT) google.com>...
hi again!
I...
Ambalika
|
07-11-2003 04:10 AM
Ambalika | 0 | 71 |
 | | Hi all,
I have a 9i client that has been happily connecting to an 8i database on a
remote server. The server now has 8i AND 9i installed, and the 9i...
Nick Williamson
|
07-10-2003 11:00 PM
Rauf Sarwar | 1 | 158 |
| | | "J. W." <someone (AT) comcast (DOT) com> wrote
Thanks for the clear answer.
Ford...
Pord Frefect
|
07-10-2003 07:13 PM
J. W. | 4 | 68 |
| | | I have a trigger. Each time the triggering event fires, I want to
insert some information into another 'audit-like' table (not at all
related to the...
Tom Urbanowicz
|
07-10-2003 11:48 AM
Tom Urbanowicz | 3 | 97 |
| | | Hi John,
Thanks for the reply. I know this way of geting the list. But to get the
list from dba_source table, I have to do the string manipulation...
vgadge
|
07-10-2003 11:20 AM
Tom | 4 | 78 |
| | | Hi,
I am a complete beginner with Oracle 9i and XML within it, not XML
alone though.
I am trying to do a regular SELECT statement using the SQL...
Alex
|
07-10-2003 10:30 AM
Alex | 0 | 111 |
| | | I'm from a Sybase and Ms SQL server background and a bit new to
Oracle.
Does Oracle have a databse error log where all database errors are
logged...
Allen
|
07-10-2003 08:05 AM
michael ngong | 3 | 97 |
| | | How would you setup a sample Create Table statement with having to
specify a constraint name for a Primary Key in the table.
Would it go something...
Victor M.
|
07-10-2003 07:49 AM
michael ngong | 2 | 68 |
| | | andrewst <member14183 (AT) dbforums (DOT) com> wrote
Hi Andrew!
Yes, the PRAGMA AUTONOMOUS_TRANSACTION did it!! Thanks a lot for
helping out so...
RobertGl
|
07-10-2003 07:43 AM
RobertGl | 1 | 96 |
| | | Originally posted by Marcband
properly define your requirements before you can code them.
--
Posted via http://dbforums.com
andrewst
|
07-10-2003 06:06 AM
andrewst | 0 | 86 |
| | | "JN" <jirinej (AT) volny (DOT) cz> schrieb im Newsbeitrag
news:7e29a94a.0307090205.179bca49 (AT) posting (DOT) google.com...
Firstl of all: it's not...
Guido Konsolke
|
07-10-2003 03:52 AM
Yasin | 3 | 109 |
| | | I have developed a VB application that uses Oracle 8i database for backend.
The database server is on the local network. From my development...
Alex
|
07-10-2003 03:49 AM
Billy Verreynne | 3 | 86 |
| | | Hi,
I have a working application inserting rows to a table using the array
interface. Now I want to insert BLOBs as well but OCIStmtExecute...
Ole Hansen
|
07-10-2003 03:47 AM
Ole Hansen | 0 | 86 |
| | | Rauf Sarwar <rs_arwar (AT) hotmail (DOT) com> wrote
I did just as suggested, and it seems to be working OK. I have 2
separate Oracle homes, and...
Bill
|
07-09-2003 03:08 PM
Bill | 1 | 98 |
| | | Does anyone know how to keep text items that are selected, mouse
clicked from turning blue(highlighted)?
I have query only blocks that are simply...
steve deno
|
07-09-2003 01:45 PM
steve deno | 0 | 86 |
| | | Simply use the database sys.xml_gen function to get info on this read
chapter 10 of Oracle9i XML Database Developer's Guide - Oracle XML DB
Link is...
shay
|
07-09-2003 01:26 PM
shay | 0 | 123 |
| | | getamit23 (AT) rediffmail (DOT) com (Amit Kapoor) wrote in message news:<c33bca54.0307090046.7698321f (AT) posting (DOT) google.com>...
The Windows...
Mark D Powell
|
07-09-2003 08:46 AM
Mark D Powell | 0 | 124 |
| | | I have a problem while connecting to a database (node) on my pc through
the Oracle Management Server.
The Oracle Management Server is on my system....
dominant
|
07-09-2003 08:17 AM
dominant | 0 | 94 |
| | | Either:
select *
from myTable
where rownum <= 100
or
rtfm
Ethel Aardvark
|
07-09-2003 03:49 AM
Ethel Aardvark | 0 | 93 |
| | | I used ftp and set binary transfer type (bi) to transfer the image
file between the 2 servers. I also tried to display the image in 8i
and 9i on the...
Meng
|
07-08-2003 11:31 PM
Meng | 0 | 92 |
| | | How can I get database SID in stored procedure in Oracle?
Orlando Jin
|
07-08-2003 10:56 PM
Orlando Jin | 0 | 90 |
| | | Hi folks,
I'm having a problem with initjvm.sql. I created a procedure to send a
message using utl_smtp and when I run it, I got an error ORA-29540....
Jorge Pinto
|
07-08-2003 07:37 PM
Anna C. Dent | 1 | 86 |
| | | I don't know. This redo log corruption occurred on three machines with
Personal 8.0.4., in period of two days, and on every system Bugbear...
Ivica Dimjasevic
|
07-08-2003 04:53 PM
Ivica Dimjasevic | 0 | 97 |
| | | Originally posted by Victor M .
No, Ana must have misread your insert! The SSN value '123456789' is
fine.
Originally posted by Victor M .
......
andrewst
|
07-08-2003 04:20 PM
Victor M. | 1 | 129 |
| | | Please I've captured an sql-statement form my db oracle
........FROM TN_PROJECT S ,TDM_LINKS L
WHERE ((L.OBJECT_ID2 = :1)
and (L.CLASS_ID2 =...
Bela
|
07-08-2003 12:03 PM
andrewst | 1 | 78 |
| | | Hello everyone.
I am a newbie to Oracle 8 so please be patient and thanks for your time.
The problem is the above mentioned error. I have two...
Victor M.
|
07-08-2003 11:09 AM
Victor M. | 2 | 93 |
| | | I'm writing a unique PL/SQL program to produce Oracle's AR's Invoices
I'm not sure if TEXT_IO is a part of FORMS or PL/SQL ?
It looks like PL/SQL...
george lewycky
|
07-08-2003 09:47 AM
george lewycky | 0 | 115 |
| | | Hi
Greetings to all
I am new to ProC. I am compiling a very simple program written in
ProC. I can compile the program using proc filename.pc and...
ferdous
|
07-08-2003 02:48 AM
Lothar | 1 | 276 |
| | | I want to know the column names that exists in more than one table;
also, I want to know the table names where it exists. I tried this
query and it...
Geetha
|
07-08-2003 01:58 AM
varol cavdar | 1 | 185 |
| | | VTK-1000 : it's the code of the error that i receive. It cannot
resolve the host
--
Posted via http://dbforums.com
dominant
|
07-08-2003 12:21 AM
dominant | 0 | 75 |
| | | has anyone ever created a query that you have a table which links into
a one to many that has a one to many relationship with a lookup table
and you...
LukeH
|
07-07-2003 07:52 PM
LukeH | 0 | 65 |
| | | I think it's Oracle 8i (8.1)
"s.kapitza" <skapitza (AT) volcanomail (DOT) com> wrote
Jorge Pinto
|
07-07-2003 02:51 PM
Charles | 3 | 106 |
| | | I am trying to use RDB stored procedures to return result sets.
How do I implement this in RDB? For example to select all
employees in a...
shamansc
|
07-07-2003 09:27 AM
shamansc | 0 | 70 |
| | | Hi
I have one reports which shows the Account wise daily
transaction during the day.(pl's find below report
layout format with column...
Yasin
|
07-07-2003 06:16 AM
Yasin | 0 | 81 |
| | | Hello everyone.
I'm running Oracle 8.0 on NT4 (yep thats right) and running SQL*Plus
8.03.
I'm typing the following at the SQL*Plus prompt:
1....
Victor M
|
07-07-2003 04:08 AM
varol cavdar | 1 | 88 |
| | | oracle 9i is not supported with windows me as is 8i ; you'd better
switch to linux
--
Posted via http://dbforums.com
osy45
|
07-07-2003 12:20 AM
osy45 | 0 | 115 |
| | | Ik have created an index on a date field.
99% of all data in the table has a filled in date. 1 % is NULL
When I do a select with clause ... WHERE...
Aad Aldus
|
07-06-2003 10:53 AM
Michael Willer | 2 | 101 |
| | | Dear all,
I need some help. How do I full join two tables (with two columns each)
together using the standard sql way on oracle 8?
David
--
Posted...
DMOK
|
07-06-2003 12:58 AM
DMOK | 3 | 101 |
| | | How does one track a user logon and the SQL that
they execute?
netnews.comcast.net
|
07-05-2003 07:40 PM
netnews.comcast.net | 0 | 108 |
| | | Hi All,
I have a table Truck_Journey with the following structure
Tj_Date Date
Tj_Truck_Id Number(5)
Tj_Truck_No Varchar2(10)
Tj_Km ...
Bliss
|
07-05-2003 10:31 AM
Bliss | 0 | 68 |
| | | Hello,
We have an apllication made with Designer 6 and everything works just fine.
Using headstart too. Now a user has installed 6i and one form is...
mish
|
07-04-2003 10:07 AM
Hilary Band | 3 | 78 |
