Description:  Actually when we need date time value in specific format like (dd/mm/yyyy) or in other  format,  while we are using datetime as a string variable. In this case it becomes a little bit typical to change string variable value to a specific format. So here we need to change […]

Oracle : ‘(‘||substr(lpad(P.HOME_PHONE,10,’0′),1,3)||’)’||’ ‘|| substr(lpad(P.HOME_PHONE,10,’0′),4,3)||’-‘|| substr(lpad(P.HOME_PHONE,10,’0′),7,4) WHEN NVL(P.IS_DNCL_MOBILE_PHONE,’N’) =’N’ AND P.MOBILE_PHONE IS NOT NULL THEN –P.MOBILE_PHONE ‘(‘||substr(lpad(P.MOBILE_PHONE,10,’0′),1,3)||’)’||’ ‘|| substr(lpad(P.MOBILE_PHONE,10,’0′),4,3)||’-‘|| substr(lpad(P.MOBILE_PHONE,10,’0’),7,4)…. more DESCRIPTION: ORACLE/PLSQL: SUBSTR FUNCTION This Oracle tutorial explains how to use the Oracle/PLSQL SUBSTR function with syntax and examples. The Oracle/PLSQL SUBSTR functions allows you to extract a substring from a string. SYNTAX […]

Converting 10 digit mobile number in to its standard formats ...


I will explain types of SQL JOINs in in this article. JOINs in SQL Server can be classified as follows: • INNER JOIN • LEFT OUTER JOIN • RIGHT OUTER JOIN • FULL OUTER JOIN • CROSS JOIN Each type is explained below with suitable examples: Let’s consider two tables […]

Different types of joins with examples:



The variables in C#, are categorized into the following types: Value types Reference types Pointer types Value Type: Value type variables can be assigned a value directly. They are derived from the class System.ValueType. The value types directly contain data. Some examples are int, char, and float, which stores numbers, […]

Different Data Types of C#


At Google’s I/O developer conference, CEO Sundar Pichai announced a new technology called Google Lens. The idea with the product is to leverage Google’s computer vision and AI technology in order to bring smarts directly to your phone’s camera. As the company explains, the smartphone camera won’t just see what you see, but […]

Google’s upcoming future Google Lens will let smartphone cameras understand ...


The massive ransomware attack by Wanna Cry is getting worst by the hour and has already hit over 160 countries around the world. India is no exception, and Asia is one of the worst hit continents. why ransomware devastation continues because : Not get picked up by antivirus products Not […]

Beware about wanna Cry Ransomware – How to Protect Your ...   Recently updated !



Global internet and technology company LeEco on Friday unveiled a new Super4 Series of TVs – Super4 X40, Super4 X43 Pro and Super4 X50 Pro – for the Indian market. Coming on the heels of the earlier blockbuster X3 Series, the Super4 X “ecotvs” offer 4K Panel with HDR10 and wide […]

Wow..This TV is smarter than your smartphone!


Apple Macintosh computer fanatics can now get their hands on an unofficial iPhone 7 Plus inspired by the vintage Apple computer. The limited edition smartphone is developed by Minnesota-based gadget company . The retro iPhone however comes with a hefty price; it is priced at a whopping $1,899 and will […]

Apple Macintosh computer-inspired iPhone 7 goes on sale


Vivo announced the Vivo Y66 in India priced at Rs 14,990. The new mid-range smartphone is powered by a 64-bit octa-core processor and features 3GB of RMA and 32GB of storage and a 5.5-inch HD LCD display panel. The USP of the device is a 16MP selfie camera, while the […]

Vivo Y66 launched with 16MP selfie camera, 3000mAh battery



BLU mostly rebrands the Chinese smartphones and sells them in the U.S. The company also offers value for money specifications with its unlocked smartphones. The BLU Life One X2 Mini is the latest smartphone from the company. It is the smaller variant to the BLU Life One X2 which was […]

BLU Launches Life One X2 Mini with 5.2" Full HD ...


Apple is pushing the new iOS 10.3 beta 7 to the public beta testers and registered developers. The iOS 10.3 is a major update to bring a slew of important features such as Find My iPods, new Apple File System, and opt-out from all app rating requests. Apple iOS 10.3 beta […]

Apple releases iOS 10.3 beta 7 build for the developers ...


