Describe the Index, Types of index, At what situation we have used? Which one s better than others?
1 3709i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
12 19944There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
4 11412If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
2 8834Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
4 12745a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
4 10433why we go for package? what are the advantages of using instead of seperate procuderes or functions
3 10313Post New IBM SQL PLSQL Interview Questions
How can I speed up my spark?
how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief
Explain recommender systems?
Does postgres use sql?
do you know what is integration framework?
Why can't we add products while specifying target catalog entry in promotions?
List some Technology characteristic of Bluetooth?
Index of an Array containing 'n' aliment varies from________to_______
Q:Hi all,i want accurate answer with code using in built functions.please sent me code as soon as posible. I have program nmed PGM1 which '' RETRIEVE Current production date''should correctly default the production date for the user who is issuing raw materials to the manufacturing.The production date can be different from the celendra date. However, the program does not make the correct adjustment for all manufacturing plants. there is a parameter which determines the production start time e.g. 07:00 if the system time precedes this,the program subtracts one from the celendra day.This work fine when the celendar day starts after production day as it does in England,the system should be adding one to the celendar day during the overlap. unfortunately the program was desined to assumed the celendar day always starts before the production day. Change required in the program: Change the PROGRAM PGM1 to use the new parrameter to decide whether to add or subtract 1 from the celendar day when determining the production date.
What is pathping command?
What is the syntax of update document?
Difference between Value type & reference types ? and give the example in .Net?
What is the function of entry sequenced data set?
How to connect html page to database using jdbc?
What is grouping in excel?