| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi all,
In the Pro*C code at the bottom, I was trying to execute a function
that returns a cursor. However, as I would only know the exact name...
loyeah@gmail.com
|
02-27-2008 10:03 PM
loyeah@gmail.com  | 4 | 24 |
 | | Hello,
I have a view V_BASE. Now I created a query with the following
structure:
WITH w1 AS ( SELECT ..... V_BASE ....)
SELECT * FROM...
Hans Mayr
|
02-27-2008 07:26 AM
Hans Mayr | 28 | 60 |
| | | Hi.
I'm trying to get a piece of genetic software from Applied Biosystems
to work, called GeneMapper 3.0. It uses an oracle 8.1.7 database. I
tried...
b.cain@mmu.ac.uk
|
02-26-2008 02:04 PM
joel garry | 4 | 30 |
| | | Hi:
Please let me know if you have any resources with you.
Position: Jr. Oracle 10g DBA with Data Modeling
Location: Lansing, MI
Duration: 12...
Sachi Tadepalli
|
02-26-2008 11:43 AM
fitzjarrell@cox.net | 4 | 30 |
| | | Hi,
google says no, and my SQL-reference I have doesn't mention it.
Thats why the question:
In other DBs it is possible to define a foreign key...
Norbert Winkler
|
02-25-2008 04:41 PM
sybrandb@hccnet.nl | 8 | 24 |
| | | I need a hand with SQL. I'm using 9.2.0.4.
I need to compute a date offset by a number of weeks from another
date. This is a line from a view that...
Arch
|
02-25-2008 03:26 AM
William Robertson | 28 | 60 |
| | | When you use the sql*plus connect command, how does sql*plus know
which instance to connect you to? Does this depend on the value of the
ORACLE_SID...
nick
|
02-24-2008 02:17 PM
Mark D Powell | 8 | 24 |
| | | Hi,
We have a stored procedure in which we replace numeric internal
currency code to ISO currency code using a lookup table. The procedure
handles...
joshianant@gmail.com
|
02-24-2008 04:40 AM
shakespeare | 64 | 129 |
| | | Mentorship/ Guidance available for switching
into highly paid ERP (Software)
ORACLE APPLICATIONS Career
Team of experts from USA relocated to...
base
|
02-23-2008 05:03 AM
base | 0 | 21 |
| | | When you issue a startup command from sql*plus, how does sql*plus know
which database to connect you to?
Thanks
nick
|
02-22-2008 11:07 PM
Ana C. Dent | 4 | 25 |
| | | Hello,
I'm running an Oracle 10.1.0.2.0 and Oracle XE on Windows maschines. Now
I need to create several directory entries for folders on a...
Thomas Sommerfeld
|
02-21-2008 12:08 PM
Thomas Sommerfeld | 8 | 18 |
| | | Estamos buscando profissionais Junior, Senior e Pleno p as seguintes
vagas:
- Consultor Funcional - Developer ABAP/4 PL -
Para atuar em Hortolândia...
Taís
|
02-21-2008 09:57 AM
Taís | 0 | 32 |
| | | Hello,
This is the standard example for self joins:
SELECT e.last_name employee, m.last_name manager
FROM employees e INNER JOIN employees m
ON...
Hans Mayr
|
02-21-2008 09:31 AM
Hans Mayr | 8 | 24 |
| | | Hello Mark D Powell, Robert Klemme, Michael O'Shea, David FitzJarrell
and thank you for your help before.
I have a table called "table2" that has...
jharbour7@googlemail.com
|
02-20-2008 03:46 PM
fitzjarrell@cox.net | 8 | 25 |
| | | Estamos buscando profissionais para vagas com seguinte perfil:
Informatica Power Center ETL Oracle - Com Ingles Avancado-Fluente
Para atuar em Sao...
Taís
|
02-20-2008 11:14 AM
Taís | 0 | 34 |
| | | http://languages-languages.blogspot.com/2008/02/oracle-essentials.html
john_mattheew@yahoo.com
|
02-20-2008 10:57 AM
john_mattheew@yahoo.com | 0 | 31 |
| | | Hello Mark D Powell, Robert Klemme, Michael O'Shea, David FitzJarrell
and thank you for your help before.
I have a table called "table1" that has...
jharbour7@googlemail.com
|
02-19-2008 08:45 AM
Michael O'Shea | 4 | 22 |
| | | This is my first post to Google groups. I am write with a new program
I am writing using Oracle XE on Windows XP home.
Here it is.
I have a table...
jharbour7@googlemail.com
|
02-19-2008 08:23 AM
Michael O'Shea | 36 | 81 |
| | | Hi folks,
Virtualization is the process of abstracting computing resources so
that multiple operating system and application images can share...
Praveen
|
02-19-2008 06:46 AM
shakespeare | 8 | 30 |
| | | Dear friends,
I am facing problem to store 3D data using
shp2sdo.exe and sql loader
i have done completely shp2sdo ....and store 3D shape file...
chandrakishore.bankhede@gmail.com
|
02-18-2008 02:42 PM
fitzjarrell@cox.net | 4 | 26 |
| | | Rookie here. Is there a sqlplus command, something like desc, that
also lists column contraints?
Thanks
danwal456@yahoo.com
|
02-18-2008 09:33 AM
Mark D Powell | 8 | 25 |
| | | Hi,
I have a variable field of type varchar2 called storeId. I need to
sort the store Id's but they are of variable length and some of them
contain...
C-man
|
02-18-2008 07:31 AM
Ed Prochak | 16 | 48 |
| | | Hi ng,
we got a software that often causes any locks/deadlocks.
We look for the reason for this and I found V$LOCK and V$SQL.
The problem is, that I...
Andreas Mosmann
|
02-17-2008 09:58 AM
Rainer Klomps | 36 | 83 |
| | | This may have been reported by someone, but I just want to share it
with you, just in case.
I am using sqlplus ( Release 10.1.0.5.0 - Production),...
John
|
02-15-2008 05:10 PM
Malcolm Dew-Jones | 28 | 62 |
| | | Is there any way of creating temporary tables (in memory) using PL/SQL
(Oracle 9i)? Then update values in those rows from those in-memory
temp tables...
dananrg@yahoo.com
|
02-15-2008 03:25 PM
Urs Metzger | 24 | 56 |
| | | Hi Guys,
We are taking on a couple of junior PLSQL programmers straight out of
university who are well versed with the basics of PLSQL. We...
christophercash@hotmail.com
|
02-15-2008 11:55 AM
christophercash@hotmail.com | 0 | 28 |
| | | Hello,
some weeks ago I asked for a fuzzy string search. Someone posted an
example using Oracle Text.
Now I'm interested in a similar, but...
Marten Lehmann
|
02-13-2008 02:11 PM
Marten Lehmann | 24 | 53 |
| | | I have a table on...
NN
|
02-13-2008 12:42 PM
Charles Hooper | 12 | 69 |
| | | Hello,
When using Powerbuilder with Oracle, in some cases oracle skips numbers.
What I mean is that when the ID column has a value of 100, instead...
vasilis
|
02-13-2008 02:42 AM
William Robertson | 28 | 58 |
| | | http://programming-languages-tutorials.blogspot.com
davi
|
02-12-2008 02:39 PM
Shakespeare | 4 | 28 |
| | | Hi,
www.brainbeez.com is offering free certifications on various IT
and NON-IT subjects like Aptitude, English, C, C++, JAVA, ORACLE,
FINANCE,...
Ria
|
02-12-2008 12:33 PM
DA Morgan | 4 | 25 |
| | | Hello.
I want to make a RSS feed reader in PL/SQL, that gets feeds from one
table, parses it and inserts the news into another table.
In order to...
Rune Smedstuen
|
02-12-2008 04:30 AM
Rune Smedstuen | 0 | 22 |
| | | Hi All,
I have the following query. For a few records, it returns duplicate
CUSTOMER_ID's, though the rest of the record values are different.
I...
amerar@iwc.net
|
02-11-2008 09:37 AM
Ken Denny | 24 | 121 |
| | | When I try to use 10g and SQL Navigator I get the following error when
SQL Navigator tries to start.
Error: 1.0
I can't seem to find an answer on...
General Fear
|
02-10-2008 01:58 PM
DA Morgan | 4 | 48 |
| | | Hello,
I have created a view, that most of its column are functions.
I know what exactly are the tables inside that function,
but when I put all...
Mr. X.
|
02-09-2008 08:44 PM
Mark D Powell | 16 | 44 |
| | | First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that...
mh@pixar.com
|
02-08-2008 04:35 PM
DA Morgan | 20 | 67 |
| | | Hi,
We are evaluating different ways for a one-way replication from one
database to another. Additional requirement is, pat of replicated...
Isaac Blank
|
02-08-2008 04:07 PM
Isaac Blank | 24 | 59 |
| | | Hi all,
I need to register the schema as an XDB schema. I tried using
registerschema to create the schema ( name of the schema is
Address.xsd) but...
Anto
|
02-08-2008 12:54 PM
Anto | 0 | 19 |
| | | Hey all, I'm having a problem with what should be a simple query. I
don't know if my brain is fried today or what, but hopefully the
following...
TonyV
|
02-08-2008 12:35 PM
shakespeare | 20 | 54 |
| | | Hi all,
I have two questions regarding PL/SQL, batch jobs, sqlplus and VPD and
I'd be glad if someone could help me clarify. NB! this is not...
xylem
|
02-08-2008 10:28 AM
fitzjarrell@cox.net | 32 | 86 |
| | | Hello.
I want to present my query in a table (it is for flat - report).
suppose there are 5 students, and several courses that each course has...
Eitan M
|
02-08-2008 10:07 AM
fitzjarrell@cox.net | 20 | 65 |
| | | Hello all
in our Enterprise Manager 10g, the number of active HTTP connections and
requests keep growing at a rate of 16/minute. I'm reaching now...
pher
|
02-08-2008 09:36 AM
pher | 12 | 42 |
| | | Hi all, I'm running a simple select by joining two tables.
I get an output of about 1.3 million rows:
SQL> SELECT count(*) from...
Sashi
|
02-07-2008 10:12 AM
Mark D Powell | 8 | 24 |
| | | Hi,
We have an Immediate Opportunity for you as Oracle Financial
Functional Consultant.
Location : Long Island, NY.
Babbs
|
02-07-2008 09:14 AM
Babbs | 0 | 16 |
| | | Hi,
We have an Immediate Opportunity for you as Oracle Financial
Functional Consultant.
Location : Long Island, NY.
Babbs
|
02-06-2008 05:57 PM
Babbs | 0 | 22 |
| | | A bit a newbie to Oracle so I apologize if this is a simple question.
I need to implement two tables similar to the classic order and order
details...
Digital Logic
|
02-06-2008 11:04 AM
Mark D Powell | 20 | 58 |
| | | Hi folks,
couple of guys are launching a video site for learning Oracle.
http://OracleTube.com
check it out and i hope you like...
Praveen
|
02-05-2008 02:54 PM
Frank van Bortel | 20 | 66 |
| | | If one uses substrb on a MBCS string, will the returned result
possibly include a "partial character" (i.e., only the leading byte or
bytes of a...
michael.young@paetec.com
|
02-04-2008 09:05 PM
michael.young@paetec.com | 4 | 27 |
| | | We have a database where users can make ad hoc queries. I would
like to be able to log all queries and dml for this database,
so that we can have...
mh@pixar.com
|
02-04-2008 07:33 PM
mh@pixar.com | 8 | 29 |
| | | There is command 'Optimize Table' in MySQL. What is the equivalent of
this in Oracle?
And if none, how to optimize an Oracle (10g) table?
Thx.
mansoor531@gmail.com
|
02-04-2008 06:26 PM
DA Morgan | 60 | 136 |
