insert/read Blob from a table

Hi , Does anyone have a sample code to insert/update/delete a BLOB into a table from a stored procedure. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

output parameter/pl-sql table type

HOW DO I GET THIS WORKING.I TRIED DECLARING VARIABLE OF TABLETYPE AND TO PRINT IN SQLPLUS BUT I STILL THE SAME ERROR PLS-00306. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://w

UNSUNSCRIBE ME

Title: RE: DBA needed in Austin, TX HELP

RE: logging oracle error code and message into a table within pro

All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 31, 2003 3:35 PM To: Multiple recipients of list

AQ-JMS- SYS.AQ$_JMS_TEXT_MESSAGE

se see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

logging oracle error code and message into a table within procedu

Hi All, I want to log the oracle error code and messages that will be generated within a procedure/trigger into a table. I know i can write this in the exception block.Does anyone has any sample code to help me out. thanks ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Oracle AQ monitoring questions

than other oracle tables?How can we find out if AQ is getting corrupted.This question may be related to the previous one . Pls advice. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network

WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=12

problem?any thoughts? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Oracle JMS--Lost all my Emaisl...Pls resend if any reply was post

JMS. Appreciate any help. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Oracle JMS

JMS. Appreciate any help. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Passing array as input to procedure from sqlplus-HELP

roc(33); ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'testproc' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Pls help Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja,

Passing array as input to procedure from sqlplus-HELP

roc(33); ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'testproc' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Pls help Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja,

SQL Query Help

help in getting the query that can get the results like that. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Oracle JMS

didn't find anything good. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting ser

Database Auditing

Hi All, How do we turn on statement level auditing (DB and OS Level) to audit the DML/DDL's on the database.Is this possible with out triggers? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Ne

RE: SQL Query Help

-group group function how do i get this work. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

RE: SQL Query Help

- Sent: Wednesday, May 28, 2003 6:25 PM To: Multiple recipients of list ORACLE-L Add "group by ID;" as in: SELECT ID,MAX(LastModDate) FROM Tab group by ID; > -Original Message- > From: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 28, 2003 8:1

SQL Query Help

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

how to calculate table size

Hi, Anyone having any formula to calculate table size?Basically to estimate the growth of table over a peroid of time. I have the row_size,db_block_size.How do i get the table size. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET

Database sizing and capacity analysis

: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

recovery

storing till 23-MAR-03. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web h

RE: partitioning

t for each row begin    select mod (sequence.nextval, 8) into :new.partition_column     from dual ; end ; / Something similar would be achieve by hash partitioning, which is easier to implement. > -Original Message- > From: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]] &

Demo of PL/SQL returning a REF Cursor to an OCI program

Hi, Anyone with examples of using OCI and ref cursors.Can I get some examples for Demo's of Pl/SQl returning a REf cursor to an OCI program. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Ne

RE: partitioning

easier to implement. > -Original Message- > From: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]] > > I am wondering if there is any way to achieve horizontal > partitioning in Oracle. > > Assuming that I have about 8 partitions for a table.When >

partitioning

,but what would be the performance effect? Any thoughts or similiar ideas Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

ref cursor

Hi, I have a procedure that has an ref cursor as an OUT parameter.If for some reason If I have to return NULL values in the ref cursor how do i do that. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City

sql query: to_date() :ORA-01830: date format picture ends before

What is the problem? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: sql query: to_date() :ORA-01830: date format picture ends bef

e- > From: Basavaraja, Ravindra > Sent: Tuesday, March 11, 2003 12:19 PM > To: 'Multiple recipients of list ORACLE-L' > Subject: sql query: to_date() :ORA-01830: date format picture ends before > converting entire input string > > Hi... > &g

dbms_job

dbms_job and continue executing the next line of code in the procedure. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: slow insert

pending on your physical configuration. Regards, Mark. "Basavaraja, Ravindra" &

Update and Trigger

and without the trigger the update takes about 1 second. When the updates are operating on different tables(locking not a issue) why do i see this delay in execution of the update statement. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra

RE: slow insert

o emp_copy(empno, ename, hiredate) values(v_empno_arr(v_arr_idx),v_ename_arr(v_arr_idx),v_hiredate_arr(v_arr_id x)); commit; -- note : the condition has to be checked here ONLY exit when c_emp%notfound; end loop; close c_emp; end; / -Original Message- Ravindra Sent: Frid

RE: slow insert

