| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi all,
Is it possible to concatenate the columns of the results of a query
without having to run it through an external filter?
For examples, if I...
Sashi
|
10-18-2007 09:16 PM
Sashi  | 3 | 53 |
| | | We are currently looking out for a PORTAL DEVELOPER with the following
skills:
Comprehensive knowledge of Oracle Portal Application...
shankar
|
10-18-2007 05:37 PM
shankar | 0 | 49 |
| | | Hallo !
My PL/SQL -Script send me a Error-Message.
I don't know how i find the error.
i want add a new range partition in a existing table...
sansar
|
10-18-2007 10:05 AM
DA Morgan | 8 | 62 |
| | | We have a table, T1, with a range partition on a numeric value. I am
trying to join the dba_tab_partitions table with T1 where high_value...
JonL
|
10-18-2007 08:38 AM
fitzjarrell@cox.net | 2 | 61 |
| | | Hello,
i am working with Oracle 9i on a project where the TABLEs and COLUMNs
conform to some standard, which, IMO, makes the names too tedious...
Brian Tkatch
|
10-17-2007 02:47 PM
DA Morgan | 1 | 57 |
| | | Oracle 9.0.
Is it possible to rename the column of a view? Or is the only way of
doing it is to drop and recreate the view with the new column...
Sashi
|
10-17-2007 10:44 AM
fitzjarrell@cox.net | 2 | 55 |
| | | Hallo !
My PL/SQL -Script send me a Error-Message.
I don't know how i find the error.
i want add a new range partition in a existing table...
sansar
|
10-17-2007 08:46 AM
sansar | 0 | 56 |
| | | hello
I'd like to do sth like this:
declare
a varchar(100);
begin
select version into a from v$instance;
if (a like '10%') then
@ver10.sql
else
abdoul85
|
10-17-2007 01:10 AM
DA Morgan | 5 | 60 |
| | | Hi,
I am trying to implement sending attachments using PL/SQL(java). I
searched the web for the process and I am not succesful in
implementing the...
nickli2000@gmail.com
|
10-17-2007 01:08 AM
DA Morgan | 1 | 54 |
| | | I had installed Oracle 10g client on Windows 2003 Server. Today I
uninstalled it and tried to install 9i client. But setup.exe does not
run. Some...
dn.perl@gmail.com
|
10-16-2007 08:53 PM
dn.perl@gmail.com | 3 | 64 |
| | | Hi Gurus,
Could anyone of you plz send me the documents to understand
complete Oracle Purchasing Module.
Thanks & Regards,
Saritha
sari.oracle@gmail.com
|
10-16-2007 01:39 PM
fitzjarrell@cox.net | 2 | 62 |
| | | Hi,
We created a script ( for sqldeveloper) to do insert data into our db.
When we look at the script on windows it lloks fine. On redhat linux we...
Mikael Petterson
|
10-16-2007 10:25 AM
Laurenz Albe | 1 | 59 |
| | | Hello
The problem is to adding a column to a big IOT table, 23 millions
records, when trying
the simple "add column.." we get too much undo, the DDL...
Nonor
|
10-16-2007 10:05 AM
fitzjarrell@cox.net | 1 | 57 |
| | | I've got this function that works great when I select from it from
dual:
select is_rejecting_fn(2408) from dual
returns 1
but If I attempt to use...
jobs
|
10-16-2007 06:13 AM
Jerome Vitalis | 1 | 52 |
| | | Hi Gurus,
Could anyone of you plz send me the documents to understand
complete Oracle Purchasing Module.
Thanks & Regards,
Saritha
sari.oracle@gmail.com
|
10-15-2007 08:08 PM
sari.oracle@gmail.com | 0 | 60 |
| | | On Sun, 14 Oct 2007 22:34:00 -0700, imu.ice wrote:
It is not the proper group. Follow-up to comp.databases.oracle.misc
For your question, have a...
Jerome Vitalis
|
10-15-2007 01:05 PM
Jerome Vitalis | 0 | 53 |
 | | Hi everyone,
