Search results for query: *

Hi, All the points jack000 mentioned are fine i don't agree with the point he has made SAP does not come with ORACLE. It can be implemented with ORACLE as Backend, and is being used with ORACLE worldwide. Just to correct!!!

To overcome this problem you will have to use packagae. Store the value of these new values in the package variable and then use it to determine the value in the sixth column. Try this.

Hi guys, Got a problem with mail handling in ORACLE. I have to save the mail attachements coming on my mail server to my database server. We are using Novel Netware mail server and ORACLE 8i on windows NT. These attachements from selceted mails are to be detached, saved and processed by...

I am facing a problem with forms 6i at the time of invoking reports from inside forms. There is a function, called FIND_REPORT_OBJECT(<rep_name>) function which returns an ID of type REPORT_OBJECT Thus function returns an error frm-41219 Cannot find report, invalid id...

If there is index on the col1 then col1 = col1 this condition should use the same index like when you use col1=some_value. Regarding Karluk's limitations i didn't get the time to work on that so far i have been using this for the columns in which i never have null values. so this possiblity...

My solution is not going to match if you have not set matrix.matrix_id in that case this Where Clause is just going to be true for all the rows in the table. May be if i have misunderstood your requirement but this is the best solution when you want to write a query where in if you are passing a...

I am having a problem regarding order by in forms. i am selecting person_id from a table and in post_query trigger am selecting the Person_name from some other table. i want the records to be sorted by person_name. how is this possible? Am on ORACLE 7.3 and i thought of creating a view as base...

Try like this for those columns which you think can be null and you want to select all for them matrix.matrix_id = nvl(Selected_Matrix,matrix.matrix_id) this will take into this only when Selected_Matrix is not null othrwise the condition will be true always.

Can anyone please tell in details what exactly is the difference in the way we access the database in ORACLE8i. I mean what do we mean by the term named servers. Now even if the entry for the instance is not there in the tnsnames.ora we can logon to database using the fully qualified name. Can...

Sorry this menat to be a new thread came in this.

Can anyone please tell in details what exactly is the difference in the way we access the database in ORACLE8i. I mean what do we mean terms named servers. Now even if the entry for the instance is not there in the tnsnames.ora we can logon to database using the fully qualified name. Can anyone...

Write a before record trigger if the columns is null stop the navigation.

You can insert the symbol as image in Db and then use it. But if you need it for some Report or Form try to paste at as image there.

Depends on the Requirements. Some times non base table blocks are used to for data entry and validations and then data is inserted by insert scripts insetad. In base table blocks no need to write insert scripts it'll automatically do inserts and upddates.