what is cursor procedure1 5103
how to get second highest salary in SQL(as/400029 15953
Please let me know if UNION ALL and Natural Join does the same operation and are same...7 10234
What is meant by Materialized view?2 4805
I need to write a simple query,which one is better select statement or stored procedure?and why?2 4575
i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.14 11910
banking domain description for software tester for interview
What is the base for issuing of C-form date of sale or date of purchase since goods sent by one quarter ended may reach in next quarter.
pass the journal as wellas ledger entries off the foll 1st jan :> started businress with cash rs 1,20,000 & goods worth rs 60,000. 2nd jan > cash purchases rs 50,000. 4th jan >cash sales rs 40,000. 6th jan > purchase good's from sonali on credit worth rs 30,000 at 10 % trade discount. 8th jan> sold sood's to komal on credit rs 20,000 at 10% trade discount. 10th jan > paid rent by a cheque rs 50,000. 12th jan > good's worth rs 4,000 lossed by fire. 14th jan > good's worth rs 3,000 withdrawn from business for personal use. 16th jan > good's worth rs 2,000 distributed as free samples. 18th jan > good's worth rs 1,000 exchange for furniture.
What is mean by Sensitive Earth fault & what are the effects
what is the required force to bend 2.5 MS sheet in 90 degrees and what is the formula to calculate the same?
Can i make restrictions for sales order? Like, book the sales order only for 100 or above quantities?
What is the recommended way to use three-way file merging?
how to join query for one source type is oracle another source type is sql server ?
whenever install patch cluster, system will be restart what is the problem?
what is ms configure?
how much winding resistance of 0.75kw to 12.5kw 3ph sqwiralcage induction motor?
What is the function module for INDIAN PAYROLL to read table cluster for given cluster table and sequence number?
What is Independant Testing? When and where this type of testing will be performed?
consider a program module that inputs two (2) values, n and max, and computes the sum of the first n integers as long as this sum is less than max; otherwise an error should be reported. if n is negative, then it takes the absolute value. a) list the equivalence partitions, and b) list the boundary values.
1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?