Skip to content

Instantly share code, notes, and snippets.

$("#projects").multiselect("getChecked")
var open = $('#open').is(':checked')
var close = $('#close').is(':checked')
SELECT 1 FROM dual WHERE exists (
SELECT * from abc
)
@shaik2many
shaik2many / oracle-mv.sql
Last active August 29, 2015 13:56
Materialized view
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
shaik2many / java-set-order.java
Created December 25, 2013 21:24
java set order
Set<String> set = new TreeSet<String>();
set.add("reyaz");
set.add("arshad");
System.out.println(set);
create table <TABLENAME> as select * from <TABLENAME>@<DBLINKNAME>
@shaik2many
shaik2many / oracle-cursorAsRS.sql
Last active December 24, 2015 07:59
oracle cursor
SELECT CURSOR(SELECT * FROM table1) AS sheet1,
CURSOR(SELECT * FROM table2) AS sheet2
FROM DUAL;
$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}
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;