HP PL/SQL Interview Questions
- wt is the diff b/w greast and max ,least and min? Wt is the diff b/w case and decod?
- how to print * ** *** **** ***** by using sql query?
- Write a query to filter improper date format following table?
20-apr
22-may-2010
26-jun-2010
Feb-2009
I want the output
Date
22-may-2010
26-jun-2010
- Write a query to remove null following table are
101 dinesh
Null jyothi
Null bharathi
102 suresh
Null shilpha
103 prakesh
Null suma
I want the output format like
Id name
101 dinesh
102 suresh
103 prakesh
- Wirte a query to remove null? Following table are
Col1 col2 col3
Dinesh null null
Null suresh null
Null null prakesh
I want the output like
Col1 col2 col3
Dinesh suresh prkaesh
Col1 col2 col3
Dinesh suresh prkaesh
- Write a query filter the null value data following source?
John 30
Smith null
Null 24
Sharp 35
I want output
Name age
John 30
Sharp 35
- When do we create bitmap indexes
- Can we use out parameter in function?
- Write a query to generate target column.
Src target
Q10 quarter to 2010
Q90 quarter to 1990
Q80 quarter to 1980
Q74 quarter to 1974
- How to call the function and procedure in trigger?
- What is different between union and minus?
- Can we interchange parameters in procedure while calling
- what is 'force view'?
- What are global temporary tables
- What are nested tables? How will u delete 5 rows from nested
- select top 3 sal from each dept?
- what is difference between having and where clause?
- Can you have multiple sps with the same name on a database?
No comments:
Post a Comment