| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Contact : Sudin
Direct : 402 218 2179
Email : sudin (AT) kraftware (DOT) com
Hi,
We have the following SAP SD and SAP CRM consultant...
mandarkraftware@gmail.com
|
05-29-2007 10:54 AM
mandarkraftware@gmail.com  | 0 | 32 |
| | | i've this view:
CREATE OR REPLACE FORCE VIEW "ANM_FAMILIARE" ("ID_MAL", "MALATTIA",
"ID_PAZ", "PARENTELA") AS
SELECT id_mal, malattia, id_paz,...
Mariano
|
05-29-2007 09:58 AM
Thorsten Kettner | 1 | 44 |
| | | I seem to have got myself into a bit of a pickle with this one.
After creating the 'THIS_IS_MY_MAP' table as user THIS_IS_ME I have
then attempted...
trub3101
|
05-29-2007 04:50 AM
trub3101 | 1 | 85 |
| | | http://www.msnbc.msn.com/id/18826900/
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget...
DA Morgan
|
05-28-2007 04:00 PM
DA Morgan | 4 | 57 |
| | | Contact : Mandar
Direct : 402 408 6601/402 408 3687
Email : mandar (AT) kraftware (DOT) com
Hi,
We have the following SAP SD and SAP CRM consultant...
mandarkraftware@gmail.com
|
05-27-2007 05:35 AM
Vladimir M. Zakharychev | 2 | 39 |
| | | I have a query which creates a view with a field which is 99.8% unique
(DEBTRANS.VOUCHER)
SELECT TRIM(DEBTRANS.ACCOUNTNUMBER) AS INDBDebnmbr
,...
Nickneem
|
05-25-2007 03:04 PM
fitzjarrell@cox.net | 3 | 46 |
| | | I would like to access/connect from a (CSharp) program to a running Oracle database.
For that I have to specify a connectionstring with a DataSource...
pete sinner
|
05-25-2007 12:47 PM
EscVector | 1 | 41 |
| | | CREATE TRIGGER ......
.....
DECLARE
CURSOR cur IN SELECT column_name FROM user_tab_cols WHERE table_name =
ora_dict_obj_name;
sQuery...
Amit
|
05-25-2007 10:50 AM
sybrandb@hccnet.nl | 2 | 45 |
| | | I have a query which creates a view with a field which is 99.8% unique
(DEBTRANS.VOUCHER)
SELECT TRIM(DEBTRANS.ACCOUNTNUMBER) AS INDBDebnmbr
,...
Nickneem
|
05-25-2007 02:26 AM
Nickneem | 0 | 35 |
| | | I have a query which creates a view with a field which is 99.8% unique
(DEBTRANS.VOUCHER)
SELECT TRIM(DEBTRANS.ACCOUNTNUMBER) AS INDBDebnmbr
,...
Nickneem
|
05-25-2007 02:26 AM
Nickneem | 0 | 29 |
| | | Hi folks!
Usually I use oracle 9i but this time i need to find a simple, freeware tool
which has a possibility to draw ERD diagrams ( I dont care...
Snake Plissken
|
05-25-2007 01:08 AM
Snake Plissken | 4 | 50 |
| | | Hi Everybody,
Is there a better way to implement the "break on" functionality of
sqlplus in sql than what is shown below?
Thanks,
John
select
(case
grasp06110
|
05-24-2007 07:12 PM
DA Morgan | 5 | 37 |
| | | Hello,
I tried to retrieve a timestamp from my database independent from the
local TZ environment variable. The...
Joerg Weule
|
05-24-2007 08:37 AM
Vladimir M. Zakharychev | 2 | 44 |
| | | I need to add an Oracle database to a C program. It's great that Oracle
makes 10g available for free. But I've spent hours looking for
information...
Charles T. Smith
|
05-24-2007 07:09 AM
sybrandb | 1 | 32 |
| | | Hello,
i am using a table with a varchar2 column that is specified NOT NULL
and created a view to that table wich casts this column to...
andized@gmx.net
|
05-24-2007 05:40 AM
andized@gmx.net | 8 | 56 |
| | | i wants to create a function which will return more than one parameter
Example
CREATE OR REPLACE FUNCTION showArticalBrandStyle(ano...
rajeshdhumal@gmail.com
|
05-24-2007 04:19 AM
rajeshdhumal@gmail.com | 8 | 69 |
| | | -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Jim Smith wrote:
Missed that - sorry.
But maybe the 10-20GB is unstructured, and can be stored in a...
cumin
|
05-23-2007 07:04 PM
joel garry | 6 | 84 |
| | | Hello,
Can someone answere my questions about a hypothetical case..
Let say i run a 9.* oracle database on a unix platform about 40 gig big...
Ed Yin
|
05-23-2007 06:52 PM
joel garry | 4 | 36 |
 | | I found this site for using a web service from oracle 9i. I'm trying
it from...
jobs
|
05-23-2007 11:54 AM
jobs | 6 | 150 |
| | | How can I tell what is scheduled in the database?
I did a select * from all_jobs that resulted in nothing.
Using PL/SQL DEVELOPER the...
jobs
|
05-23-2007 09:52 AM
Vladimir M. Zakharychev | 1 | 38 |
| | | I am working on generating report from a database that has been
migrated to Oracle from 4D and they used packed fields in 4D to store
the data...
luke.pickett@gmail.com
|
05-22-2007 12:43 PM
Ed Prochak | 1 | 55 |
| | | Hi Friends,
This is V. Sridhar from UR Tech Solutions and We Urgently require
DBA Professionals for Our Client in ...
UR Tech Solutions
|
05-22-2007 11:10 AM
DA Morgan | 1 | 54 |
| | | I'm currently working on getting a handle on using invalidation
caching and manually invalidating portlets in Oracle Portal 10.1.4. I
found and...
kenneth.franqueiro@gmail.com
|
05-22-2007 08:21 AM
Frank van Bortel | 1 | 51 |
| | | I have connection (from SQL Server SSIS) that launches and monitor
jobs in Oracle (9i and 10g).
I can tell if a job is currently running from...
jobs
|
05-21-2007 01:58 PM
jobs | 2 | 103 |
| | | Hi all,
I'm checking a 9iR2 schema for compatibility with Streams. Streams
requires supplemental logging for any tables that have a foreign key
or...
Tarby777
|
05-21-2007 10:42 AM
DA Morgan | 1 | 46 |
| | | Hi all,
I have the following query.
SELECT MAX(emptype_flg)
FROM employee
AND emptype_flg IN (DECODE ('emptype_flg', '*' , emptype_flg,
'S' ,...
Anto
|
05-21-2007 10:31 AM
Vladimir M. Zakharychev | 1 | 50 |
| | | What's the best way to dump some tables into a file
such that the data is in a series of insert statements?
I would like to set up some regression...
Mark Harrison
|
05-21-2007 10:06 AM
Brian Peasland | 10 | 141 |
| | | Hi,
I am executing a prepared query in C via ODBC.
The query is this:
BEGIN
IF (:I06 = 1) THEN
INSERT INTO myschema.mytable(...
phancey
|
05-21-2007 06:24 AM
phancey | 0 | 48 |
| | | Hi I am trying to replicate OH on Solaris and I followed the doc from
metakink. I did:
cp /u01/app/development_home /u01/app/test_home
# chown -R...
donkarnash@gmail.com
|
05-20-2007 07:38 PM
Karnash | 2 | 279 |
| | | "ricky" <csfricky (AT) netvigator (DOT) com> wrote in news:464fbf6e$1 (AT) 127 (DOT) 0.0.1:
please re-state question in complete English...
Ana C. Dent
|
05-20-2007 12:18 PM
DA Morgan | 1 | 328 |
| | | how to setup partition if I want to install oracle on rhel4
ricky
|
05-19-2007 10:37 PM
Ana C. Dent | 1 | 54 |
| | | Please find below our hotlist.
1. Singh - SAP Security, available now, currently in CA, open to
travel
2. Abdul: SAP Security, Open to travel,...
writetodgn@gmail.com
|
05-18-2007 05:49 PM
DA Morgan | 1 | 62 |
| | | Hey,
in one package without intention i have started an endless loop. And
after I have called this procedure from outside, i can't compile...
funkyfly
|
05-18-2007 05:48 PM
DA Morgan | 1 | 60 |
| | | Hello,
We're converting from Sybase to Oracle and I'm running into problems
converting the triggers. We have a lot of tables that update other
rows...
heidi
|
05-18-2007 04:32 PM
sybrandb@hccnet.nl | 15 | 183 |
| | | Hello,
I'm facing with hanging transaction in my Oracle 10gR2 database.
A Jonas server with hibernate layer connect to the Oracle database.
Driver...
fugamo@gmail.com
|
05-18-2007 10:32 AM
DA Morgan | 2 | 52 |
| | | http://www.google.com/trends?q=oracle&date=all&geo=all&ctab=1&sa=N
http://www.google.com/trends?q=ask+tom&ctab=1&geo=all&date=all
http://www.google....
EscVector
|
05-18-2007 10:08 AM
hasta_l3@hotmail.com | 1 | 50 |
| | | I have a query where I can have a count(*) counting certain values of
progress and outputting like this:
Mike Approved 3
Mike Not Started 5
John...
kasare34@gmail.com
|
05-18-2007 08:17 AM
kasare34@gmail.com | 3 | 51 |
| | | hi all,
Which books are recommended to read for OCA certification?
(Oracle Database 10g: Introduction to SQL and Oracle Database 10g:
Program with...
Alligator
|
05-18-2007 04:14 AM
pankaj_wolfhunter@yahoo.co.in | 1 | 58 |
| | | Please find below our hotlist.
1. Singh - SAP Security, available now, currently in CA, a
2. Abdul: SAP Security, Open to travel, available now,...
writetodgn@gmail.com
|
05-17-2007 08:27 PM
DA Morgan | 3 | 62 |
| | | Hi,
We have a database with over 2000 stored procedures. We're pretty
sure not all of them are used. Short of turning on tracing for a few
weeks,...
amerar@iwc.net
|
05-17-2007 06:31 PM
joel garry | 10 | 111 |
| | | Hello All,
I am looking to a OCI on linux with a MIPS cpu. Is it available?
Jimmy
|
05-17-2007 04:47 PM
HansF | 3 | 96 |
| | | Hi, newbie question here.
I want to know if there is a debugger (besides debug messages) that
can be used to debug Application Express projects. ...
Manny
|
05-17-2007 01:09 PM
Manny | 0 | 104 |
| | | Some Scuba feedback...
"the SCUBA program was a great enlightner for the DBAs. There was good
insight for them to know what could be considered a...
s.....@gmail.com
|
05-17-2007 12:20 PM
Frank van Bortel | 2 | 178 |
| | | You can get information about Malden Gogala from his web-site, but
you may not know that Mladen Gogala is a strong supporter of Sybrand
Bakker....
dbaplusplus@hotmail.com
|
05-17-2007 11:32 AM
Ed Prochak | 25 | 358 |
| | | Greetings.
I need to write a script or program (I prefer a pl/sql script) to upgrade a
database.
The task needs to:
ensure the user has minimum...
Jeff Kish
|
05-17-2007 11:20 AM
Ed Prochak | 9 | 51 |
| | | I'm a bit confused here.
I had a schema grant EXECUTE ANY PROCEDURE to a user.
But that user could not access procedures in a package.. they got an...
Jeff Kish
|
05-17-2007 08:07 AM
Frank van Bortel | 13 | 111 |
| | | FUNCTION CriaTabela RETURN VARCHAR IS
BEGIN
CREATE VIEW T_LOTCDA_TEMP AS SELECT * FROM T_LOTCDA;
RETURN 'NOTHING';
END;
This funct its inside a...
Claudiodom
|
05-17-2007 12:42 AM
William Robertson | 4 | 56 |
| | | Hi to all.
I need help to solve a problem with CMAN
We are able to configure CMAN in this situation (quite...
domcat@gmail.com
|
05-16-2007 12:53 PM
sybrandb@hccnet.nl | 3 | 117 |
| | | Hi,
I was wondering what is the best (giving best performance) way to
connect to an Oracle database?
I have been using oo4o Oracle objects for Ole...
anders43@gmail.com
|
05-16-2007 11:04 AM
Jeff Kish | 6 | 125 |
| | | Hi,
Is there any tool for finding the difference between two oracle
databases.
The main criteria is that the tool should run on UNIX...
kalai
|
05-16-2007 10:27 AM
HansF | 4 | 57 |
