Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Zensar Interview Questions
Questions Answers Views Company eMail

How you count the number of records available at your source?

 3 13019

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

 2 6247

can any one give some examples for pre sql and post sql(Except dropping and creating index).

 3510

What happens if we dont select data driven option?

 2 6419

how we can add header and footer to flat files?

 2 13987

What is sort key and how it controls?

 3 11478

Why we need new operator in java at the time of object declaration and why not in c++?

 1 6480

define sql

3 5108

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

 2 5811

i want run following code on button click of view. i am trying to retrieve data from isc_order_details table and isc_product table. but after retriaval of data i m getting error like FIELD MUST BE ENTERED!! DECLARE m number; n number; CURSOR order_details IS SELECT PRODUCT_ORDER_QUAN,PRODUCT_ID FROM isc_order_details WHERE order_id=:isc_order_master.order_id; amount NUMBER (8,2):=0.0; alert number; BEGIN go_block('isc_order_details'); first_record; m:=:system.cursor_record; last_record; n:=:system.cursor_record; OPEN order_details; --for i in m..n loop FETCH order_details INTO :ISC_ORDER_DETAILS.PRODUCT_ORDER_QUAN,:ISC_ORDER_DETAIL S.PRODUCT_ID; IF order_details%FOUND THEN SELECT order_value,order_date INTO :ISC_ORDER_MASTER.ORDER_VALUE,:ISC_ORDER_MASTER.ORDER_D ATE FROM isc_order_master WHERE order_id=:ISC_ORDER_MASTER.ORDER_ID; SELECT product_desc,product_price INTO :ISC_ORDER_DETAILS.PRODUCT_DESC,:ISC_ORDER_DETAILS.PROD UCT_PRICE FROM isc_product WHERE product_id=:ISC_ORDER_DETAILS.PRODUCT_ID; next_record; END IF; EXIT WHEN order_details%NOTFOUND; END LOOP; last_record; CLOSE order_details; EXCEPTION when NO_DATA_FOUND then alert:=SHOW_ALERT('ENTER_DATA'); Go_Item('isc_order_master.order_id'); END;

 1879

Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

 4 6799

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

 3 6768

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 4199

how can stop the sequence with mention the max value and with out mention the max value

 1 5529

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

 9 10072

Post New Zensar Interview Questions


Zensar Interview Questions


Un-Answered Questions

why the pic micro controller have internal eeprom?But in 8051 have only rom and ram.

2446

Write a program to reverse a number?

655

How can you apply javascript to a web page?

466

Why would you want to join this company?

708

What does this command do? Cat food 1 > kitty

980




How would you handle an imbalanced dataset?

75

Would you tell me something about glyphicons and how are they written in our code?

5

What are the organizational related Infotypes

1566

How to install installing mariadb on homestead?

441

Is angularjs a framework, library or a plugin?

436

Which tag is used to upload a file on the website in jsf?

63

How to convert a list into other data types ?

231

Explain me what is your favorite feature of laravel?

406

If a function does not have a return statement, is it valid?

481

What is a delimiter in sas?

549