Hi,
I have given 2 weeks to solve JRE installation problem with Oracle 9i on Windows XP Prof Sp2.

1- Create a folder in and assign this name C:\Ora9i and create Disk1, Disk2, Disk3 folders into...

Hi guys,
I use 10g with my desktop computer which is powerful enough! However, my laptop only supports 9i. That is why I have to use 9i.
It asks me where JRE is and I show it where JRE is! Didn’t...

Hi,
I am trying to install Oracle 9i but when it comes to Java Runtime Environment, it asks me path for it. I have JRE installed in my Computer. What else do i need to proceed this installation?...

This what i do; Can anyone tell me whay i receice an error.

1- Run "SQL Command Line".
2- connect / as sysdba. "No error".
3- @?/rdbms/admin/utlmail.sql. "Created and no error".
4-...

Before OPEN cursor_1;, i did EXIT from "cursor_2". It was my mistake.

Hi guys,

Both cursor works if i don't use them in one Stored procedure. Both cursors return TRUE for(cursor_x%found). But, insert into process doen't work in cursor_1. Is there any structure...

I just changed the logic of my project. Therefore, i don't use it.

I don't insert date with SYSDATE anymore. I use VARCHAR for it and get date manual.

Hi,

What do i need to do to send SMS message or Email via Oracle 10g database? How do we do that?

Thanks

Hi,
I can't find the missing thing in this code. "05-MAY-08" is in the table but, ( CURSOR_TARIH%FOUND ) never returns TRUE. When i do manuel query it is ok.
Thanks


create or replace...

USE trunc(sysdate) INSTEAD

Hi,

I can not use below code in stored proc in oracle;


IF (SYSDATE = '04-MAY-08') THEN
...
END IF;

Hi,
Where is the mistake? It doesn't work. thanks


CREATE OR REPLACE TRIGGER A_ACCOUNT_EKLEME
BEFORE INSERT ON A_SIPARIS

CURSOR CURSOR_TARIH IS
SELECT TARIH FROM A_ACCOUNT where TARIH =...

i know i can use insert into in the trigers but, can i use update or delete table set...where id=1 in any trigger?

How i send data from php to stored procedure and process it? I can't find it. I am new in oracle as well. I need a very simple example to give me an idea.

Let me add; above process will be done after an insert into in "ORDER" table.

Shortly; Insert data into "ORDER" table and then things get updated in "PRODUCT" table as i required in first message....

Hi,

I need a trigger;
- to find number 1 from "ID" column and
- update "AVAILABILITY" column from Yes to No
in "PRODUCT" table.

Thanks

Also, these are connecstion strings for you.
http://www.sqlstrings.com/

For Oracle 10g Express Edition;
http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html
Download "Oracle Database 10g Express Edition (Universal) or (Western...

Hi,

1- When i insert more than 30 datas (at once) into a table, does sequence cache size(20) effect anything because, i use sequence for auto increment in the table.
2-What happens if i increase...

i have just deleted all sequences and inserted one data into a table. Then sequence's last number become 21 instead of 1.
???

Hi,
When i insert data into any table last number of sequnce get increased in all sequences that are listed below. These are for auto incremented numbers. All tables have their own autoincremented...

It works now. Thank you very much for help, jwenting.

Why PL/SQL Developer is better? I am asking this because, i have a school project and i have to create PL/SQL cursors, PL/SQL stored procedures, PL/SQL functions and PL/SQL triggers. As am a new...

I am a new Oracle user. i use Sql Developer and it seems very helpfull to me.

I am new with this oracle.
What do i have to do?

Hi,
Below trigger increments double(2,4,6,8...) not single. I want single. Where is mistake? If you can not help, is there other way to do auto increment?
Thanks



CREATE TABLE MY_TEST
(
...

Thanks gusy. I'll just use SQL Developer.
Thanks for info again

I'll develop more PL/SQL therefore, i need to use J Developer. I have just created my database with SQL Developer but, how do i backup it?

Thanks for info guys.

Hi,

I have just downloaded 10g express edition but there is no user interface like SQL Server has. Does anyone prefer any program because i am new for Oracle and have never used before.

Thanks