Study Note

D:\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN>orapwdUsage: orapwd file= entries= force= ignorecase= nosysdba= where file - name of password file (required), password - password for SYS will be prompted if not specified at command line, entries - maximum number of distinct DBA (optional), force - whether to overwrite existing file (optional), ignorecase - passwords are case-insensiti..

WITH t AS ( SELECT XMLTYPE(' Type1 REQ1 Type2 REQ3 Type3 REQ4 ') v FROM dual ) SELECT ExtractValue(Value(p), '/META/META-VALUE') "META-VALUE" FROM t , TABLE(XMLSequence(Extract(v, '/ROOT/META[@use="report"]'))) p WHERE ExtractValue(Value(p), '/META/META-NAME') = 'Type1' ;

tns adapter protocol errorORA-12514: TNS:리스너가 현재 접속 기술자에 요청된 서비스를 알지 못함 해결책1. ORACLE_BASE 설정 D:\app\Administrator2. SERVICE 에서 오라클 관련 SERVICE가 내려가있는지 확인하기3.(SID_DESC=(ORACLE_HOME=D:\\app.....)(SID_NAME=orcl)) 부분을 추가함

select max(test_result_sn) from tn_test_rcept_iem where test_result_sn in (select test_result_sn from tn_test_result) group by rcept_sn having count(rcept_sn) > 1 SELECT EXTRACTVALUE(COLUMN_VALUE, 'testitem/testprsecitem/text()') as aaa FROM TABLE(SELECT XMLSEQUENCE(XMLTYPE(C.CERT_CN).EXTRACT('/cert/testitems/testitemlist/testitem')) FROM TN_TEST_CERT C WHERE TEST_RESULT_SN = 1851)