What do you think about Windows 7? Write a review or a how-to about Microsoft's newest product and earn unlimited points!

 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Top Oracle 9.x Solutions: 1 - 25 of 78
 
Hello Guys!! I have a form in which you can select regions/divisions/locations etc by the use of check boxes. And the selected values will be inserted into a table, and based on the selecte...
hi how to create database link in oracle using static ip ap
I have a query that is taking much longer than I expect.  I am looking at my WHERE clause and I have a line in the WHERE clauses like:      AND to_char(T.EVENTDATE, 'YYYY-MM-DD') between '200...
I have a table with months as the column headers, (not a smart idea but i can't do anything at this point) and data under each column corresponding to the month. I want to convert the columns...
Is there any way to give truncate pvlgs only on one table in oracle
Hello Guys!! I have an issue as shown in the figure below. I am actually populating a record group in the WHEN-NEW-FORM-INSTANCE trigger, as I did earlier for other record groups. I simpl...
I created an xml file using a utl_file.put_line procedure in oracle.  Unfortunately, at the end of each chunk I now have a carriage return which is messing up my xml file.  Some of the tag nam...
Guidance please.  I am receiving an ORA-03113: end-of-file on communication channel when I run the first query listed below.  When I change the reference to 'SYSDATE' in the WHERE clause to a ...
What are the ramifications of using a global temp table in a Dataguard environment?
I've installed Oracle 10g client software, and I trying to connect to an Oracle 9i remote database running on a virtual server in a different domain. I've had Oracle 7.x client installed on ma...
Hi, I'm using an Oracle 9i DB on a Windows 2K3 Server and have the 9i Client installed on XP Clients. When I go into the Windows registry on the clients I've got one code page NLS_LANG = AMER...
Hi All, I have a three table like below. In the below table SAMPLE_CONS_CHECK and SAMPLE_CONS2_CHECK will be having the primary key for NAME column. The same SAMPLE_CONS3_CHECK table also h...
Hi, I have 3 different tables for eg: Tables -  cloumns: T1 ---> Nbr, x1, x2, x3 T2 ---> Nbr, y1, y2,y3 T3 ---> Nbr, z1, z2, z3 Nbr column is the Common column in all the 3 tables. I w...
I want to have an optional parameter in a store procedure. How do I do that? The code below does not work.
I need to locate all object,procedures, forms and reports where a specific table is used in an Oracle database.  The purpose is to ensure that if we change the table name, that all references ...
Hello experts i am accessing oracle table information and feeding into my local sql server db. So in order to do that i have a SP written in sql server. Now my question is how to exactly writ...
I need an example of how to create a poplist based on a DB query. Say for example I have a states table.  The two columns in the states table are state_code and state_name. I want the us...
When I run this example in SQL Tools I get back what I expect. DECLARE  stime TIMESTAMP(9);  etime TIMESTAMP(9); BEGIN   stime := SYSTIMESTAMP;   dbms_lock.sleep(1);   etime := SYSTIMES...
I woukd like the user to be promted to  enter a name of an employee, and the name will display all those who are mangers or superior the name enter, or if the name is not found I would like to...
I'm receiving the following error message when I try to access a TYPE using a program unit in Forms Builder 9i. Error 999 at line 3, column 9 - implemenation restriction (maybe temporary) A...
I'm attempting to install Oracle 9 on a Windows Server 2003R2 , Standard X64 Edition Server. The installation fails at the point of Creating and Starting Oracle Instance. I get the error "OR...
Hi all, for some of our users, it is not possible to resolve their terminal via SYS_CONTEXT('USERNENV', 'TERMINAL'), the return is NULL. In contrast the SYS_CONTEXT('USERNENV', 'HOST') is a...
when we delete a statement from the applcation during peak hours, it hangs.  When i checked the same in oracle, it is having an exclusive lock on the table.  I think it is holding this lock ti...
I have attached a version I have been working with, with 4 claims hardcoded in. All works fine, and the claims return what they should: Id#            Recs# ----------------------- 0133883 ...