Earlier OnePlus had released the latest OxygenOS open beta for its flagships the OnePlus 3 and 3T. And now it seems the company has finally fixed all the issues within the beta version. As such, OnePlus has now started to roll out the latest stable OxygenOS update for the OnePlus […]

OnePlus 3 and 3T OxygenOS 4.1.0 with Android 7.1.1 Nougat ...



While Samsung prepares for the launch ofSamsung Galaxy S8 and Galaxy S8 Plus, leaks and rumours continue to pour. According to Korean website Naver, both new flagships will carry a 12-megapixel camera that can capture 1000 frames per second (1000fps) slow motion video. To achieve that, Samsung is using a new 12-megapixel image sensor […]

Samsung Galaxy S8, Galaxy S8 Plus rumoured to record slow ...


Lenovo-owned Motorola is undoubtedly only of the most popular and successful smartphone brands in India. The company considers this market as a significant one across the world. With the launch of the G series smartphones a few years back, Motorola started achieving success. After the release of the latest one […]

Motorola Moto G5 Plus, Moto M, Moto Z Play, Moto ...


As promised, Lenovo’s Motorola has launched its 5th Generation of Moto G phones as a part of Motorola’s tradition this year. Initially, this smartphone was showcased at Mobile World Congress (MWC) 2017 last month in Barcelona. The Moto G5 Plus is now available in two variants — 3GB RAM with 16GB inbuilt […]

Moto G5 Plus vs Xiaomi Redmi Note 4: A mid-range ...



As mentioned above, HTC has announced the U Ultra at a price of Rs. 59,990. Despite the fact that it is an high-end flagship smartphone, the price is somewhat too high for a company that has been struggling to be successful in the market. Since the past few years, HTC […]

HTC U Ultra review: A well designed, powerful flagship, demands ...


OPPO F3 Plus is the new device which is going to be launch on 23rd of March, and it will be added to the F3 series. Oppo has announced that the device will be launched in five different markets – India, Indonesia, Myanmar, Vietnam, and the Philippines.

OPPO F3 Plus Smartphone with dual front cameras to launch ...


In case you are a fitness freak, you will certainly be aware about the current state of the fitness trackers market. While fitness trackers used to be the “in thing” until a few years ago, the industry seems to have hit some sort of ceiling as far as innovations go. […]

Leaked images of the Garmin Vivosmart 3 appear online



Lenovo Vibe B is the latest budget smartphone that has entered the Indian smartphone arena. This phone is priced at Rs. 5,799, which makes it a pretty affordable offering. Lenovo has announced the Vibe B smartphone in Matte White and Matte Black color variants. The device has been listed on […]

Lenovo Vibe B stands against these budget smartphones


Xiaomi is now set to launch a special version of Xiaomi Redmi Note 4 in China and it will be called ‘Exclusive Version’. According to Gizchina, this new version of Xiaomi Redmi Note 4 Exclusive will feature 4GB of RAM and 64GB of internal memory. This is really the first […]

Xiaomi to launch 'Exclusive Version' of the Redmi Note 4


Xiaomi’s popular phablet the Mi Note 2 till date has only been available in two color variants Bright Black and Glacier Silver which was in fact recently announced by the company on March 6. However, according to a recent leak, the company might be bringing another color variant for the […]

Xiaomi Mi Note 2 new color variant leaked in images



Update: According to our exclusive source we have been told that Vivo will be launching the Y53 Smartphone in India tomorrow at a price of Rs 9,990. The Smartphones USP is the budget hardware offering at a budget pricing that’s comparable to other smartphones.

Vivo Y53 Smartphone launching with Snapdragon 425 SoC & 2GB ...


​”Google is reportedly putting an emphasis on assistive features in the next Android version” Google is expected to introduce the next version of Android at its I/O conference in May. Ahead of the unveiling, a few features of the upcoming Android O have been leaked. According to VentureBeat, Google is […]

Android O to reportedly bring new assistive features, including 'Copy ...


Xiaomi has launched the Pro HD In-Ear headphones for the Indian market at Rs 1,999. The headphones will be available at exclusively at Xiaomi’s website Mi.com from today in silver colour. The Mi In-Ear Headphone comes in full metal-wired control bar. It consists of hybrid dual-dynamic and balanced armature drivers. […]

Xiaomi announces Pro HD In-Ear headphones at Rs 1999