I am developing a ASP.NET application (Framework 1.1) and since
migration from Windows 2000 Server to Windows 2003 Server I...
Gubo
|
10-15-2007 10:25 AM
Gubo | 10 | 150 |
| | | I'm working with a large table of time series data that contains 30
days worth of information (100 Million+ rows). The issue is that
every day we...
peter@alum.wpi.edu
|
10-14-2007 11:48 PM
Jack | 8 | 68 |
| | | Jobs in HCL-Noida/Gurgaon/Chennai/Bangalore/Mumbai
1. Citrix Admins - Noida - Chennai
2. Sun Solaris Admins - Noida - Chennai - Mumbai
3. HP Unix...
dbaguru
|
10-14-2007 11:54 AM
DA Morgan | 1 | 60 |
| | | Hello,
I have question if there are any differences between serveroutput in
Oracle 9 and 10.
On oracle 9 client // SQL*Plus: Release 9.2.0.1.0 -...
abdoul85
|
10-13-2007 05:30 PM
William Robertson | 4 | 55 |
| | | There is a sql script that updates a file and it took 20 minutes
about 10 days ago.
With a few more records that are updated it too 190 minutes on...
rogv24@yahoo.com
|
10-12-2007 07:05 PM
joel garry | 12 | 104 |
| | | /*
I'm having trouble updating multiple non-nullable columns in multiple
rows in a single table, using 2 different tables to get the
correlating...
kc
|
10-12-2007 09:26 AM
Brian Tkatch | 6 | 57 |
| | | I am looking at a script which has the following syntax for exp
utility :
exp "/ as sysdba" owner=$SCHEMA log=$LOGFILE file=$DMPFILE
consistent=y...
dn.perl@gmail.com
|
10-10-2007 03:30 PM
Maxim Demenko | 6 | 73 |
| | | hello,
I'm writing a simple script which shows informations about database.
The problem is that I have excecute:
select * from v$sysstat dssd where...
abdoul85
|
10-10-2007 02:20 PM
Jerome Vitalis | 3 | 45 |
| | | We recently upgraded to Oracle 10g. Does anyone know how to view the
progress of long operations in 10g?
In 9i Enterprise Manager, I was able to...
Dan
|
10-10-2007 02:30 AM
Carlos | 1 | 67 |
| | | Target Name=XXXXX
Target Type=Database Instance
Host=XXXXXXXXXXXX
Metric=Blocking Session Count
Metric Value=2
Blocking Session...
Amritha.Datta@gmail.com
|
10-09-2007 03:13 PM
fitzjarrell@cox.net | 1 | 53 |
| | | Hi All,
Could anybody of u provide some stuff regarding....
--> Forms Personalization
--> Difference b/w forms personalization and forms...
sari.oracle@gmail.com
|
10-08-2007 03:48 PM
sari.oracle@gmail.com | 0 | 50 |
| | | Hi everybody
I am learning how to use this tool from Oracle, to migrate from a
Sybase database to an Oracle 10g.
I have worked with DTS from SQL and...
Brenda
|
10-08-2007 12:53 PM
Frank van Bortel | 1 | 58 |
| | | I have some data in an Excel spreadsheet - about 100 -200 records - that I
need to import into Oracle, likely with some transformation required. I...
Tim B
|
10-08-2007 12:37 PM
Tim B | 8 | 64 |
| | | Hi, I have the following table
===========
STUDENTS
===========
ID NAME TESTDATE MARKS
=== ====== ========= ======
1 JOHN ...
send2r@gmail.com
|
10-08-2007 11:07 AM
Brian Tkatch | 7 | 55 |
| | | I need to add a date / time stamp to records as they are inserted into
a table. I need to do this at the server end.
Is there a "correct" way to do...
Arch
|
10-07-2007 09:15 PM
DA Morgan | 4 | 56 |
| | | I Want To Share Computer Security Information To All Internet Netter.
A. Computer Security Articles:
1. Firewalls Torn Apart
2. Guide To Social...
adam.archer.com.use@gmail.com
|
10-06-2007 12:06 PM
DA Morgan | 1 | 47 |
| | | http://vennelatechnologies.blogspot.com/
Oracle
|
10-06-2007 12:04 PM
DA Morgan | 1 | 56 |
| | | apparently I can't do this in 9i?
myarray := split(sendto, ',');
Any easy way to do it?
Thanks fo rnay help or information.
jobs
|
10-04-2007 10:06 PM
jobs | 6 | 112 |
| | | I have an outer query with subquery something like
select * from
(select * from dataset ds where ds.periodType = pt)
The inner subquery in my real...
ronscottlangham@yahoo.com
|
10-04-2007 04:43 PM
Mark D Powell | 2 | 58 |
| | | I have the following section of code in the pro*c program
exec sql declare provLicExpCursor cursor for
select unique...
ouyang.jie@gmail.com
|
10-04-2007 04:02 PM
sybrandb@hccnet.nl | 1 | 56 |
| | | It looks like you already have your answer but I thought I'd throw
this out anyway. It is similar. Perhaps right for a...
alex
|
10-04-2007 03:50 PM
joel garry | 6 | 64 |
| | | Hi,
I'm having a lot of problems using ROWNUM. Specifically, using ROWNUM in
the where clause to access a particular row. It seem that if I use...
Reds
|
10-04-2007 01:09 PM
Ed Prochak | 5 | 60 |
| | | Hi,
I have an oracle server with a "java stored procedure" that sends a
SOAP message to remote server over HTTP.
I upload the follow jar to my user...
sandro.salari@gmail.com
|
10-04-2007 10:38 AM
Vladimir M. Zakharychev | 1 | 93 |
| | | Dereck L. Dietz wrote:
SQL%BULK_ROWCOUNT
Demo in Morgan's Library at www.psoug.org under Array Processing.
--
Daniel A. Morgan
University of...
DA Morgan
|
10-03-2007 12:47 PM
Hasta | 1 | 53 |
| | | Hi.
We have this table that has a key call id_row where apparently, rowid
is inserted.
I'm trying to insert into that table from another...
jobs
|
10-03-2007 01:55 AM
DA Morgan | 1 | 50 |
| | | Is there a way to write a single SQL statement that will run a
statement if you are in Oracle and run another statement if you are in
MSDE? It has...
seannakasone@yahoo.com
|
10-02-2007 05:43 PM
joel garry | 6 | 65 |
| | | Hi,
I am currently using OleDb in c# .net to connect to an Oracle
database.
I do this by referencing a 'data source', this data source is an...
arun.hallan@gmail.com
|
10-02-2007 10:56 AM
Niall Litchfield | 6 | 77 |
| | | Source: http://www.msnbc.msn.com/id/21033161/
SEATTLE - Microsoft Corp.'s Excel 2007 spreadsheet program is going to
have to relearn part of its...
DA Morgan
|
10-01-2007 01:05 PM
Ed Prochak | 2 | 59 |
| | | hi ..i was new to oracle and i have a question...
suppose there are two users x and y say..
if user X grants previlages on a object O to y..
1)how...
teja
|
09-29-2007 10:15 AM
DA Morgan | 2 | 56 |
| | | I'm working with Oracle 10, and it appears that exceptions do not propogate
from one package to another. Is this true, and if so, is there a way...
Tim B
|
09-29-2007 10:14 AM
DA Morgan | 3 | 66 |
| | | I'm trying to email several addresses. My script works great when it's
only going to one address, but if I attempt to send to mulitiple
nothing get's...
jobs
|
09-28-2007 05:04 PM
DA Morgan | 6 | 110 |
| | | Hello fellow DBA's,
I've read a article from Burleson where he's an enthusiast about solid
state disks:
" It's important for all Oracle...
Helma
|
09-28-2007 09:40 AM
Helma | 8 | 81 |
| | | Hi,
i have an oracle database and a mysql database.
in both i have some same tables.
if data is changed or inserted on oracle site, then i want to...
Micha
|
09-28-2007 09:32 AM
Ana C. Dent | 1 | 56 |
| | | Table question
I have a table with two columns, e.g.:
FORM COUNT SEP
Xg 2
Gu 8
Iu 9
Vi 1
Wt 4
alex
|
09-27-2007 05:04 PM
DA Morgan | 2 | 54 |
