Harish Mahanta

• May 1st, 2006

Inner join:  It is is the most common type of join. Inner joins return all rows from multiple tables where the join condition is met.Outerjoin:  This type of join returns all rows from one t...

Sriram Kammisetty

• Jan 17th, 2006

Inner join : An inner join (sometimes called a "simple join") is ajoin of two or more tables that returns only those rows that satisfy the join condition.Outer Joins : An outer join extends the r...

Answer Question  Select Best Answer

What are the validation is done in SQR program before loading in to the database?

SreejaSasidharan

 Profile Answers by SreejaSasidharan Questions by SreejaSasidharan

• Jul 20th, 2010

No specific validations will be carried out by SQR before loading the data into the database except:1. Any specific validations code written by the programmer.2. Table edits - for example, if the field in the record is number and you try to insert character, it will throw error.SS

Answer Question  Select Best Answer

How will you create Business Units in PeopleSoft Finance and how will you use the same?

srinivas

• May 15th, 2014

Its a logical unit for organisations

Answer Question  Select Best Answer

Ramesh

• Mar 20th, 2005

Yes. It is similar to use function, procedure and packages in SQR. The only difference is - Use begin-Sql Begin procedure(param1,param2) End End-Sql

Answer Question  Select Best Answer

Murali

• Oct 12th, 2005

If data needs to be validated well before updating records and to make parent child records synchronous with respect to data, use AE/CI. When there is huge data to be manipulated, better use SQRs (run on server if possible).

Answer Question  Select Best Answer

Sangeeta

• Dec 19th, 2005

Inner Join is the cartesian product of two or more tables.Its a join of two or more tables that returns only those rows that satisfy the join condition.Outer Join returns all rows that satisfy the joi...

Answer Question  Select Best Answer

kokkondakiran

• May 17th, 2006

using call system command

Answer Question  Select Best Answer

mohan

• Oct 6th, 2006

There are 3 steps 1. Initiate Array 2. Process Array 3. Print Array

Answer Question  Select Best Answer

Need to write the commit command after getting the values. after that we have to delete the values. so i need to write the commit command.