RBN-INFO-TECH : JAVA SCRIPT - TUTORIALS & SOME TIPS AND TRICKS

The Java and Java-Script are totally different languages in both concept wise and design,The Java is developed by Sun Microsystems,which is a powerful and much more complex programming language which is the same category as C and C++.


This is the starting stage of java-script and you can do it using html


You can find the tutorial at 'W3SCHOOLS' - http://www.w3schools.com/JS/default.asp


In this you can try the example for yourself referring some given examples in the site.


Most commonly used scripts are alert,functions,if-else conditions.


Alert - alert("Alert warnings"); place this in your script part an alert appears on the event you place.


Functions - To maintain the browser from executing an script when the page loads, Its better to put your script into a function.

A function contains the code that will be executed by an event / by a call to the function.It is possible to call a function from anywhere within a page .

The Functions can be defined in both and the section of an document.To make sure that a function is read/loaded by the browser before it is called,It could be better to place functions in the section.

example:

function function_name(var1,var2,...,varX)
{
You codes..............
}

More detailed information on Java-script are available at 'W3SCHOOLS'

RBN-INFO-TECH

RBN-INFO-TECH : Interview Tips

Q: What job would you like to have in five years time?

It's a mistake if you haven't thought about this question and how to answer it. Your interviewer will use your response to gauge your desired career direction, your ability to plan out how to achieve your goal and what moves you are making to reach it. It will also tell them how real your desire to reach your goal is and to what extent their organisation can accommodate your aspirations. A good answer will include the following: an acknowledgement from you that you have things to learn; that you would like the company to help you with this learning; and that although you have progression within this department in your sights you will also consider other opportunities throughout the company, should they arise.

Q: Why do you want to work here..?

This requires some forethought. It means that you go into an interview forearmed with facts and information about the company you are looking for a job with. If you've done your homework you have nothing to fear. Your reply should include the company's attributes as you see them and why these attributes will bring out the best in you.

Q: How do you work under pressure?

This question is offering you the opportunity to sell your skills to your prospective employer. Think of an example in your current job, explain how it arose and how you dealt with it. Do not say anything negative about yourself unless you can finish off your reply with what you have learned from the experience. You can also use this question to demonstrate how you can alleviate pressured work situations arising - that your own capabilities to plan and manage your time can reduce hasty decisions and panicked deadlines arising.

Q: Why do you want to leave your current job..?

The acceptable answers to this question fall into two categories, how you feel about your career and how you feel about the company you currently work for. And your answer may include a combination of reasons from both areas. Regarding your career - do you want fresh challenges? More opportunity for growth? Would you like to develop new skills? With regard to the company, did you feel that your position was not secure? Was there nowhere else for you to go in the department? Does the company you are applying for a job with have a better reputation?

Q: What specifically do you have to offer us?

Start your answer with a recap of the job description of the post you are applying for, then meet it point by point with your skills. It's important that you also paint a picture of yourself as a problem solver, someone who can take direction and who is a team player, and of course someone who is not only interested in their personal career success, but the success of the company.

Q: What is your greatest weakness..?

This question is an attempt by the interviewer to tempt you into casting yourself in a negative light - don't do it. Always turn your weaknesses into positives, and keep your answer general. Try to think about allowable weaknesses for example , a lack of knowledge in a certain area is an opportunity for development. Frustration with others may signal your total commitment to a project or a perfectionist nature.

Q: What are your greatest accomplishments..?

Keep your answer to this question job related, think of past projects or initiatives which you have played a part in and which have brought positive results for you and the company. Do not exaggerate your role, if your greatest achievement occurred as part of a team, then say so. It not only shows your ability to work with others, but to share credit when credit is due.

Q: How do you handle criticism..?

This question is designed to find out if you are manageable as an employee. In your answer you must present yourself as someone who will accept direction, but who also has a decent quotient of self-respect. Everyone deserves a reason and explanation for criticism. If your manager does this in a way which respects your situation then you should say that this is acceptable to you and that you will grow from it. If the correction is brusque, you should also say that you can accept this too - your boss may have something on his/her mind, you must show yourself as someone who can recognise the bigger picture.

Q: Are you willing to travel/relocate?

In this question you may find yourself caught between a rock and a hard place. If you say no - you might as well end the interview there and then. If you say yes, who is to say you won't end up in Alaska? Find out what they are really asking - is it business travel or is the company relocating? If relocation is the option there are two ways to play this - be honest, or veer towards yes whatever, after all your goal at interview is to get a job offer, without such an offer you have no decision to make, and no chips to bargain with.

