New answers tagged oracle-11g-r2
0
The error "2" identified in your start service request screenshot indicates "File Not Found". Perhaps you need to "repair" the installation.
0
So I changed my query to this and it gives me the result I want :
select t1.lc_num,
t2.brn_name "Advising Bank",
t3.brn_name "Issuing bank"
from TABLE_LC t1
left join BRN t2
on t1.brn_code = t2.brn_code
and t1.brn_role = 1010
left join BRN t3
on t1.brn_code = t3.brn_code
and t1.brn_role = 2020
Actually ...
1
Better? It depends.
If the primary key of TABLE_LC is (lc_num, brn_role) then you could do something like this:
SELECT
lc_Num
,MAX
(
CASE
WHEN brn_role = 1010 THEN brn_name
ELSE NULL
END
) AS Advising_Bank
,MAX
(
CASE
WHEN brn_role = 2020 THEN brn_name
ELSE NULL
END
) AS ...
2
You can't get the original source back. DBA_SOURCE, ALL_SOURCE, and USER_SOURCE are data dictionary views. So you can do something like
select line, text
from user_source
where name = 'GET_OS_USER'
and type = 'FUNCTION';
That will show you the wrapped text of the function. But the point of wrapping your source code is to prevent users that have ...
1
There is nothing wrong with not having the thread parameter explicitly set in a single instance environment.
SQL> show parameter thread
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
ofs_threads integer 4
parallel_threads_per_cpu ...
Top 50 recent answers are included
