source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

JPMorgan Chase,

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

HSBC,

How to fetch records from a partitioned table?

HSBC,

How many triggers can be implemented for a table?

HSBC,

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

CG,

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

HSBC,

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

HSBC,

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

BT,

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

TCS,

I want to execute a piece of code before calling a procedure. How to achieve it?

Oracle,

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

Maruti Suzuki,

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

Maruti Suzuki,

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

Maruti Suzuki,

Hi Guys, I have a situation where I need to access the column values from rowtype variable. However, the column names are dynamic. below is sample code: declare Cursor c1 is select * from emp; Cursor c2 is select column_name from xyztable; v_c2 c2%rowtype; v_str varchar2 v_value varchar2(200); begin for rec in c1 loop open c2;---this cursor has column names like EMPLOYEE_ID, FIRST_NAME, LAST_NAME etc. loop fetch c2 into v_c2; exit when c2%notfound; /* now lets say i want to access value of LAST_NAME from cursor c1, so I am writing below code, however it does not work as expected */ v_str:= 'rec.'|| v_c2.column_name; -- this will give me string like "rec.EMPLOYEE_ID" v_value:=v_str; end loop; end loop; end; / Plz help ASAP.Thanks.

difference between SQL and C

Indus Software Technologies,