Q: What kind of people do you like working with?

A: Easy, people like you! In this question you can again flag up your attributes as attributes you expect in others. Key words are pride, dedication, self-respect and honesty.

RBN-INFO-TECH

RBN-INFO-TECH : Merge Satement In Oracle

Oracle introduces the new MERGE SQL command. The much more elegant way to insert or update data with Plsql is to use Oracles merge command.It is a DML command that enables us to optionally update or insert data into a target table, depending on whether matching already existing records. In oracle 9i, we would have to code this scenario either in separate bulk SQL statements or in PL/SQL. We will compare MERGE to these methods later in this article.

Syntax

Merge into destination_table X using source_table Y  on (X.unique_id = Y.unique_id)  when matched then    Update  set X.name = Y.name,      X.rollno = Y.rollno,      X.address = Y.address  when not matched then  insert (X.contact_id,     X.date_of_birth,     X.full_name,     X.unique_id)  values ('16-mar-1988',     Y.DoB,     Y.full_name,     Y.unique_id);

Example-:

We can now see an example of the MERGE statement. In the following example, we will merge the source table into the target table. We  will  capture a count of the target table rows before and after the merge.
SQL> SELECT COUNT(*) FROM target_table;
    COUNT(*) ----------      43485  1 row selected. 
 SQL> MERGE   2     INTO  target_table tgt   3     USING source_table src   4  
   ON  ( src.object_id = tgt.object_id )   
5  WHEN MATCHED   6  THEN   7     UPDATE   8    
 SET   tgt.object_name = src.object_name   9     ,     tgt.object_type = src.object_type  10  WHEN NOT MATCHED  11  THEN  12  
   INSERT ( tgt.object_id  13            , tgt.object_name  14            , tgt.object_type )  
15     VALUES ( src.object_id  16            , src.object_name  17            , src.object_type );
  95865 rows merged.