arr_id x)); commit; -- note : the condition has to be checked here ONLY exit when c_emp%notfound; end loop; close c_emp; end; / -Original Message- Ravindra Sent: Friday, February 21, 2003 7:09 PM To: Multiple recipients of list ORACLE-L Yes I am usng 8.1.7 EE.How do I use bu

RE: slow insert

of course, u surely might have thought of APPEND hint & dropping/disabling indexes etc. -Original Message----- Ravindra Sent: Friday, February 21, 2003 3:08 PM To: Multiple recipients of list ORACLE-L hi, I have an insert statement that will insert about 40 records into a table ha

slow insert

looks like insert into ... select ... from a,b where a.col1=b.col1 --->index columns and a.col2=x -->non index and b.col2=x -->non index Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network

slow update and db trigger

statement sometimes is executed very fast and sometimes it takes upto 50 seconds.Does this slowness got to do anything with the triggers that get fired automatically .For me this update is a single piece of transaction.Why do i see the delay in this update statements. Thanks Ravindra -- Please see

update slow and EJB timesout

could be the problem with EJB timing out and the duration the procedure is taking to be executed. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

test - pls Ignore

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Database Desgin book/migration from informix to oracle

anything.pls let me know thanx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

test-pls ignore

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Standby DB with Oracle Standard Edition

link/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=160475.1   Ravindra

sqlldr

We have a process that generates log file continously with dateandtime stamp on the filename like log_041502_113545.log   These log files should be loade to the table using sql loader.I have the sqlldr script to load to the table.But this sqlldr will be part of the shell script that is will

Cannot import--URGENT

nings.    Ravindra

Alter table failes with ORA-00054:resource busy

I want to alter a table and add a new column on our production database.   I am getting the following error ERROR at line 1:ORA-00054: resource busy and acquire with NOWAIT specified   Some user/process is holding the lock on this table.I have tried at different times and still cannot get it

cannot dsiplay bfile data-URGENT

  I am not able to display the bmp stored in the BFILE.I followed the following steps.I have been following the NOTE from metalink and the oracle app dev guide.   CREATE TABLE empbfiles (id NUMBER PRIMARY KEY, empname VARCHAR2(20),   photo BFILE);   /   CREATE OR R

BFILE

Hi ,   i have a procedure to open the BFILE data.   CREATE OR REPLACE procedure openmyfile as lob_loc bfile; filesize number;  lob_loc bfile:=bfilename('IMG','a.jpg'); begin --select f_lob into lob_loc from lob_table where key_value=21; dbms_lob.fileopen(lob_loc,dbms_lob.file_readonly); dbms_l

database trigger

I want to write a database trigger that will insert a new record into a log table whenever there is an update action on a particular table.Is there a way of storing into the log table the actual update command that was issued againt the table.   Ex: I have a database trigger that fires when

[no subject]

HELP

sqlldr

o set for the "rows" and/or "bind array" for me to load the records to the table at one attempt. thanks ravi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: Archiving data

on oracle 8.0 or above, I imagine? > -Original Message- > From: Ravindra Basavaraja [mailto:[EMAIL PROTECTED]] > > I have few tables that will be getting populated with transaction data > continuously.This table > grows to large size.For us once

Archiving data

d and after this those records can be deleted.Ex create table T1 as select * from where id < ; What is the best way of doing this. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network

RE: Standby Database Error

imary database. Thanks Ravindra -Original Message- Basavaraja Sent: Friday, August 10, 2001 6:05 PM To: Multiple recipients of list ORACLE-L I am getting the following error when applying the archive files from the production database to the standby database.I just configured the st

RE: rman/standby

manual mode.. thanks ravindra -Original Message- Sent: Wednesday, August 15, 2001 4:36 AM To: [EMAIL PROTECTED] Assuming your standby database exists and is on-line (i.e. mounted but not open), you should be able to set up archive_log_dest2="service=your_SID_for_standby mandatory reop

rman/standby

l delete input); (archivelog all); } How do I do it.? Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cali

RMAN

right command to get that done. What change should I do in the script so that the archive log file are not deleted. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-50

RAID 5/Oracle

each disk of A1000 as different mount point. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Int

off topic--oracle Vs ms sql

Does anyone have any doc or links that compares oracle and ms sql. Also what are the equivalent data types in ms sql for oracle's lobs. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Ne

sql help --urgent

this Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

MINUS--Sql help

not the subtracted value.Both select statements give different number o/p when run individually.What could be wrong. Is there anything that i am missing to consider when using the MINUS operator. Pls help Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

