Write a query to get 2nd maximum salary in an employee table ?68 75416
What is an index and types of indexes. How many number of indexes can be used per table ?12 69793
What is a constraint. Types of constraints ?5 19809
What is a trigger ?10 12618
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?2 11598
will function return more than one value how9 15585
what is purge command explain about oracle performance tuning2 20125
Give an example of any procedure.5 11082
How will we see framework of a table?2 7669
When we give SELECT * FROM EMP; How does oracle respond?24 35454
Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;7 6137
SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/1 6803
What is different between union and minus?7 16169
wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-20105 9028
What is the relation b/w view and trigger3 8677
Hi, my requirement is to make a query in SQL using QTP. And i have to get the results of that query and i have to use those results for future testing. I created a driver but i dont know the code for using this Driver. please help me by providing the solution for y requorement
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Tell me on steel
How do you handle any risk that might arise due to changes in requirements?
How to use debug tools?
What are the different problems that ?Data mining? can solve?
How to create a console application in Kylix?
What would you change about your job?
pass journal entries of the following transaction in the books of AG sindh, AGPR,FTO and SBP: 1)DDo sindh house submitted a bill for purchase of furniture to AGPR islamabad for Rs.200000 on 20th March 09; 2)AGPR issued cheque on 2nd april which was cleared by SBP on 5th April; 3)On 26th may, voucher were exchanged in the clearing house; 4)On 28th May, AG sindh issued advise to settlement to SBP karachi; 5)On 5th june,SBP HQ karachi sends a copy of clearnce memo along with bank statement to AG sindh and AGPR for settlement made on 31st May.
IN 1000kva transformer where the oil and winding temperature sensors is connected
electromechanical relay type identification example : type=tjmh t-stants for j- m- h-
can anyone help me out with names of 3 leading 1)logistics companies 2) supply chain companies in the world
How will you determine ranking values?
Is DES available in hardware?
one buyer come to me for purchashing perfume, buyer gave me fake 1000 rupees , the price of perfume 200 rupees, i don't have changes, i took changes from third person and gave him the fake 1000 rupees. now i return the balance money to buyer, now the third person come back to me and tell your money is fake, so i return him original changes money that i took from him, now how many money i loss .