| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
We use TOAD as our GUI to see the database. I put in a query that
selects from V$SQL, but I get a missing expression. The same query
works...
Mtek
|
06-17-2008 08:40 AM
Mtek  | 24 | 150 |
| | | Hello,
I have a (application-)database which is filled with polygons, also
there is a administrative coupling on a guid. The guid is unique for
the...
Eduard Witteveen
|
06-17-2008 04:20 AM
Shakespeare | 36 | 115 |
 | | Los Angeles Locksmith Services, Lockout Rekey Install Locks and Keys
Made Home Car Auto
http://locksmithhome.com/default.aspx
World Marketing
|
06-16-2008 03:27 PM
World Marketing | 0 | 24 |
| | | Training Classes for Oracle10g, 9i, 8i
Certification training in Oracle10g and 9i: DBA, Developer,
Discoverer. training conducted at your location...
Winder
|
06-16-2008 04:54 AM
Winder | 0 | 25 |
| | | Hello,
what is the best way to create a sequence with a dynamic start value.
The following statement is not valid:
create sequence TEXT_SEQ start...
Norbert Pürringer
|
06-15-2008 08:37 PM
madhusreeram@gmail.com | 16 | 65 |
| | | HCL, Aricent, Infosys and many more companies hiring fresh &
experienced engineers ,
FIND UR DREAM JOBS AT GIVEN BELOW LINKS: - ...
Career Point
|
06-13-2008 11:46 AM
Career Point | 0 | 29 |
| | | Hi,
We have an update trigger on a table for some auditing purposes. Is
there a way to find the actual program that updated the underlying
table? ...
Mtek
|
06-12-2008 05:28 PM
DA Morgan | 8 | 30 |
| | | Using 11g OEM (via https://machine:1158/em/)
With Oracle 10g OEM, the desktop version, I could use the "Change
Manager" program to compare two...
Luch
|
06-12-2008 05:26 PM
DA Morgan | 12 | 51 |
| | | Moving tables from MS-Access to Orcale 10g changes double field types
to Varchar2.
Any ideas why and suggestions on how to get them to...
timmg
|
06-12-2008 10:48 AM
timmg | 8 | 20 |
| | | if i
select * from user_updatable_columns
i get information if column in table is updatable or not, insertable or
not, deletable or not.
What makes...
Tomo
|
06-11-2008 09:13 AM
fitzjarrell@cox.net | 20 | 74 |
| | | if i
select * from user_updatable_columns
i get information if column in table is updatable or not, insertable or
not, deletable or not.
What makes...
Tomo
|
06-11-2008 03:33 AM
Tomo | 0 | 28 |
| | | Hello,
we have a forms 10 application that run very well on a win 2000 server.
Now we migrated to a win 2003 TS and the application became very...
Andreas Moroder
|
06-11-2008 01:42 AM
Shakespeare | 4 | 19 |
| | | Hi!
Does anyone have any experience with Oracle spatial? I'm trying to use
a new function SDO_SAM.SIMPLIFY_GEOMETRY but with little success...
krwoloq@gmail.com
|
06-11-2008 01:32 AM
Shakespeare | 4 | 33 |
| | | Scenario:
- Windows Server 2003
- Apache 2.2.8 (latest)
- PHP 2.2.6 (latest)
- Oracle 10g (remote machine)
- Oracle Client 10g Express Edition
I...
Álvaro G. Vicario
|
06-10-2008 11:53 AM
Álvaro G. Vicario | 0 | 29 |
| | | I wrote a Stored Procedure wherein I use a Cursor to extract multiple
rows and columns. I then write them into the buffer
(dmbs_output.put_line). But...
Bill Wordsworth
|
06-09-2008 05:01 PM
DA Morgan | 20 | 62 |
| | | Could Oracle store Electroencephalography data ?
moongeegee
|
06-09-2008 04:58 PM
DA Morgan | 20 | 67 |
| | | logminer.mine_value giving error ORA-01323: Invalid state
I am trying to capture changes using logminer
and I am getting ORA-01323: Invalid...
Rao
|
06-09-2008 11:07 AM
Rao | 0 | 24 |
| | | Is it possible to insert or alter comments of an existing job without
recreating it?
something like
comment on job schema.job is...
TD
|
06-09-2008 09:49 AM
fitzjarrell@cox.net | 4 | 23 |
| | | Hello,
I maintain an application using Pro*C programs to access to an Oracle
database.
For the moment, programs and datas are together located on...
sebastien.reynes@gmail.com
|
06-06-2008 03:30 AM
Laurenz Albe | 8 | 20 |
| | | Hello,
Say If I have a table with column a, and column b (say they are
integers).
Sometimes I will do a query with a where clause that just...
doug
|
06-05-2008 11:01 PM
news.verizon.net | 16 | 39 |
| | | I am taking a left outer join to which I would like to add a
condition.
create table tmp_nani_student(stid number) ;
insert into tmp_nani_student...
dn.perl@gmail.com
|
06-05-2008 06:22 AM
dn.perl@gmail.com | 0 | 22 |
| | | I need to be able to create a oracle text index (domain index) on
NCLOB and NVARCHAR2 fields. We need to be able to support searching
for chinese and...
Ryan
|
06-04-2008 01:18 PM
Ryan | 0 | 56 |
| | | Hello,
(I've post this message on php newsgroup too, without success...)
When executing PL-SQL code from php, is there a way to obtain the
result...
Jeanpaulik
|
06-04-2008 03:46 AM
Frank van Bortel | 8 | 32 |
| | | World Marketing Company Increase Your Website Traffic Formerly Free
Traffic Tips - Website, Blog.
Small Large Business Marketing - Small Large...
World Marketing
|
06-03-2008 04:54 PM
World Marketing | 0 | 28 |
| | | I'm currently querying the USER_* views to do introspection
on a user's schema. But, in order to handle aliases, I need
to use...
mh@pixar.com
|
06-03-2008 12:59 PM
Mark D Powell | 8 | 16 |
| | | Hello,
I could not find an answer for my following problem through Google,
maybe because I did not find the best keywords. So I hope that one of
you...
Hans Mayr
|
06-03-2008 10:25 AM
Ed Prochak | 28 | 48 |
| | | "Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
In one session I lock a row
begin
select the_ID, COMMENT_TXT into...
Malcolm Dew-Jones
|
06-02-2008 05:48 PM
Malcolm Dew-Jones | 16 | 38 |
| | | Info:
Windows XP Pro SP2
Oracle 10G Express Edition
V8 Oracle Call Interface (OCI)
MSVC 8.0
I have a table that has a value column of type...
yojrod@gmail.com
|
06-02-2008 05:17 PM
yojrod@gmail.com | 0 | 24 |
| | | Hi,
assume a situation where we have two tables:
create table t1 (c1 number, c2 varchar2(10));
create table t2 (c1 number, c2 date);
and a select...
Mathias Waack
|
06-02-2008 11:27 AM
fitzjarrell@cox.net | 8 | 20 |
| | | I'm pleased to announce the initial release of OraPIG,
the Oracle Python Interface Generator.
OraPIG generates Python wrapper classes for Oracle...
mh@pixar.com
|
05-31-2008 01:11 PM
DA Morgan | 32 | 72 |
| | | Hi..i have this trouble ....
i have table A wich this data
cod_group bill_type
GROUPA BILLTYPE1
GROUPA BILLTYPE2
GROUPB...
zamba
|
05-30-2008 04:40 PM
fitzjarrell@cox.net | 12 | 45 |
| | | Hi,
When you have a loop and use the "EXIT WHEN" clause, can you use it
more than once? What if you have multiple places in the code where
you...
amerar@iwc.net
|
05-29-2008 01:14 PM
amerar@iwc.net | 12 | 37 |
| | | Hello,
I would like to know, how secure Oracle is against modifications in
names of system tables or system table columns from version...
Norbert Pürringer
|
05-28-2008 10:59 AM
gazzag | 12 | 41 |
| | | Does Oracle (10g) have a built-in function to convert an IPv4 address in
long format into dot notation?
For example from 3494755494 to...
Álvaro G. Vicario
|
05-27-2008 04:54 PM
sircco | 16 | 54 |
| | | Is there any simple way to extract the table names of a given SELECT
query without actually running it?
I've implemented a very simple results cache...
Álvaro G. Vicario
|
05-24-2008 08:59 AM
Frank van Bortel | 28 | 59 |
| | | Hi,
I am seeking information on Berkeley openldap db and use of utilities such
as db_verify and if there is also a gui
I have had a looked at...
sammy
|
05-24-2008 12:16 AM
sammy | 4 | 21 |
| | | Sorry for the repost, but got zero replies to this post when first sent a
couple of weeks ago, and would really appreciate and advice or...
Geoff Muldoon
|
05-23-2008 01:41 PM
DA Morgan | 32 | 78 |
| | | Hi All,
I have a simple question but i am in a fix coz of it.
This is regarding Oracle Merge statement.
The question is:
I have a table...
idey
|
05-23-2008 04:30 AM
idey | 24 | 69 |
| | | Hi,
This page describes a tool to move data from Excel to Oracle.
http://thinktibits.blogspot.com/2008/04/excel-to-oracle-oraexcel.html
Can...
OracleOCA
|
05-22-2008 07:54 PM
admin@sqlexcel.net | 24 | 90 |
| | | Hi.
Forgive the news server I'm posting from; it's the only one I have easy
access to here at work, and it's a work-related problem.
Yesterday, we...
Fleetie
|
05-22-2008 12:00 PM
Frank van Bortel | 48 | 111 |
| | | Hi all
i am not able to wrap a line in toad.
jagdeepsaini1@gmail.com
|
05-22-2008 08:07 AM
idey | 4 | 29 |
| | | Hello people,
I can't find out if Oracle content db really admits to be interfaced
by a jsr-170 interface (aka jcr, for java content repository)....
Andres Hurtis
|
05-21-2008 09:11 PM
Andres Hurtis | 0 | 25 |
| | | I posted this in the mysql newsgroup before finding this one. My db is
oracle. So, here it is:
***************
I have a table like this: ...
sheldonlg
|
05-21-2008 05:24 PM
sheldonlg | 8 | 28 |
| | | Could you tell me the options which we have to check in the options
tab in Pro*c window.Its urgent.
What we have to do after pre-compiling.Please...
bharath
|
05-21-2008 01:11 PM
Ed Prochak | 24 | 77 |
| | | Hi,
I am running TOAD 9.1 with Oracle 10g, but I tried this with an
evaluation of TOAD 9.6 and it still exists.
I started using collection set...
asafm
|
05-21-2008 08:16 AM
Frank van Bortel | 4 | 35 |
| | | I'm using 10g R2 on Solaris.
Is there a way to use the Database Configuration Assistant in a text
only mode (no graphical display)?
Arch
|
05-21-2008 08:14 AM
Frank van Bortel | 12 | 79 |
| | | Thanks everyone for all the excellent suggestions.
Special thanks to winner Malcolm Dew-Jones for
OraPIG -- Oracle Python Interface...
mh@pixar.com
|
05-20-2008 08:05 PM
Malcolm Dew-Jones | 8 | 20 |
| | | So, we've got a nice program that will introspect
a PL/SQL package and generate python interface for
it. It's nice, because we can provide an...
mh@pixar.com
|
05-20-2008 03:15 AM
mh@pixar.com | 40 | 79 |
| | | Hi,
I am trying to calculating the following with SQL:
Stock Date Price
X 5/1/2008 10
X 5/2/2008 12
X 5/3/2008...
nickli2000@gmail.com
|
05-19-2008 01:56 PM
nickli2000@gmail.com | 32 | 76 |
| | | Hello all.
I have a question regarding the tablespace size. Assume that I create
the new database and now I wanted to create the Application for...
scorpio1348@yahoo.com
|
05-17-2008 08:34 PM
DA Morgan | 8 | 18 |