Note the following clauses -:
MERGE (line 1)   : as stated previously, this is now the 4th DML statement in Oracle. Any hints we might wish to add directly follow this keyword (i.e. MERGE /*+ HINT */);
INTO (line 2)      : this is how we specify the target for the MERGE. The target must be either a table or an updateable view (an in-line view cannot be used here);
USING (line 3)   : the USING clause represents the source dataset for the MERGE. This can be a single table (as in our example) or an in-line view;
ON () (line 4)    : the ON clause is where we supply the join between the source dataset and target table. Note that the join conditions must be in parentheses;
WHEN MATCHED (line 5) : this clause is where we instruct Oracle on what to do when we already have a matching record in the target table (i.e. there is a join between the source and target datasets). We obviously want an UPDATE in this case. One of the restrictions of this clause is that we cannot update any of the columns used in the ON clause (though of course we don't need to as they already match). Any attempt to include a join column will raise an unintuitive invalid identifier exception .  and
WHEN NOT MATCHED (line 10) : this clause is where we INSERT records for which there is no current match.
Note that sqlplus reports the number of rows merged. This includes both the updates and inserts. Oracle treats MERGE as a MERGE and not an UPDATE+INSERT statement. The same is true of SQL%ROWCOUNT in PL/SQL.
RBN-INFO-TECH

RBN-INFO-TECH : A Good Work At Home Business Idea

Having trouble finding the perfect work at home business idea for you...? You may be trying too hard. To build a profitable business, you must start out with one researched, well thought out idea. A home business can be a very rewarding and challenging experience. It is most important to start your business on the right foot. Let's examine some of the initial steps in helping you decide what would be a good work at home business idea for you.

How do you decide what type of work at home business idea would be best..? Ask yourself these questions. Are your goals to achieve independence and financial security..? A home business requires a determination to succeed. Also a new business owner must be willing to accept challenges. Sometimes, you must be willing to work 10 – 12 hours per day, 7 days per week. Often money is scarce in the first few months so income may become a problem. But with a little time, a simple work at home business idea can start making profits.

Here are some tips to consider when searching for a work at home business idea.

• What makes you happy..? A hobby or some other type of pastime can turn into a profitable business. You have to enjoy your work to be truly happy. Why not start a business out of a pleasurable activity?

• What are your talents..? Many times we have skills that others don't that can be turned into a business venture. For example, some people have talents in scrapbooking. Many people want to preserve their pictures for the future but don't have the craft skills necessary to do a good job. This situation could turn into something that might be profitable for the right person.

• Ask your friends and family what you are good at. Their opinions might surprise you and cause you to think of a good work at home business idea.

A work at home business idea is out there waiting for you. Without a lot of hard work and a little soul searching, you can come up with the right idea for you.

RBN-INFO-TECH

RBN-INFO-TECH : WHAT ARE THE FUNCTIONS IN ORACLE ?

Oracle SQL Functions

1.  ABS(n)  : It returns absolute value of a number

    Eg:   ABS(-25)=25

          ABS(34)=34

2.  ACOS(n) : Returns arc cosine of number(n).’n’ must be in the   range of -1 and 1

                  Eg:   ACOS(.3)= 1.26610367

3.  ADD_MONTHS(date,num_months) : Returns date + num_months

              Eg: ADD_MONTHS('01-Aug-03', 3)= '01-Nov-03'

4.  ASCII(char) : it Converts char into a decimal ascii code

              Eg:   ASCII(3)=51

5.  ASCIISTR(char):argument of this function is a string ,or expression that resolves to a string ,in any character set.it returns an ASCII conversions of the string in the database character set.

              Eg:   ASCIISTR(ABCDE)= AB\00C4CDE

6.  ASIN(n) : returns arc sine of n.

              Eg:   ASIN(.3)= 0.30469265

7.  ATAN(n) : it returns arc tangent of n.

              Eg:   ATAN(.3)= 0.29145679

8.  ATAN2(n.m) : it returns arc tangent of n and m. 

              Eg:   ATAN2(.3,.2)= 0.9827937232

9.  AVG([DISTINCT]n): Averge value of 'n' ignoring NULLs

10.  BETWEEN value AND value : Where 'x' between 25 AND 100

11.  BFILENAME('directory','filename'): Get the BFILE locator associated with a physical LOB binary file.

12.  CASE : used to Group the data into sub-sets.the case statement is an alternative for the decode function.it is used for the construction of if-then-else.

Eg: select id

, case (when status ='A' then 'Accepted'

when status ='D' then 'Denied'

else 'Other') end

from employee_maser;

13.  CEIL(n) :       Round n up to next whole number.

                    Eg: ceil(3.4)=4

                        Ceil(3.9)=4

14.  CHARTOROWID(char) : it Converts a Char into a rowid value.

                    Eg : SELECT ID from some_table WHERE ROWID = CHARTOROWID('AAAAtmAAEAAAAFmAAA');     

15.  CHR(n) : Character with value n

                     Eg: chr(51)=3 

16.  CONCAT(s1,s2) :  it Concatenate string1 and string2

                   Eg : concat('df','ee')=dfee

17.  CONVERT (char_to_convert, new_char_set, old_char_set) : 

              Convert a  string from one character set to another.

18.  COS(n): Cosine of number

                  Eg : cos(.3)= 0.95533648

19.  COSH(n)       Hyperbolic Cosine of number

                  Eg : cosh(.3)= 1.04533851

20.  COUNT(*) :     Count the no of rows returned

RBN-INFO-TECH

RBN-INFO-TECH : HOW TO MAKE MONEY AT HOME, USING YOUR PERSONAL COMPUTER

Its now easy to earn money with your personal computer,The technology has grown that much which make thinks easy and possible .Not the everyone wants to own their own business and not everyone who wants to is capable of being a success. But for those of you who currently own or are thinking of buying a personal computer, you can just about the guarantee yourself that for just a few hours of your spare time, you could easily produce an income that will exceeds your current monthly earnings. Thousands of success stories have been documented and you could easily earn up to $5,000 a month and more, in your spare time. And if you enjoy the computers you can have fun,while you earn your extra incomes.
The Home based computer entrepreneurs were once predicted to be 'the wave of the future'. The U.S. Labour Department believes that up to half of all Americans could be working at the home by year 2000. If that prediction is true, a large number of these workers will be home based employees of various major corporations. Millions of others ,however will be home based entrepreneurs engaged in a business of their own.
you can also earn,Its true technology has developed a lot .

download the tutorial to refer how to earn money with your personal computer?
Downloads:

RBN-INFO-TECH

RBN-INFO-TECH : HOW TO EVALUATE HIGH 'TECHNOLOGY' STOCKS

The High technology is last frontier in the American business. Many of the new businesses revolve around some type of technology, whether it is directly computer , communications related or some how tied in with the 'Electronic Superhighway', whose arrival we all eagerly anticipate. Although tech stocks have declined sharply in during bear markets, They had prove to have out perform other stocks, re-bounding more sharply in subsequent recoveries.
There are 3 major advantages that point to small companies:
a.) They are generally free from the government regulation because their earnings are often in the new field.

