Is there way to count a number of rows in opened cursor before fetching it (%rowcount works only after fetching)? I need to know the number of...

eudorica

12-13-2004 03:26 AM
tojo

Hello, I reinstalled my Forms/Reports Services 10g on my Linux Red Hat Enterprise 3 (ES) box. I can run my WebReports stand alone from the Reports...

Paolo Treves via OracleMonster.com

12-12-2004 05:11 PM
Paolo Treves via OracleMonster.com

Could anyone shead some light on this problem that I'm faced with. I have a stored procedure that has 2 parameters. The first is the primary key ...

Adrian Scott-Day

12-12-2004 02:58 PM
Noons

http://www.developer.com/db/article.php/10920_3308841_3 This is the first chapter of connor mcdonald's book.

Oradba Linux

12-11-2004 10:26 PM
Oradba Linux

Hello, an Oracle-DB with several constraints does complain correctly if a user tries to insert data over the frontends which do not fit to the...

Thomas Blankschein

12-11-2004 09:51 AM
Sybrand Bakker

hi everyone, I'm not sure whether this is the right NG for my questions. If not, please let me know which NG would be the better one. My Q: We have...

dbyy

12-11-2004 06:26 AM
dbyy

Okay first up this is not a NULL vs. Empty String thing as I am well aware of that little gotcha but instead it is when a 'Null' string (a person's...

jbainbridge@gmail.com

12-10-2004 08:02 PM
DA Morgan

It is possible to install and run it BUT Oracle does not certify it... which means no support. They only certify it on NT. Regards /Rauf

Rauf Sarwar

12-10-2004 07:58 PM
DA Morgan

I posted this question on Oracle Metalink back in October, but didn't receive any feedback so I just wanted to present the issue again. (...

KurtisK

12-10-2004 08:03 AM
KurtisK

Hi All, I am hving real trouble with this one. Basically I've been asked to crack down on database security. Everyone knows all the passwords...

amerar@iwc.net

12-10-2004 04:13 AM
Volker Hetzer

Can anybody help me in setting up SQL. I never set a password but it is asking for the same, what do I do ??

Manish

12-09-2004 10:34 PM
HansF

Hi! I have an Oracle 9.2 database set up with UTF-8 and nls_length_semantics=char (W2000 Server). I have data in an access database which I want to...

Hans

12-09-2004 08:22 AM
Hans

I have a field (acct) that I want to create an index on. The index field needs to be reset to 1 everytime the acct changes. I have mainly only...

sbowles@lwcky.com

12-09-2004 02:22 AM
Douglas Hawthorne

Hi, I would like to introduce a new VoIP(Voice Over Internet Protocol) Usergroup to you. The link is:...

erika_angella@yahoo.com

12-09-2004 01:16 AM
erika_angella@yahoo.com

What is the best path for Oracle certification? I am new to Oracle, but not new to I.T. I was looking at the Oracle web site & it appears that the...

Alex Reid

12-08-2004 04:21 PM
Alex Reid

Hi, I have a problem with using an aggregate function from another schema in a sql statement. In the schema 'schema1' I created the object type...

Thomas Blankschein

12-08-2004 12:42 PM
Thomas Blankschein

We are trying to mimic the behavior of Exchange Shared Public Calendars. These calendars are available in the Public Folders folder within the...

Roy Rodriguez

12-08-2004 07:09 AM
mjfrider@yahoo.com

http://tinypic.com/uolrn Image above is the dialog box that is "supposed" to be the FIRST install box. I have gone past this one, ran...

robert

12-08-2004 04:55 AM
Howard J. Rogers

Hi, I am developing an Objective C application (using the GNU runtime on Linux(x86), Solaris and Windows) which connects to an oracle server via...

Tilo Prütz

12-08-2004 03:05 AM
Tilo Prütz

HI All, I am wondering if the ALTER TABLE ddl will impact any triggers, etc... if I am only using it to increase field lengths in a few of my...

nroberts@ci.charlotte.nc.us

12-07-2004 11:44 PM
DA Morgan

Where can I find any sample codes to connect and manage an oracle DB with a VB.NET application? Thanks a lot.

MARA80

12-07-2004 04:55 PM
Chris Leonard

Im looking for some insight into two bugs that I have seen. The error java.lang.ArrayIndexOutOfBoundsException seems to be a but when you try to...

Carlton Gregory

12-07-2004 02:56 PM
ana

I have a sequence which is used to generate receipt numbers with a max_value (the numbers are loaded to a mainframe database) and am am attempting to...

Ubiquitous

12-07-2004 02:31 PM
DA Morgan

I want to find the second highest salary earner in each department in the example below: ID Department Salary 1 101 400 2 101 ...

Ajit

12-07-2004 01:02 PM
GQ

Hi, I try to join 3 tables. Oracle 9.2 does always a cartesian join and I don't know why. here ist my Query: SELECT productpcat.productid FROM pcat...

Christian Habermehl

12-07-2004 12:12 PM
GQ

Does anyone use the google groups web interface to read these messages? I noticed today, Google went to a new format and its worthless. You see the...

qnxodba@gmail.com

12-07-2004 12:05 PM
Ubiquitous

Hi All, I am hving real trouble with this one. Basically I've been asked to crack down on database security. Everyone knows all the passwords...

amerar@iwc.net

12-07-2004 10:32 AM
DA Morgan

Hi All, I am hving real trouble with this one. Basically I've been asked to crack down on database security. Everyone knows all the passwords...

amerar@iwc.net

12-07-2004 09:12 AM
amerar@iwc.net

Hi All, I am hving real trouble with this one. Basically I've been asked to crack down on database security. Everyone knows all the passwords...

amerar@iwc.net

12-07-2004 09:12 AM
amerar@iwc.net

I have downloaded from Metalink and am currently using the open_file_with_app procedure that lets me open any Windows file using the default Windows...

papalphaus@yahoo.com

12-07-2004 09:08 AM
papalphaus@yahoo.com

Hello all, I have a PL/SQL API which I call from a Java J2EE business layer, instead of running any SQL statement (directly or indirectly e.g....

Giovanni Azua

12-07-2004 06:53 AM
Giovanni Azua

Hi All, I already have a web site running with Oracle as a backend (in english)For future growth, I would like to make it localized. Regarding the...

hfung@hotmail.com

12-07-2004 01:51 AM
hfung@hotmail.com

Hi All, I already have a web site running with Oracle as a backend (in english)For future growth, I would like to make it localized. Regarding the...

hfung@hotmail.com

12-07-2004 01:51 AM
hfung@hotmail.com

Hi, Oracle 8.1.7.4 Solaris 8 We have a perl program that calls a Java Stored Procedure, which then calls a PL/SQL procedure to insert data...

Craig & Co.

12-06-2004 08:54 PM
Mark Bole

I had an extension to this question. What if I have to group and then pick the second highest value. In the example below: I want to find the second...

ajitsd@gmail.com

12-06-2004 06:44 PM
ajitsd@gmail.com

HI All, I am wondering if the ALTER TABLE ddl will impact any triggers, etc... if I am only using it to increase field lengths in a few of my...

nroberts@ci.charlotte.nc.us

12-06-2004 12:55 PM
nroberts@ci.charlotte.nc.us

HI All, I am wondering if the ALTER TABLE ddl will impact any triggers, etc... if I am only using it to increase field lengths in a few of my...

nroberts@ci.charlotte.nc.us

12-06-2004 12:54 PM
nroberts@ci.charlotte.nc.us

hi guys, i am having difficuly in getting my head around this any help would be great. I have a ms sql server which i am porting over to oracle....

sodedra@incodewireless.com

12-06-2004 10:05 AM
DA Morgan

As most of you might now, the common way of emulating SQL Servers TOP n is to use ROWNUM SELECT TOP 1 fld1 FROM tbl ORDERBY fld1; becomes SELECT *...

Gosta Hulden

12-06-2004 06:15 AM
d2domer

Hi, do forms 4.5 support FFI ? regards, Martin

Marcin

12-06-2004 03:22 AM
Frank Piron

There is a new development: Fyracle. Fyracle is an enterprise quality RDBMS that accepts Oracle style SQL and implements a large subset of PL/SQL....

Delia

12-05-2004 09:42 PM
DA Morgan

Hi all, we really need your help on this one... We are developping a VB 6.0 app on Win2K SP4 server. The Oracle DB is 9.2.0.5 and we are using the...

Frederic

12-05-2004 03:05 PM
Frederic

Hi all, My Table "buyer_was_in_shop" has only 2 colums: buyer_id (pk), shop_concate (varchar2(400)) select * from buyer_was_in_shop; BUYER_ID...

georg.heiss

12-05-2004 12:55 PM
DA Morgan

Dear all, truncating a table deletes all row in a table, (I don't find this) and will be or not to be the correspondig indexes truncated? Tank to all

Giuseppe R.

12-05-2004 12:45 PM
Michel Cadot

Wondering if there is a website which contains lot of sql puzzles without the answers. Want to have some fun cracking some puzzles. Also if anyone...

Oradba Linux

12-05-2004 07:44 AM
Frank van Bortel

For some reaons, Oracle shuts down my database and I can't start it up again. This usually happens after a fews days, maybe a week after I create...

David Wright

12-04-2004 03:16 AM
s.kapitza

Hi all, Can someone help with this question? In a program, 2 SQL statements are executed in the same transaction. The first is a SELECT statement...

Bill

12-03-2004 10:02 PM
DA Morgan

So... is there an official (or unofficial) Tom Kyte Fan Club? Anyone interested? -- FT

Funky Tuba

12-03-2004 05:13 PM
Joel Garry

HOT 12 MONTH ORACLE eCOMMERCE GATEWAY (EDI) REQ. CLIENT: PITTSBURGH PA>>> 1 YEAR RATE OPEN NEED A Expert Level Consultant with 5++ years...

Jolly Paily

12-03-2004 05:12 PM
Jolly Paily

All, I am trying to solve a production problem. We are connecting to Oracle 8.1.7 using jdbc selecting about 400 rows into a cursor using a...

tone

12-03-2004 03:14 PM
tone