Hi,
im a newbie in oracle applications. i understood that srw.user_exit is used for multi-org co, so the report will fetch records from the organization. am i right? but, how will i know what organization does this call? or pass through my report. how will i pass this to get the description of...
Hi,
i installed personal 8i and forms/reports 6i on my pc... the problem is, when i try to connect to d database through forms/reports... an error occurred : TNS:could not resolve service name.. but when i tested the user using easy config, connection is successful,
what should i do?
hi,,
i tried created a database link and it was successfully created.. but when i was trying to access the link.. ora-02085 appears.. what should i do?
tnx for ur help..
hi everybody,
just wanna ask, how can i convert tables from ms access to oracle...
how do we carry the data structure of the tables going to oracle..
thanks..
hi,
it should be:
select a.wonum
from workorder a
where a.ACTLABCOST IN (select sum(labtrans.linecost)
from labtrans
group by labtrans.wonum
where labtrans.wonum = a.wonum)
hi,
"select ROW_COUNT from DLETBLID where TABLE_NAME = sTable;"
should be:
select ROW_COUNT into <VARIABLE> from DLETBLID where TABLE_NAME = sTable;
regards
thanks mr. martin,
ur right this is what i needed.... actually it will be used in forms... so the user does not need to use pl/sql..
can u give me an example of importing text delimited file using text_io??
thanks again and regards...
hello,
you can try:
update <table_name>
set <column_name> = replace(<column_name>, "test", "<ip address>"
...
hope this helps...
regards
hi,
i want to import/export data into/from oracle database. how will i do this using i think text.io or text_io...
please give me sample code...
thanks....
try this...
/*select statement using index idx1_contract_search*/
SELECT DISTINCT t1.seq_prov_id,t2.line_of_business,
to_number(t3.contract_search_type),t2.panel_id,
t2.ipa_id,t2.pcp_flag
FROM master t1,contract t2,contract_search t3
did i get ur question right...?
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.