1. SQL> select * from ref1; (Table-1)
ELEMENT_ID
----------------------------------------
REF1
REF2
2. SQL> select * from ref2; (Table-2)
ELEMENT_ID
---...
I am getting the following error when i load files using intelliq.
I will copy data to data_in . Manully trigger the loading.If it was success ..it should go to data_out fut if it fail it s...
hi,
we have
FORECAST_LICENSE = 200
a."FROM_US_CURRENCY_RATE = 1
c."FROM_US_CURRENCY_RATE" = .7813
what should this retrun please advice and whats the logic behind that return
...
I have to develop an application which will be able to retrieve product information from oracle and sql server. The data will be showed in form or report format where users can drill down to s...
Give the names of stors that currently have less than 3 female employees (don't include store that don't have any employees)
EMP EMP_ EMP_NAME EMP_DOB ST
--- ---- --------------- ...
Hi,
What exacly does it mean by "Database Lookup"?
Thanks,
Adithi
How can I determine if OCI (Oracle Call Interface) has been installed on my Oracle 10g database (residing on an AIX server)?
Thanks.
How can I insert SYSDATE into a table using Execute Immediate statement.Is there a example I can use.
Thanks
Hi,
I want lowest salary of employee.
The code is not function properly.
I don't know what's wrong?
SELECT ename EMPLOYEE, ename MANAGER, mgr, job, MIN(sal)
FROM emp
(SELECT...
Can any one explain me what 'Tera Data' is?
I have 2 tables with emplid -column as primary key in table1. I just inserted some values in table 2 for all the employees but they are not showing in the application but are showing in the ta...
Hello,
Oracle 9i on WIndows 2000 and jsp application for user interface. On jsp I would like to make link for generating report from Oracle database. Report should be done into MS Word's temp...
Hi Guys,
I've just installed Oracle 11.1 on Solaris 10 (SPARC).
I'm able to log in as SYSDBA.
I've also created a user "orausr"
I'm able to log into the DB with orausr (from the cmd line),...
I am using Embarcadero Rapid SQL 7.5.5 to connect to sybase 12.0 database and i can see all the tables there.How to export those tables into .csv file.Can you please tell me the step by step p...
I have a table with column NEXT_WORKING_DAY
Select NEXT_WORKING_DAY FROM Temp
11/19/2008
I need to update this value every day after finishes load with value based on the Holiday cal...
I have a sql and i need to modify it get only certain columns .
The code is below .
Currently the sql get the effective_date,org_sid,transaction_sid, date_created , transaction_name, doc_pro...
how to generate an awr report.
I need steps if possible
Oracle 10
OS Unix
thanks
How to upgrade from 10.2.0.2 to 10.2.0.4.?
How to apply patche?
How to have access to read the $ORACLE_HOME/dbs
I mean the commands to open $ORACLE_HOME/dbs in unix
Hi guys.
Some of you might know me by now. I'm the one who's always having problems with configuration.
Ok, so I set up my first instance, and everything is working great, however, when I tr...
I have granted the user PI_XML_TEST execute rights on PI_USER.GET_STUDY_XML. This means to execute the function, PI_XML_TEST has to call PI_USER.GET_STUDY_XML. Is there a way to alias "PI_USER...
Could anyone give me a explain? Thanks a lot!!
address_dm
customer_number_dm address_dm
123 143 civil lines
123 143 civil lines unit 403
134 123 rodeo road
customer_dm
custo...
The following PL/SQL is not working .Pl give me yr inputs to rectify this ..
How to set streams in dataguards
Any input be appreciated
