I have the parent query with a column name 'RCPTMODE'. Based on the value derived from that I have to make child query from different tables with same data structures. How to do that ?
Example : if RCPTMODE value is "CASH" then I have to query from table A and if RCPTMODE value is "CHEQUE" then...
Pl. help me to resolve this problem :-
In a stored procedure I want to pass a parameter which will substitute the column_name of a particular table for query purpose, say as for example
SELECT EMPNAME FROM paymain A
WHERE A.v_colname = '08262755' -- here v_colname is the
parameter which I...
Can anybody help me with the code syntax with which I can call Sql loader in a procedure with the control file name for that loader is thrown in as a parameter to that procedure . Say for example the control file name is 'AFRES.CTL'.
I have a Celeron 1.1Ghz PC running in win98. I want to install Oracle8(Personal) and D2K in my machine. i am facing the following problems at the time of installation :
Problem - 1 : My Oracle & D2k installer are not of same version. So when I am trying to load D2k after first...
I am using ibm-aix ver 4.0.3. Off late i cannot get through my terminal desktop as during booting the following errors are shown.
1> ACTION ''Dtterm" was not found.
2> ACTION "StartDtscreenSwarm" was not found.
3> ACTION...
I am using AIX ver 4.3 in IBM RS-6000. I have partioned the disk in 4 compartments and in one of the compartments Oracle is loaded alongwith a database created for a project purpose. Now due to some gross error in judgement that compartment is full and oracle has stopped loading.
My question is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.