shaik2many

SELECT * FROM table_a WHERE tax_year = 2011 AND 
(
       (id, no, rp, code) IN 
       (('0004','001',1, 'ADBB'), ('0084', '001', 1, 'ADAN'),('0074', '900', 1, 'TPAR'))
       OR bsla_code IN ('C000','CB0')
)

SELECT CURSOR (SELECT * FROM t1 WHERE TYEAR = 2010) AS SHEET1,
      CURSOR (SELECT * FROM t2 WHERE TYEAR = 2010) AS SHEET2,
    CURSOR (SELECT * FROM t3 WHERE TYEAR = 2010) AS SHEET3                                      

shaik2many

CREATE OR REPLACE PACKAGE PKGCOM_SECURITY IS

  -- Author  : 
  -- Created : 2/13/2013 11:45:32 AM
  -- Purpose : 
  
  -- Public function and procedure declarations
  PROCEDURE INSERT_USER_SECURITY(p_ssid IN table_name.ssid%TYPE,
          p_return OUT VARCHAR2);

shaik2many

--http://www.oracle.com/technetwork/issue-archive/2013/13-mar/o23plsql-1906474.html

DECLARE
     l_total       INTEGER := 10000;
     CURSOR employee_cur
     IS
          SELECT employee_id
            FROM plch_employees
        ORDER BY salary ASC;
     employee_rec   employee_cur%ROWTYPE;

shaik2many

CREATE OR REPLACE PROCEDURE mystoredproc
IS
      CURSOR template_cur IS
             SELECT folder_id, (ROWNUM+100000) new_folder_id
             FROM tcom_folder_template
             WHERE folder_template_id = p_template_id
             ORDER BY folder_id;
      template_cur_rec   template_cur%ROWTYPE;
      TYPE folderid_table IS TABLE OF VARCHAR2(100) INDEX BY VARCHAR2(100);
      folderid_map folderid_table;

shaik2many

$tabs = $("#tabs").tabs({
  	selected: 0,
		select: function(event, ui) {
			var size = $(this).tabs('length')
		},
		add: function(event, ui) {
			var content;			
		},
		cache: false,
	  ajaxOptions: {cache: false}

shaik2many

SELECT CURSOR(SELECT * FROM table1) AS sheet1,
       CURSOR(SELECT * FROM table2) AS sheet2
FROM DUAL;

shaik2many

create table <TABLENAME> as select * from <TABLENAME>@<DBLINKNAME> 

shaik2many

Set<String> set = new TreeSet<String>();
set.add("reyaz");
set.add("arshad");
System.out.println(set);

shaik2many

CREATE MATERIALIZED VIEW xxxxx
REFRESH COMPLETE
START WITH TO_DATE('07-FEB-2014 08:00:00','dd-mon-yyyy hh24:mi:ss')
NEXT (SYSDATE +4/24)
AS 
select * from table1

(here 4 is the frequency - every 4 hours)

---- starts at 2am next day and runs everyday at 2am

shaik2many

SELECT 1 FROM dual WHERE exists (
  SELECT * from abc
)