b.) The company stands to gain a lot of ground, if the come up with a unique idea. The growing market will be theirs to dominate.
c.) The impact their earnings will have on their financial status will be considerable.Therefore a success can increase their profitability greatly.


There are several rules to follow, if you choose to be an investor in this high risk market. Firstly, do not be fooled by size of the company. It is important to investigate the high-technology expertise of the firm and secure that it is a meaningful part of the firm’s business. Secondly,It is vital that the company is serving an current social need in the marketplace.

For example:
The cable was first introduced in the 1960’s and interested investors long before, it could draw subscriber's.
Look for companies that are operating in the black. The Companies that offer teriffic scientific break throughs, but operate at a deficit are just too risky.It is also important that you ignore market indexes. The Companies with technological superiority are not tied to a stock market environment over-time.

Lastly, keep current on all technological innovations. Buy trade-magazines and read scientific papers and investment guides that deal with technology and technology-related fields.

RBN-INFO-TECH

RBN-INFO-TECH : THE CAREERS IN ' IT ' ENABLED SERVICES

CALL CENTRES: EXECUTIVE-CUSTOMER RELATIONS

A call centre provides the information support to customers,These

centres are manned by the trained personnel with access to a wide data-bases of information , the thorough knowledge and the product or service being offered by the company.

The employment bases in the call centre business is expected to touch 3.5 million by the year 2008-09. Many of call centre businesses in Australia and U.S.A. have started setting up the base in India.

How to become one of this ?:

The Graduates are preferred for this option. Basic skill required to join a call centre is the language understanding (accent and dialect). The recruiting companies provide on the job training.

Where to get in it:

Companies like ICICI, GE & Bechtel have set up in house call centres and provide the support to own employees worldwide.

Salaries:

The Call centre operators can expect more than Rs.8,000/- at entry level. With two years experience one could grow to a supervisory level and draw around Rs.10,000- 15,000 per month.

GEOGRAPHIC INFORMATION SYSTEMS

The Government Departments, telecom companies and utilities are increasingly

depending on GIS data for environmental resource analysis, land use planning, network analysis, etc. marketing and distribution strategies. The job would involve conversion of the data (maps, records, aerial photography etc...) to digital data that can be used for modelling and analysis.

How do you become one? :

A ' BE' graduate with knowledge of operating systems is eligible for such an opportunity. Knowledge of tools like C& C++, specific GIS package or CAD is an advantage.

The Pixel Infotech, Bangalore provides a course for 3 months for those keen in entering this area. The GIS certificate course offered by Pixel is about Rs.15,000 - 20,000 and the two and half month. GIS certificate course offered by Pentasoft is Rs.75,000.

Where to get in it ?:

The One can get recruited in GIS solution providers, research institutes, the Government Sector and the GIS user industries. A few companies are recruiting personnel for GIS,they are Rolta, Intergraph, Seimens, L&T information Technology and Pentafour.

Salaries:

At the Entry level salaries range from Rs.8,000 to 10,000 per month. In two to three years, one can expect to earn over Rs.20,000-30,000 per month.

TELECOM TECHNOLOGY

With advancement of technology the telecom sector is heavily dependant on internet technology. Starting from WAP (Wireless Application Protocol) Service to satellite communication, telecom technology has extended its wings. Telecom Engineers specialising in information technology are on high demand. B.E. graduates with telecom engineering are preferred. Leading multinational companies like Motorola, Nokia, Ericsson, Panasonic etc. need telecom technologists. Generally the entry level salary ranges from Rs.20,000 to Rs.25,000 per month.

INTERNET TECHNOLOGIES

WEB DESIGNER:

A Web Designer is responsible for creating an appealing web site

that is easy to navigate.“Web Designing requires high level of skills and people with both creative and computer friendly skills come at a very high cost to any organisation”.

How to become one of it ? :

Fresh graduates with creative skills can start as designers. Graduates equipped with a diploma/certificate course in Internet Technologies can get into this field. Skills required: ASP, XML,HTML, Cgi, Perf, VB script, Java script, TCP/IP. A typical 9 months Diploma in Web engineering offered by Arena Multimedia is around Rs.27,000; 3 months Diploma in Multimedia Course by Pentafour is around Rs.21,000.

Where to get in it ?:

One can find recruitment in ‘dot com companies’, advertising agencies, companies specialising in web designing , Internet Service Providers etc. Pentasiu.com is one such company recruiting web designers.

