| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
I currently have a package and contained within it I have 2
procedures.
The first procedure has a parameter (SEQ_ID) passed into it from...
christophercash@hotmail.com
|
12-22-2007 04:11 PM
Galen Boyer  | 3 | 214 |
| | | Hello I am new to Oracle. What I am trying to do is basic, I think. I
typically use toad to run select statements. I want to be able to
create a...
AP
|
12-22-2007 04:04 PM
Galen Boyer | 4 | 232 |
| | | Here's my situation - I'm working on a large scale data cleanup
project and part of my duties include finding and fixing data
anomolies such as date...
syclone98@hotmail.com
|
12-22-2007 10:09 AM
Mark D Powell | 3 | 203 |
| | | http://coderbuzz-programming.blogspot.com/2007/12/oracle-interview-questions-1.html
raae
|
12-21-2007 01:24 PM
raae | 0 | 235 |
| | | Hi,
We have a master table, say with two columns name (varchar) and id
(number) and a stored procedure insert_name_details(name, other
details).
SP...
sameergn@gmail.com
|
12-20-2007 04:06 PM
Robert Klemme | 9 | 201 |
| | | Hi.
Anyone can guide me on this.
I have a legacy structure where i have 12000 clients. each client has
a password.
Table_Name = clients
Fields= ...
Aquiles.-
|
12-19-2007 07:13 PM
Pedro Lopes | 6 | 258 |
| | | Hello,
i am having trouble creating tables from a package using oracle 10g.
i am logged in as user 'testuser' and am working in the users...
andized@gmx.net
|
12-19-2007 12:04 PM
fitzjarrell@cox.net | 19 | 487 |
| | | Dear Friend,
We are a chennai based well reputed HR consulting & recruitment
company.
Presently one of our esteemed MNC client in the IT consulting...
Baffin Management Solutions
|
12-19-2007 11:48 AM
DA Morgan | 2 | 279 |
| | | Hi,
I have to following problem:
I get X rows from a statement, these are sorted by a certain column,
let's say an numerical value.
Now I want to...
Jens Riedel
|
12-18-2007 10:16 AM
Jens Riedel | 2 | 234 |
| | | Hi there,
I have a profile configured to lock users' accounts after 3
unsuccessful login attempts. Is there a view that can tell me how
many...
steven@ferretlovers.com
|
12-18-2007 09:25 AM
Jerome Vitalis | 1 | 211 |
| | | Dear all
I am installing Oracle10g (10201_database_linux_x86_64.cpio.gz
(758,433,170 bytes) (cksum - 2921604215))
on RHEL5 64bit # uname -a
Linux...
madunix
|
12-17-2007 10:05 AM
fitzjarrell@cox.net | 1 | 266 |
| | | Is there a way to display a trigger programatically, or via commandline,
or via sql code? The only way I know how to display a trigger is to...
Sean Nakasone
|
12-15-2007 03:20 AM
Thomas Kellerer | 2 | 218 |
| | | Why in Forms sometimes is problem with copy and paste in application made in
Oracle Forms Developer 10g.
:)
grybi
|
12-13-2007 04:17 PM
Frank van Bortel | 1 | 232 |
| | | Hi
my config.
Oracle 10g
RedHat linux fedora 4
Host=winxp pro sp2
tool=vmware
When I use runInstaller to install oracle, there are some exceptions...
Jacky
|
12-13-2007 11:41 AM
shakespeare | 2 | 266 |
| | | Hello,
in our system, we want to classify messages (stored in a table) with
certain attributes (sort them into categories). Later, we want to...
Marten Lehmann
|
12-13-2007 11:15 AM
Maxim Demenko | 3 | 231 |
| | | On Oracle 9.2.0.5, windows 2000 server,
select * from SYS.dba_ddl_locks
after a time being resulted with an error
ORA-04030: out of process memory...
Tomo
|
12-13-2007 08:48 AM
Tomo | 3 | 314 |
| | | I am trying to use the UNION ALL in a CURSOR declaration. It compiles
fine and
when we run the program it fetches only the rows corresponding to...
boopathi.it@gmail.com
|
12-12-2007 02:01 PM
grybi | 2 | 267 |
| | | Hi,
I have requirement to sort the data something similar to Dictionary.
For example: I have to get the words those have starting character :
spaces,...
aru
|
12-12-2007 09:48 AM
aru | 3 | 300 |
| | | Production servers: RAC Oracle 10g 10.2.0.3, AIX 5.3 ML3, 2 Nodes IBM
pSeries 550.
Symptoms:
CRS Status "Can not communicate with CRS" After the...
madunix
|
12-11-2007 11:08 PM
DA Morgan | 3 | 305 |
| | | 143.204.94.82:2384 open socks4 proxy was used on 22 November for a
Hipcrime attack on nanae. And I got the port number by Googling so it
must have...
Tester
|
12-11-2007 10:50 PM
Tester | 0 | 218 |
| | | http://coderbuzz-programming.blogspot.com
lawry_jim@yahoo.com
|
12-11-2007 12:55 PM
lawry_jim@yahoo.com | 0 | 270 |
| | | After moving several tables from one tablespace to another, will the
original
table still exist?
I've issued the Alter Table Move Tablespace command...
jjablt@hotmail.com
|
12-10-2007 10:46 PM
DA Morgan | 1 | 268 |
| | | Hello all.
I am experiencing a core dump in a "OracleConnect" method we have
written.
Here is the stack trace:
#0 0xb695fdd1 in sqlsadr () from...
aj
|
12-10-2007 04:50 PM
aj | 0 | 269 |
| | | I would like your help on the following situation:
Anybody who has worked with oracle forms 6i on solaris on sparc machines with sun keyboard, should...
Aggelos
|
12-10-2007 03:06 PM
shakespeare | 2 | 274 |
| | | Suppose you have a SELECT stmt of form:
SELECT Field1, Field2, Field3
FROM Table1
WHERE etc
What would it take to generate a file from the output...
Occidental
|
12-10-2007 01:14 PM
joel garry | 5 | 256 |
| | | Read briefly on Oracle's web site that they've added a "hands-on"
training requirement to the OCA/OCP certs... to "enhance their value"
or some...
dananrg@yahoo.com
|
12-07-2007 07:59 PM
joel garry | 2 | 217 |
| | | CREATE TABLE SQL_TABL (
ORD_DATE Date,
PROD_CODE Varchar2(10),
CUST_CODE Varchar2(10),
QTY ...
Totti
|
12-07-2007 02:13 PM
Ed Prochak | 4 | 239 |
| | | Hi,
Please accept my apologies if this is the wrong group to post to.
I have an issue with processing XML. I have a CLOB which contains XML....
Raj
|
12-06-2007 09:39 PM
Raj | 0 | 266 |
| | | Hello!
Big problem in subject :-) ples send me some page or info how can i do it.
thx
anotnio12
|
12-05-2007 09:26 AM
DA Morgan | 1 | 277 |
| | | CREATE TABLE SQL_TABL (
ORD_DATE Date,
PROD_CODE Varchar2(10),
CUST_CODE Varchar2(10),
QTY ...
Totti
|
12-05-2007 09:10 AM
Brian Tkatch | 1 | 243 |
| | | Hi everyone,
I have a book table and in that table it has the book tile, publisher, and
type of book it is. example mystery, scifi, etc...
I am...
Jeff B
|
12-04-2007 06:01 PM
ssanchezz@gmail.com | 10 | 160 |
 | | Good afternoon,
I am try to figure out how to format a calculated column in a query but am
not finding how to do it or if I can do it?
Here is my...
Jeff B
|
12-04-2007 05:46 PM
joel garry | 6 | 83 |
| | | Hello all,
Say I have a worst case scenario in my development environment where
our production
server and our version control are out of sync. We...
Redrobot5050
|
12-04-2007 03:44 PM
DA Morgan | 5 | 88 |
| | | Greetings from CES!!!
Hope you are doing great.
CES Pvt Lt d is an Organization bringing ahead PERMANENT OPPORTUNITIES
with CLIENTS - Oracle...
CES
|
12-04-2007 01:23 AM
CES | 0 | 106 |
| | | Hi.
This is sort of like asking how to do a comma operator in sql on
Oracle.
I'm not sure how to approach asking the question, or even search for
it...
kishjeff
|
12-03-2007 02:32 PM
kishjeff | 3 | 103 |
| | | Hello,
currently, we are using strings like "pending" or "finished" in some
tables to specify the state of certain jobs stored in these...
Marten Lehmann
|
12-03-2007 11:12 AM
Brian Tkatch | 13 | 133 |
| | | Hi,
I am new in oracle and java. i am trying to find where i can get the
oraclexml.jar or .java coz i want to use getxml function. i found a
whole...
Krista
|
12-02-2007 09:54 PM
Ana C. Dent | 3 | 339 |
| | | I have an oracle database that has text values (comments) in
subsequent rows and I need to add them all together by the primary
key.
primary key ...
sheridany
|
12-02-2007 04:51 PM
DA Morgan | 3 | 123 |
| | | http://oracle-programming.blogspot.com
jim
|
12-02-2007 11:25 AM
jim | 0 | 112 |
| | | I have this query with a condition in Access and would like to know
how I can put a condition part in Oracle 9i SQL similiar to how Access
does...
francan00@yahoo.com
|
12-02-2007 11:03 AM
sybrandb@hccnet.nl | 3 | 87 |
| | | Good Morning,
Is it possible to change a column name of a table after the table has been
created? I have a table called Members that have...
Jeff B
|
12-02-2007 09:04 AM
Charles Hooper | 2 | 76 |
| | | ..:: Unix and Linux Hacking and Security ::.
1. Unix - Vulnerabilities and Advisories
-- Tutorials and Papers
-- Specific Exploits and...
Andrena.Markley.group.com@gmail.com
|
12-02-2007 05:49 AM
Andrena.Markley.group.com@gmail.com | 0 | 80 |
| | | Interested in practical experience with Oracle replication, esp. when
replicating blobs in medium-sized databases.
What have you chosen, why, and...
array7@inbox.com
|
11-30-2007 09:14 PM
array7@inbox.com | 4 | 112 |
| | | Hi,
I have a number of questions regarding the installation of Oracle 10g
Express on a pc.
Does anybody know the processor requirements to run Oracle...
CHRISHA
|
11-30-2007 02:53 PM
Frank van Bortel | 1 | 104 |
| | | We use 9.2.0.6.
We have a 'problem' to execute an update command like
update <tablename>
set expression=
'STEPSTEP29' ...
jochen
|
11-30-2007 09:37 AM
fitzjarrell@cox.net | 1 | 107 |
| | | Hello all,
please consider the following query:
select 12*sal yearly, yearly+comm
from emp;
I would expect that the alias can be used in the next...
vezerid
|
11-30-2007 09:32 AM
Ken Denny | 5 | 96 |
| | | Hi,
I have a query in which I have a value that is repeated a number of
times in the where clause. If I use the 'in' clause it returns only 1
value...
Sandy80
|
11-30-2007 03:22 AM
Viktor Wiens | 3 | 92 |
| | | SELECT A.CIPACTIVITY_SYS_CODE, A.CIP_NAME,
TO_CHAR(A.CIP_START_DATE,'DD/MM/YYYY'),
A.DURATION_HRS, A.DURATION_MINS,...
maha.sasibindhu@gmail.com
|
11-30-2007 12:24 AM
Ed Prochak | 1 | 102 |
| | | йенс мартин шлаттер wrote:
I don't want to know.
No - I don't!
--
Regards,
Frank van Bortel
Top-posting is one way to shut me...
DA Morgan
|
11-29-2007 02:19 PM
Ed Prochak | 13 | 158 |
| | | DATA MANIPULATION PROGRAMMING LANGUAGES
For Data Transformation and Data Preparation, there are several
choices. All of them are useful, none are...
Robert
|
11-29-2007 01:03 PM
Robert Klemme | 2 | 90 |
