New answers tagged

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