Mostafiz MITUL B N School '98

MAKING HUNDRED FRIENDS A YEAR IS NOT A MIRACLE, THE MIRACLE IS TO HAVE A FRIEND STANDS BY YOU FOR HUNDREDS OF YEARS.....

Site Address:

Downloads and Details :

Automatic SYNC in 10g....... :

rem -----------------------------------------------------------------------
rem Filename:   Automatic SYNC in 10g ...... :
rem Purpose:    Automatic SYNC in 10g....... :
rem Date:       11-aug-2010
rem Author:     Mostafiz mitul, Oracle SQL
rem -----------------------------------------------------------------------
For CONTEXT indexes, when the CTXSRV process was desupported back in 
8.1.6, we were all supposed to use CTX_DDL.SYNC_INDEX. This is still the 
case, but at least now, you can bundle it all up in a single DDL

create index TEXT_IDX on T( TEXT_COL )
indextype is ctxsys.context
parameters ('sync (every "SYSDATE+10/1440")');


which creates DBMS_SCHEDULER job for you, in this ase, running every 10 
minutes. Another alternative is the "sync-on-commit" which ensures your 
text indexes stay right up to date (at the cost of index fragmentation 
and of course, commit performance)

create index TEXT_IDX on T( TEXT_COL )
indextype is ctxsys.context
parameters ('sync (on commit)');

download..........
>>> EXECUTE & Enjoy 
...Mostafiz mitul

SYS_REFCURSOR in 10g ...... :

rem -----------------------------------------------------------------------
rem Filename:   SYS_REFCURSOR in 10g ...... :
rem Purpose:    SYS_REFCURSOR in 10g....... :
rem Date:       24-mar-2011
rem Author:     Mostafiz mitul, Oracle SQL
rem -----------------------------------------------------------------------
sys_refcursor

sys_refcursor can be used to pass cursors from and to a stored precedure.
The following procedure proc_ref_cursor accepts a sys_refcursor and loops 
on that cursor and prints out

create or replace procedure 
  proc_ref_cursor (rc in sys_refcursor) as
  v_a number;
  v_b varchar2(10);
begin
  loop
    fetch rc into v_a, v_b;
    exit when rc%notfound;
    dbms_output.put_line(v_a || ' ' || v_b);
  end loop;
end;
/

Here's a table that we will use to select from:

create table table_ref_cursor (
  a number,
  b varchar2(10)
);
insert into table_ref_cursor values(1, 'one');
insert into table_ref_cursor values(2, 'two');
insert into table_ref_cursor values(3, 'three');
insert into table_ref_cursor values(4, 'four');
commit;

Here's another stored procedure (call_proc_ref_cursor) 
that opens a cursor (select * from table_ref_cursor) and passes 
that cursor to proc_ref_cursor.

create or replace procedure 
  call_proc_ref_cursor as
  v_rc sys_refcursor;
begin
  open v_rc for 
    select * from table_ref_cursor;
  proc_ref_cursor(v_rc);
  close v_rc;
end;
/
with thanks. . .
http://www.adp-gmbh.ch/ora/sql/sys_refcursor.html

download..........
>>> EXECUTE & Enjoy 
...Mostafiz mitul

constraints of table ... cons file :

rem -----------------------------------------------------------------------
rem Filename:   constraints of table ... cons file ...... :
rem Purpose:    constraints of table ... cons file....... :
rem Date:       11-apr-2013
rem Author:     Mostafiz mitul, Oracle SQL
rem -----------------------------------------------------------------------
cons_file

----------constraints of table
set line 100
col CONSTRAINT_NAME for a20
col REFERENCES_TABLE for a20
col COLUMN_NAME for a20
col SEARCH_CONDITION for a20

select UCC.CONSTRAINT_NAME, UCC.COLUMN_NAME, UCC.POSITION
,UC.CONSTRAINT_TYPE, UC.SEARCH_CONDITION, UC2.TABLE_NAME as 
REFERENCES_TABLE from USER_CONS_COLUMNS UCC, USER_CONSTRAINTS UC, 
USER_CONSTRAINTS UC2 where UCC.CONSTRAINT_NAME = UC.CONSTRAINT_NAME
and UC.R_CONSTRAINT_NAME = UC2.CONSTRAINT_NAME(+)
and UCC.TABLE_NAME = upper('&t_nm')
order by UCC.CONSTRAINT_NAME, UCC.POSITION
/

with thanks. . .

download..........
>>> EXECUTE & Enjoy 
...Mostafiz mitul

html to rich text editor jar file and others :

rem -----------------------------------------------------------------------
rem Filename:   html to rich text editor :
rem Purpose:    html to rich text editor :
rem Date:       04-jun-2013
rem Mostafiz mitul, Oracle SQL
rem -----------------------------------------------------------------------
html to rich text editor :

----------html to rich text editor :
html to rich text editor html to rich text editor html to rich text 
editor html to rich text editor html to rich text editor html to rich 
text editor html to rich text editor html to rich text editor 
with thanks. . .

download..........
>>> EXECUTE & Enjoy 
...Mostafiz mitul

Auto Complete or dynamic Lov and so on :

rem -----------------------------------------------------------------------
rem Filename:   Auto Complete or dynamic Lov and so on :
rem Purpose:    Auto Complete or dynamic Lov and so on :
rem Date:       04-jun-2013
rem Mostafiz mitul, Oracle SQL
rem -----------------------------------------------------------------------
Auto Complete or dynamic Lov and so on :

----------Auto Complete or dynamic Lov and so on :
here the zip file contains fmb file of 6i and dmp with one table ac5_ch 
used in fmb file. fmb file is the example of Auto Complete or dynamic 
Lov like a google search hint

with thanks. . .

download..........
>>> EXECUTE & Enjoy 
...Mostafiz mitul

Mitul Search
Powered by Yahoo……

Mitul Search
Powered by Google……

Mitul Search
Powered by MSN……