RE: Email/Paging/Mobile Phone alerts

Does anyone have a similiar script for doing the same on Windows NT.   Thanks Ravindra -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of John CarlsonSent: Thursday, February 22, 2001 5:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re

sql o/p to Excel

appear in different columns in excel.How can I do that. Is that possible? Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Locks

timeout parameter that can be set on the database. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: * I'm Looking for an Oracle Financials DBA for Miami,

>> money isnt everything :) Right... Like itz not SUFFICIENT.. :) Ravi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra P Channe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cali

RE: Calling Stored Proc in SQL Server from Stored Proc in Oracle

Hello everybody, Sorry for the previous post. I think I need to RTFM. It can be done through Oracle Open Gateway. I haven't tried it till now. If there are any suggestions then it would be appreciated. Regards Ravindra C

Calling Stored Proc in SQL Server from Stored Proc in Oracle

ous values. Can somebody suggest me an efficient way of accomplishing the same. Thanx in advance. Ravindra Channe - - Any opinion expressed here is personal and doesn't reflect that

rman

ecution of the above script. There were about more than 300 archive files and only 15 were deleted.I am attaching a snopshot from the output of the above RMAN command.Can anyone tell me why this is happeneing.What RMAN log files should I check? Thanks Ravindra RMAN-08014: channel c1: specifying arc

size of Clob

I have a column of Clob datatype in one table.How Can I find the size of the data in a row for that Clob column alone. Is this possible? Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network

sql query

02-03 like wise for every hour. Can i do this by using the GROUP BY clause.If so pls help me. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Book

Can anyone suggest me a good book on database design and sizing and also on performance tuning,backup recovery. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

OCI drivers

this topic. thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RMAN

anyone tell me how to complete the set up successfully.Why am i getting RMAN-06193: connected to target database (not started) error. Pls advice Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network

sql queries issued to the database

How do we find all the queries that are issused against the database.Can we enable any log that will capture this information along with the user information who issued the query. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja

RE: sql query

Though I had some fair idea of what it was, but now things are very clear after all the replies. Thanks for all the reply. Ravindra -Original Message- [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 3:21 AM To: Multiple recipients of list ORACLE-L sysdate - 1 is sysdate minus one

sql query

I found a query to get the time 5 seconds less than the current time as select to_char(sysdate-5/(24*3600),'dd-mon- hh24:mi:ss') from dual; I am really not sure as to why 24*3600 is used for. Can anyone tell me why it is used. Thanks Ravindra -- Please see the official ORACLE-L

RevealNet

Gurus, I wanted some inputs on Revealnet knowledge base.If anyone is using this,i want to how useful has it been. Are there any other tools that I can look in. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL

RE: Excel to oracle

ouble quote and comma.How do avoid these from going into the table. Thanks Ravindra -Original Message- Beilstein Sent: Thursday, March 29, 2001 11:22 AM To: Multiple recipients of list ORACLE-L Use the save as option in Excel and save as a comma or tab delimited text file. In other wo

Excel to oracle

I have a Excel file.How to port the data to Oracle table. I read some artical about using ODBC and things like that.But I am not clear. How can we generate a dat file delimited with comas so that I can use SQlLOADer to port the data. Thanks Ravindra -- Please see the official ORACLE-L FAQ

sqlplus

be a problem. I also tried with using the to_char but no success. How do i get the o/p. EX:The requirement is like say in a table with phone call info we want to display the count of call made b/w two dates in a month and grouped by date. Thanks Ravindra -- Please see the official ORACLE-L

java pgm from d/b trigger

Can we call java program from a database trigger? Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Netbackup and RMAN

or just Netbackup is sufficient for the Oracle backup and receovery. thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

NUMBER datatype

This is an elementary q. If i have a col of NUMBER data type what is the last number that can be stored in this col. Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

sequence generator

points. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

process parameter

what is the maximum value to which I can set the process parameter in the init.ora file.Does this depend on the servers RAM? How does the relation go about and how do we decide on the number of process to be set. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Email/Paging/Mobile Phone alerts

alert to notify the person who takes care of the database. Thanks -Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

to insert into blob

I have a wav file and I have to insert it into a table with column blob type. How do I do this. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

OCI

on is a java application and makes JDBC connection to the database. Pls comment Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

OPS/sun cluster

documentation published by Sun or Oracle to guide us how to setup OPS on Sun Cluster ? thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

sql query

-- a 3 b 3 c 3 How do i write the query Thanks ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California