Salaries :

At the Entry level salaries are in the range of Rs.5,000 to 10,000 and goes over Rs.15,000 at middle level.

NETWORKING

Careers :

Network designer, Network Manager, Network data Administration, Network Services and Support Manager, LAN service/Support Manager.

Convergence of technologies primarily calls for a networked environment. In such an environment, network engineers are required to keep the system up and running all the time.

A net working professional should have well-honed technical skills, specialisation in certain areas is preferred. Technical skills are considered more important than conceptual skills at the entry level. The entry level personnel are likely to be focussed on tasks like trouble shooting, monitoring LAN performance and its security, adding or deleting of users, adding on new servers.

How to become one of it:?

BE graduates could opt for this career option. BE in computer science, electricals communication preferred. In Addition certification programmes are available from Microsoft, IBM, Novell and Lotus Development Corporation.

The Microsoft certification curricular (22 days) costs around Rs.28,000; Lotus Certification Curriculum (26 days) costs around Rs.20,000.

Where to get in it ?:

Scope appears to be unlimited in the IT Sector, telecom companies, manufacturing and service sector. A few companies who have recruited people for networking include WIPRO, Microland, BFL Software and Infosys.

Salaries :

Entry level salaries are upward of Rs.10,000 and can go up to Rs.20,000 at mid level.

E Commerce

E-Commerce is the emerging paradigm in the world of business today. Most IT companies appear to be focusing on building e-commerce capabilities.

An e-commerce professional’s work would involve understanding operations of companies, web enable their businesses and connect them with their vendors and customers. It would essentially means reorient businesses to be performed on the Net.

How to become one of it ? :

Basic qualification required is B.E./B.tech, DCA/MCS. In addition, knowledge of VC ++, Oracle, SQL, ASP, HTML, Java, Servtets, EJB,CORBA, COM/DCOM is essential.

Most computer institutes offer the above courses. Some of the reputed institutes offering e-commerce courses are STG, NIIT, APTECH, OCAC etc. A six month e-commerce programme in a reputed institute costs Rs.50,000 upwards.

Where do you get in ?

IT companies working in the area of E-commerce, companies which are developing e-business solutions and the user industries would recruit e-commerce specialists.

A few companies that have recruited the e-commerce specialists are CBSI, BFL, Satyam Infotech, Mastek and Infosys.

Salaries :

At the Entry level compensation packages can start anywhere between Rs.10,000 to Rs.14,000. In two to three years one can expect to draw around Rs.18,000 to Rs.20,000 per month.

DATA WAREHOUSING

Data warehousing, which is a repository of organised data, facilitates on-line analytical processing, decision support and data mining data marts are smaller versions of the enterprise data warehouses.Data warehousing essentially helps users in drawing conclusions from a set of data, which are not necessarily logical.

The popularly known data warehousing tools are the Rapid data, SQL bench and Red Brick (a product of Informix).

How to become one of it? :

ABE Computer Science/B.tech/MCA with a minimum of one year experience in the IT industry are preferred, knowledge of RDBMS is essential.

Institutes like RCS Education, Bangalore (offers courses on Red Brick) and OBSI, Chennai are now offering product specific training.

Where do you get in ? :

You could join any of the data warehousing solution providers or user industries. Currently data warehousing companies like TCS, Sonata, Tata Infotech and IBM do recruit data warehousing professionals.

Salaries :

The salaries start upwards of Rs. 15,000 and for some one with more than two years experience it can go up to Rs.25,000 to 30,000.

SYSTEMS

Systems Software specialists continue to be in demand. However, specialisation is the need of the day. Hence right from the start one needs to focus on areas in which one would like to specialise. For instance, telecom software would involve writing programms, coding and module testing of sub-systems, source code documentation in the areas of digital signal processing, wireless application and related telecom domain areas.

How to become one of it? :

A B.E./B.tech in electronics, communication or computer science or M.tech with specialisation in systems are preferred. In addition, basic knowledge of skills like C, C ++ is a must. Some specific technical skills preferred include GSM, TDMA, CDMA, WLL, etc.

Where to get in it? :

Companies working in the systems domain are likely to recruit such professionals. Motorola, Philips, Lucent, Texas Instruments and SAS are some such companies.

Salaries :

Starting salaries range from Rs.12,000 to 15,000 per month. After two to three years in the industry, salaries could be more than Rs.25,000. Most companies are now adopting performance-based packages.

RBN-INFO-TECH