A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.2 5960
Main diff between varray and nested tablea3 6502
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi email@example.com
What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual6 13457
What are the steps you take to tune(performance tuning) the code in plsql?4 11808
we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?3 5776
i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.4 4809
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP1 6841
If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.3 6644
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.1 1480
How did you export data from database to excel file.1 3205
What is extent clause in table space?1 1365
What is the use of time stamp in select statement?1 1814
Which data type doesn't allow null data type?6 4576
How RAL(Rotary air lock)works in cement industry?
How you will determine the volume of oil in a particular Distribution transformer.
can anyone help me with some suggestions and improvemnts for sage line 50?
Which will have more strain energy 1.Spring 2.Circular disc 3.Solid square plate.
pls give me some basic informations in construction of a structure?
Is there any standard guidelines/Criteria to design NGR/NGT.?
I have given the protocol for the cyclodextrin glygosyl transferase assay: One ml of appropriately diluted enzyme sample was incubated at 60 °C for 15 min with 5 ml of 1% (w/v) gelatinized soluble starch in 50 mM, 7.0-pH Tris–HCl buffer. Reaction was terminated by boiling the reaction mixture for 3 min and reaction volume was made to 10 ml with distilled water. Two ml of above reaction mixture was withdrawn and mixed with 3 ml of Tris–HCl buffer, 5 ml of 125 mM Na2CO3, and 0.5 ml of phenolphthalein (25 mg phenolphthalein/100 ml absolute alcohol). Absorbance was measured at 550 nm. The percent decrease of sample was calculated with respect to control containing 5 ml of buffer, 5 ml of sodium carbonate and 0.5 ml of phenolphthalein. where Acontrol = absorbance of control and Atest = absorbance of sample. The amount of β-cyclodextrin (β-CD) produced was estimated from the standard graph of 0–500 μg/ml β-CD concentration against % decrease in absorbance. One unit of CGTase was defined as the amount of enzyme required to produce 1 μm of β-CD/min. Please can you suggest me the formula for the defination given in the last line
Trouble4 shooting , handiling issues with different level of priorties
Could you plz tell me in detail and with proper example that what is ROI and explain me with proper example that how will you calculate ROI of a distributor?with Example and Calculation.
"WHERE THERE IS A RIGHT, THERE IS REMEDY" EXPLAIN THIS WITH REFERENCE TO BREACH OF CONTRACT.
What is a bag in Pig Latin?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :firstname.lastname@example.org
I have 2 KW electric water heater.I am gonna use it in controlling water temp.so I needed to increase or decrease the heating capacity.is there any electrical-electronic circuit for varying the resistance & so current?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Have you ever committed a mistake at work?