ora-20000 oru-10027 buffer overflow limit of 2000 bytes

DBMS_OUTPUT.ENABLE(1000000);

set serveroutput on size 1000000;

sql query to kill session in oracle

ALTER SYSTEM KILL SESSION 'SID,SERIAL#,@INST_ID';
ALTER SYSTEM KILL SESSION '2328,33131,@1';

Query to find lock objects in pl sql

SELECT
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine,
inst_id
FROM
v$locked_object a,
v$session b,
gv$session gv,
dba_objects c
WHERE
b.sid = a.session_id
AND b.sid = gv.sid
AND b.serial# = gv.serial#
AND a.object_id = c.object_id;

How can I add comments in MySQL?

Single line comment by using -- 

SELECT * FROM pm_msg_queue_txn
where 1=1
-- and api_id ='PAYMENT-BOOKINGS'
and source_id ='1035868'
order by creation_date desc;

Single line comment by using #
SELECT * FROM pm_msg_queue_txn
where 1=1
#and api_id ='PAYMENT-BOOKINGS'
and source_id ='1035868'
order by creation_date desc;

Multi line comment by using /*........*/

SELECT * FROM pm_msg_queue_txn
where 1=1
/*and api_id ='PAYMENT-BOOKINGS'
and source_id ='1035868'*/
order by creation_date desc;

Oracle Webadi Tables?

BNE_INTEGRATORS_B à Integrator
BNE_LAYOUTS_B à Layout
BNE_LAYOUT_COLS à Layout Columns
BNE_MAPPINGS_B à Mapping
BNE_CONTENTS_B à Content
BNE_INTERFACES_B à Interface

FNDLOAD Script for Webadi

Integrator
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XXXX_AP_INV_INT_XINTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN=SQLAP INTEGRATOR_CODE=XXXX_AP_INV_INT_XINTG 

FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XXXX_AP_INV_INT_XINTG.ldt 

Layout
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnelay.lct XXXX_AR_INV_INT_LAYOUT.ldt BNE_LAYOUTS LAYOUT_ASN=SQLAP LAYOUT_CODE=XXXXAPINVINTERFACEINTEGRATOR 

FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bnelay.lct XXXX_AP_INV_INT_LAYOUT.ldt 

Mapping
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/admin/import/bnemap.lct XXXX_APINV_IFACE_MAP.ldt BNE_MAPPINGS MAPPING_ASN="SQLAP" MAPPING_CODE="XXXX_APINV_IFACE_MAP"

FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bnemap.lct XXXX_APINV_IFACE_MAP.ldt 

Content
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecont.lct XXXX_AP_INV_INT_CNT2.ldt BNE_CONTENTS CONTENT_ASN=SQLAP CONTENT_CODE=XXXX_AP_INV_INT_CNT2 

FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bnecont.lct XXXX_AP_INV_INT_CNT2.ldt 

Standard Concurrent program to import Service Contracts from Order Management?

Run “Service Contracts Order Processing” Program to import the service contract from order management.