Latest Posts

GenAI Fundamentals

GenAI Security 101: Essential Vocabulary Explained – Edition 001

genai security series

AI Security Fundamentals Series for Professionals

HTTP Query method

Quick overview of RFC 10008: The HTTP QUERY Method

Book Review Never Eat Alone

Unpacking the Myth of the Self-Made Achiever: Never Eat Alone Book Review

PL-7008

Understanding PL-7008: Your Guide to AI Agent Certification

How to Publish blog remotely using Microsoft Word

Having a website is very common these days. Either through free website service providers like blogger, tumblr, WordPress or having own registered TLD (Top Level Domain) and self hosted site developed using WordPress or Drupal or many other famous open source CMS.

All bloggers are not from technical background and posting an article is somehow tougher for them at the initial stage. They face problem in setting categories, text formatting, url inclusion, image insertion etc. Moreover, we usually write the whole article first using Microsoft Word or similar editors based on various Operating Systems.

How about posting a blog remotely and directly from MS word to your website? Isn’t it cool and easy for majority of bloggers? Question is how we can post a blog directly from MS Word, right?

How Mobile Phone signal booster can be useful for you

  • admin
  • August 14, 2014
  • 10

Have you heard about the innovative mobile phone signal booster?

The world is full of different kind of inventions, and therefore it is no wonder that every problem has its own solution. Thinking about this, it is easy to see that even the low signal can be easily fixed with a mobile phone signal booster, which is actually a great thing that allows people to communicate more, being able to overcome issues like distance.

Participate in CodeVita 2014 – TCS Global Coding Contest

  • admin
  • August 6, 2014
  • 14


Are you a coder? Do you want to show off your programming skills and test them against other coders?
CodeVita is here for you! This coding contest from Tata Consultancy Services (TCS) lets you pit your skills against contestants around the globe. Get started now! Registrations are open for students from India, New Zealand, Australia, South Africa, Peru, Mexico, Colombia, and Uruguay.
Official link: https://campuscommune.tcs.com/intro/view_blog/codevita-2014-tcs-global-coding-contest
Twitter link: https://twitter.com/hashtag/TCSCodeVita?src=hash
Facebook link: https://www.facebook.com/hashtag/tcscodevita

But first, the rules
CodeVita is a team contest. Each team must have two members. Each member has to register individually in order to participate.The contest will have three rounds of coding.

Registration details

Codevita is a global contest and in order to participate in this contest a participant must follow the below steps:

1) Create a profile on the TCS Career portal. (If you have already created your profile, please ignore this step.)

  • If you are a student currently studying in an institution based in India, register on the TCS Next Step portal. Ensure that you create your profile as a Campus/Off Campus applicant. 
  • If you are a student currently studying in an institution in any other country (except India), then create your profile here.

2) Login to Next Step portal.

3) Launch the Campus Commune platform

4) Register for the Contest

  • Click on the CodeVita banner on the Campus Commune homepage to register for the contest.
  • Note down your secret code. You will need it to sign into the CodeVita contest platform.

5) Form your Team

  • Form a two member team to participate in the contest

6) Login to the CodeVita Coding Platform and participate in the contest

To warm up for the contest, you can participate in a practice round before the main event.

Look at the contest calender below  for details on the practice and contest rounds.

Note: For Indian students, the contest is open to students in the batches of 2015,16,17 and 18.

Display Same Record Multiple time from SQL Query

I would like to share a interview question where you have to display the same records multiple times using SQL query. This is very easy job with the help of PL/SQL block but here we will see, how we can do this using SQL query.

 

First check the sample data and desired output.

[sql]CREATE TABLE TMP (
  Text VARCHAR2(10) ,
  min NUMBER ,
  max NUMBER) ;   
 
INSERT INTO tmp VALUES (‘AAA’, 2,4) ;
INSERT INTO tmp VALUES (‘BBB’, 25,28) ;
INSERT INTO tmp VALUES (‘CCC’, 10,13) ;[/sql]

Now come to solution , if somehow we get the series of number (like 1,2,3,4… Max) as a data set and then we can join this with original table to get desired output.
We can get this data set of number(like 1,2,3…) with the help of “Connect by Level” .
Here LEVEL is a pseudo column which returns 1 for a root row, 2 for a child of a root, and so on. CONNECT BY specifies the relationship between parent rows and child rows of the hierarchy. We use all these in hierarchical query. Will explain hierarchical query in detail in different article but not here.
First check below example to print number 1 to 10 with help of CONNECT BY LEVEL. This is the common question which is asked during interview to print number 1 to 10 from dual.

[sql]SELECT  LEVEL FROM dual CONNECT BY LEVEL <= 10 ;[/sql]

Above query return number 1 to 10.   
We will use this method to solve given problem.
 

Method 1 :

[sql]SELECT  tmp.text || ‘   Value   is   ‘ || b.L  FROM tmp,
       (SELECT  LEVEL L FROM dual
        CONNECT BY level <= (SELECT  max (max) FROM tmp )
        ) b
WHERE   b.L >= min
AND     b.L <= max
ORDER BY 1[/sql]
In above query, line no 2, 3 will gives number series 1 to 28. and I am joining this with original table.

Method 2:    This is same query as above ,just I am writing in different way.

[sql]WITH  cnt AS (
        SELECT  LEVEL L FROM    dual
        CONNECT BY level <=  (SELECT  max (max) FROM tmp)
    )
SELECT  tmp.text || ‘   Value   is   ‘ || cnt.L
FROM    tmp , cnt
WHERE   tmp.min <= cnt.L
AND     tmp.max >= cnt.L
ORDER BY 1[/sql]
Method 3:  
[sql]SELECT text || ‘   Value   is   ‘ || L
FROM (
SELECT distinct tmp.text, level L, tmp.min
from tmp
connect by level <= tmp.max
)
WHERE L >= min
order by text , L?[/sql]
 
Friends, please share your knowledge as well, if you know any other method.

Follow me at : Facebook

8 Hottest and Newly Emerging Engineering Jobs in India

 Hottest and Newly Emerging Engineering Jobs in India – Excellent Prospect for Future Engineers!

This is not an unknown fact that engineers are undoubtedly one of the best paid professionals across the world. In the past ten years, not only the number of engineering graduates has increased remarkably, but also the advent of fields and sectors to work in has multiplied. Thanks to the tech boom! For aspirants who manage not to fit in the box and really love to work out of it, here is a list of eight hot jobs, which will help them break into the new fields of engineering. Have a look at the jobs below –