This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| s.replaceAll("\\t", " "); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $("#projects").multiselect("getChecked") |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var open = $('#open').is(':checked') | |
| var close = $('#close').is(':checked') |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT 1 FROM dual WHERE exists ( | |
| SELECT * from abc | |
| ) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Set<String> set = new TreeSet<String>(); | |
| set.add("reyaz"); | |
| set.add("arshad"); | |
| System.out.println(set); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create table <TABLENAME> as select * from <TABLENAME>@<DBLINKNAME> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT CURSOR(SELECT * FROM table1) AS sheet1, | |
| CURSOR(SELECT * FROM table2) AS sheet2 | |
| FROM DUAL; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $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} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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; |