anujparashar.com
Anuj Parashar - Blog********************************************************************* WITH temp AS (SELECT ' ' delimiter, 'A + B - C' expr FROM DUAL), temp_extended AS (SELECT a.*, ...
http://www.anujparashar.com/
********************************************************************* WITH temp AS (SELECT ' ' delimiter, 'A + B - C' expr FROM DUAL), temp_extended AS (SELECT a.*, ...
http://www.anujparashar.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
0.6 seconds
Anuj Parashar
S-236, ●●●●●●●k Nagar
B.H●●●.L.
Har●●●war , Uttarakhand, 249403
India
View this contact
Anuj Parashar
S-236, ●●●●●●●k Nagar
B.H●●●.L.
Har●●●war , Uttarakhand, 249403
India
View this contact
Anuj Parashar
S-236, ●●●●●●●k Nagar
B.H●●●.L.
Har●●●war , Uttarakhand, 249403
India
View this contact
13
YEARS
10
MONTHS
14
DAYS
GODADDY.COM, LLC
WHOIS : whois.godaddy.com
REFERRED : http://registrar.godaddy.com
PAGES IN
THIS WEBSITE
18
SSL
EXTERNAL LINKS
0
SITE IP
199.34.228.100
LOAD TIME
0.567 sec
SCORE
6.2
Anuj Parashar - Blog | anujparashar.com Reviews
https://anujparashar.com
********************************************************************* WITH temp AS (SELECT ' ' delimiter, 'A + B - C' expr FROM DUAL), temp_extended AS (SELECT a.*, ...
User Defined Grouping in Oracle - Anuj Parashar
http://www.anujparashar.com/blog/user-defined-grouping-in-oracle
User Defined Grouping in Oracle. This blog discusses three ways of creating a user defined grouping in Oracle. The input is a bank account or credit card number taken as string (. 00000020000655202, in this example). The number of consecutive digits have to be counted (0 to start with, which occurs 6 times), until the digit changes (2 at the seventh position). In that case, it would be treated as a separate group (2 occurred once) and so on. The desired output is:. CONNECT BY LEVEL = LENGTH (val) ,.
Checking String Uniqueness in Oracle - Anuj Parashar
http://www.anujparashar.com/blog/checking-string-uniqueness-in-oracle
Checking String Uniqueness in Oracle. Oracle provides a lot of in-build functions for string manipulations. Today, I was trying to solve a puzzle with my colleague. As part of that, I was required to check weather a string is character wise unique. Or not. For Ex: "abcda" is not unique, "afd7127" is not unique, "gfsrt321" is. I tried finding an Oracle in-build function for that and there was none. So, I wrote a small reusable function to check it. Here it is:. X CHAR := SUBSTR (p str, 1, 1);. L test t va...
Filling And Querying Database Collections - Anuj Parashar
http://www.anujparashar.com/blog/filling-and-querying-database-collections
Filling And Querying Database Collections. A self explanatory example of how to use database level collections for selecting and iterating over data. Two approaches are mentioned:. Approach 1" is the traditional way of going through the collection using "COUNT" method. Approach 2" is selecting the collection data in SQL using "TABLE" clause. In some cases, this approach can be used as a replacement of global temporary tables (GTT). CREATE OR REPLACE TYPE typ obj AS OBJECT. Obj nt col nt;.
Loading Text file into CLOB field in Oracle - Anuj Parashar
http://www.anujparashar.com/blog/loading-text-file-into-clob-field-in-oracle
Loading Text file into CLOB field in Oracle. This is to demonstrate how a text file can be loaded into a CLOB field in Oracle. This is quite frequently used with External tables in Oracle where you want to upload the bad/log file into database so that it can be reviewed by users without accessing the file on database accessible file system. CREATE TABLE tbl clob (clob col CLOB);. V bfile BFILE;. V clob CLOB;. V bfile := BFILENAME (p file directory, p file name);. DBMS LOB.OPEN (v bfile);. VALUES (v clob);.
Blog Archives - Anuj Parashar
http://www.anujparashar.com/blog/archives/12-2012
Regular Expressions (always in progress). To find the number of occurance of a string in other:. SELECT REGEXP COUNT('abcdcaabcabcdcabcdcbcacb', 'abc') count1, - Starting from 1st character. REGEXP COUNT('abcdcaabcabcdcabcdcbcacb', 'abc', 5) count5 - Starting from 5th character. To do a case insensitive/sensitive search. WITH tbl a AS (SELECT 'A White Cat' val FROM dual UNION. SELECT 'The WHITE Cat' FROM dual UNION. SELECT 'The WhITe Cat' FROM dual). WHERE REGEXP LIKE (val, 'white','i');. GROUP BY owner;.
TOTAL PAGES IN THIS WEBSITE
18
Welcome To Anuj Overseas
Mfrs of Auto parts and Bicycle parts. Established in 1980, to manufacture Bicycle spares to cater the needs of local buyers as well as International buyers with the help of renowned Export houses. We have been manufacturing Bicycle spare parts under the brand name of Anuj. Since inception. It is located in the core of the bicycle industry hub of India. We have unmatched expertise in the design and production of Bicycles and allied products. E-191, Phase IV, Industrial shed, Focal Point, Ludhiana-141010.
10drs : Find your next venture with tenders!
Basics of ASP.NET
Basics of ASP.NET. Wednesday, January 11, 2012. Click on this link given below and read the article for better knowledge! Http:/ msdn.microsoft.com/en-us/library/ms171868.aspx. Links to this post. NET 35 Language Enhancements. This article will demonstrate and discuss several key language features including:. Figure 1 – Many of the New Language Enhancements. Private int customerID;. Private string companyName;. Private Address businessAddress;. Private string phone;. Get { return customerID; }. Customer&...
This Web site coming soon
If you are the owner of this web site you have not uploaded (or incorrectly uploaded) your web site. For information on uploading your web site using FTP client software or web design software, click here for FTP Upload Information.
IIS7
Anuj Parashar - Blog
Tokenizing String in SQL using Model Clause. WITH temp AS (SELECT ' ' delimiter, 'A B - C' expr. Temp extended AS (SELECT a.*,. NVL (LENGTH (expr), 0) - NVL (LENGTH (REPLACE (expr, delimiter, ' ) ,0) no of iterations. DIMENSION BY (1 AS token id). MEASURES (expr, delimiter, no of iterations, CAST (NULL AS VARCHAR2 (100) tokenized values). ITERATE (100) UNTIL (iteration number = no of iterations[1]). Tokenized values [iteration number 1]. WHEN iteration number = 0 THEN. WHEN iteration number = 0 THEN.
ANUJPATEL.NET
Anuj Photography - Home
Anuj Photography Spreading happiness through photography. Greater Seattle Area, Washington. Create a free website. Start your own free website. A surprisingly easy drag and drop site creator. Learn more.
SOCIAL ENGAGEMENT