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 ...
I have the following table.
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 ...
