মঙ্গলবার, ২৮ নভেম্বর, ২০১৭

Java Web start

<jnlp spec="1.0+" codebase="http://desktop-hnjk47a:8889/forms/java">
  <information>
    <title>Webstart Test Oracle Forms 10g</title>
    <vendor>develishdevelopment.wordpress.com</vendor>
    <homepage href="null"/>
    <description>Webstart Test Oracle Forms 10g</description>
  </information>
  <security>
    <all-permissions/>
  </security>
  <update check="timeout" policy="always"/>
  <resources>
    <java version="1.6.0"/>
    <jar href="frmall.jar" download="eager" main="true"/>
  </resources>
  <applet-desc name="Webstart Test Oracle Forms 10g" main-class="oracle.forms.engine.Main" width="990" height="660">
    <param name="background" value="no"/>
    <param name="logo" value="no"/>
    <param name="serverApp" value="default"/>
    <param name="lookAndFeel" value="oracle"/>
    <param name="allow_debug" value="true"/>
    <param name="separateFrame" value="false"/>
    <param name="em_mode" value="1"/>
    <param name="latencyCheck" value="true"/>
    <param name="networkRetries" value="240"/>
    <param name="serverArgs" value="module=E:\LIBAS_ERP\LOGIN_MAIN.fmx useSDI=yes"/>
    <param name="serverURL" value="http://desktop-hnjk47a:8889/forms/lservlet?libas=http://desktop-hnjk47a:8889/forms/frmservlet?config=jpi"/>
    <param name="colorScheme" value="teal"/>
    <param name="splashScreen" value="no"/>
    <param name="dontTruncateTabs" value="true"/>
  </applet-desc>
</jnlp>

বুধবার, ২০ সেপ্টেম্বর, ২০১৭

রবিবার, ১৭ সেপ্টেম্বর, ২০১৭

বৃহস্পতিবার, ১৭ আগস্ট, ২০১৭

শুক্রবার, ৬ জানুয়ারী, ২০১৭


Killing Session

select SID,SERIAL#,USER#,USERNAME,OWNERID,SERVER,MACHINE,OSUSER from v$session;
alter system kill session 'sid,serial#';

শুক্রবার, ৩০ ডিসেম্বর, ২০১৬

Find out How Many Rows in Table in a User


DECLARE
val NUMBER;
BEGIN
FOR I IN (SELECT TABLE_NAME FROM USER_TABLES) LOOP
EXECUTE IMMEDIATE 'SELECT count(*) FROM ' || i.table_name INTO val;
DBMS_OUTPUT.PUT_LINE(i.table_name || ' ==> ' || val );
END LOOP;
END;

Drop All Table in a User


BEGIN
FOR c IN (SELECT table_name FROM ALL_tables where owner='TEST_GPG_GL') LOOP
EXECUTE IMMEDIATE ('DROP TABLE "' || c.table_name || '" CASCADE CONSTRAINTS');
END LOOP;
END;


মঙ্গলবার, ২৭ ডিসেম্বর, ২০১৬

Copy Table One Database To Another Datbase

Syntax:


COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)]
USING query

Using Dblink:

create table target_table_name as select * from source_table_name@dblink 


Using Copy:

copy from hr/hr@ala to gbdml/gbdml@gbdml create employees_copy using select * from employees ;

Be carefull- SQLPlus COPY supports only the following datatypes:

    CHAR
    DATE
    LONG
    NUMBER
    VARCHAR2