Photographers Right movement to Click..!

Some People Click Their Cameras At Precisely The Right Moment!!!!!!













Live every day with enjoyment - we don't know what tomorrow will give us.

Read More

A one in a billion shot.

Can you imagine being in position to get one of these photos? A one in a billion shot.

Enjoy!

Best Deals only ....

Read More

Potential Gold Mines found in South India

Potential Gold Mines found in South India


Marry a malayali girl and see how much gold you can get...









For those who are already married.... Sorry folks....

Read More

What is the difference between HttpSession mySession=request.getSession(true) and HttpSession mySession=request.getSession()

What is the difference between HttpSession mySession=request.getSession(true) and HttpSession mySession=request.getSession().?

Answer:

request.getSession() will return the current session and if one does not exist, a new session will be cretaed.

request.getSession(true) will return the current session if one exists, if one doesn't exits a new one will be created.

So there is actually no difference between the two methods HOWEVER, if you use request.getSession(false), it will return the current session if one exists and if one DOES NOT exist a new one will NOT be cretaed.

Read More

Types of Joins in Oracle with Examples

Oracle Joins

9i Joins:
Supports ANSI/ISO standard Sql 1999 syntax
Made easy for Appln s/w tools to understand Sql Queries

1. Natural Join
2. Join with Using
3. Join with ON
4. Inner Join
5. Left outer join
6. Right outer join
*7. Full outer join
8. Cross join

1. > select empno,ename,sal,job,deptno,dname,loc
from emp natural join dept;

2. > select empno,ename,sal,job,deptno,dname,loc
from emp join dept using(deptno);

3. > select e.empno, e.ename, e.sal, e.job, e.deptno, d.dname, d.loc from emp e Join dept d
on(e.deptno = d.deptno) ;

4. > select e.empno, e.ename, e.sal, e.job, e.deptno,d.dname, d.loc from emp e Inner Join dept d
on(e.deptno = d.deptno) ;

5. > select e.empno, e.ename, e.sal, e.job, e.deptno,d.dname, d.loc from emp e left outer join dept d on(e.deptno = d.deptno) ;

6. > select e.empno, e.ename, e.sal, e.job, e.deptno,d.dname, d.loc from emp e right outer join dept d on(e.deptno = d.deptno) ;

* 7. > select e.empno, e.ename, e.sal, e.job, e.deptno,d.dname, d.loc from emp e full outer join dept d on(e.deptno = d.deptno) ;

** left outer join union right outer join = full outer join

8. > select empno,ename,sal,job,deptno,dname,loc from emp cross join dept;

Read More

Oracle 8.0 Features

8.0 Features

Returning into clause:
Used to return the values thru " DML" stmts.
Used with update and delete stmts.
Ex:
>var a varchar2(20)
>var b number
>update emp set sal = sal + 3000 where empno = 7900
returning ename,sal into :a,:b;
>print a b

>delete from emp where empno = 7902
returning ename,sal into :a,:b;
>print a b
----------------------------------------------------------------------------
* Bulk Collect:
Used to return bulk data into pl/sql variables.
Variables must be of pl/sql table type only.
Improves performance while retrieving data.
Used with select, update, delete, Fetch stmts.

select ename,sal into a,b from emp where empno = &ecode;
ecode : 101

>declare
type names is table of emp.ename%type index by binary_integer;
type pays is table of emp.sal%type index by binary_integer;
n names; p pays;
begin
-- retrieving all employees in 1 transaction
select ename,sal bulk collect into n,p from emp;
-- printing table contents
dbms_output.put_line('EMPLOY DETAILS ARE :');
for i in 1 .. n.count loop
dbms_output.put_line(n(i)||' '||p(i));
end loop;
end;

* update emp set sal = sal + 3000 where deptno = 30
returning ename,sal bulk collect into n,p;

* delete from emp where job = 'CLERK'
returning ename,sal bulk collect into n,p;
----------------------------------------------------------------------------
Using in Fetch stmt :
declare
type names is table of emp.ename%type index by binary_integer;
type pays is table of emp.sal%type index by binary_integer;
n names; p pays;
cursor c1 is select ename,sal from emp;
begin
open c1;
fetch c1 bulk collect into n,p;
-- printing table contents
for i in 1 .. n.count loop
dbms_output.put_line(n(i)||' '||p(i));
end loop;
end;
----------------------------------------------------------------------------
Dynamic SQL:
Supports to execute " DDL" stmts in Pl/sql block.
syntax: execute immediate(' DDL stmt ');

>begin
execute immediate(' create table employ1
(ecode number(4), ename varchar2(20),sal number(10))');
end;

Note: Table cannot be manipulated in same pl/sql block

begin
execute immediate('drop table employ1');
end;
----------------------------------------------------------------------------

Read More

Introduce yourself in interviews

The most frequently asked question is tell me about your self briefly.The interview starts with this question only.Let us read some questions like...



1)Tell me about yourself?

A)Well,As you know Iam Hemanath Chowdary from Damlacheruvu which is little near to Chittoor in the part of Andhra Pradesh. I born and brought up in Andhrapradesh itself.

My Education Qualifiacation are I did my schooling in Games high school at tirupathi. After my schooling, I finished my graduation of Bsc Chemistry from S.V.arts college in 2006 that is affiliated to S.V. University at Tirupathi. After finishing my graduation, I have done my MCA from J N T University in2009.

Then I got selected in Solidus Multitech pvt ltd in bangalore and having around 2 yrs exp in Microsoft .NET technologies such as C#.net,Asp.net,Ado.net and other tool such as Ms sql server,Flat Text file,photoshop and dreamweaver.

Note:
• Here you should specify your experience on your projects...
• My career objective is Looking forward for a better carrer in Organization
• My strengths are dedications....willingness to walk an extra mile to achieve my career.
• Iam very eager to learn new technologies
• My weakness are.....

About my family background:
• My father is a retired headmaster and mother is a homemaker and i have 4 sisters and don't have brothers.
About my hoppies:
• singing song,playing cricket and watching TV

2)If we hire you, and then another company will offer you more money - what will you do?
A) Sir,money is not the matter.I prefer a company which gives me a oppurtunity to expose my ideas in a clear manner.
3)Why you are looking for change ?


A)i am looking for technical and economical growth, and wantto work in such environment where i can use my skill,innovative ideas and also improve my knowledge and skill.

4) how much salary you expected?

A)IT DEPENDS ON NOT ONLY COMPANY STANDARDS BUT ALSO ASPERINDIVIDUAL'S EXPERIENCE,PERFORMANCE AND CAPABILITY IN THE
PREVIOUS JOB AND MARKET CONDITION.

5) What does success mean to you?

A)For me success is not a destination of a achievement.It is a continous journey.
6) what are your strengths ?

A) My strengths are optimistic,self learner,team worker.i m altruist also

7) Tell me about your dream job.

A)The job that doesn't appear in my dream while i sleep.

8) What do you expect of others in a team environment?

A)Sharing knowledge & valuing the others opinion.

Read More