| Other SQL PLSQL Interview Questions |
|| Asked @
|Like shown below i have 3 columns(Name,No,Address). The
values in name column i want to modity.
Requirement : Keep only once space between two words
(Fname,Lname) in the Name column.
For this what is the query? Please answer me. Advance
Name No Address Reference
gowri nath -- -- --
|i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks
i need 1st dd for evry wk
|What is the difference between UNIQUE KEY and UNIQUE INDEX?
|I have a package in which a table was used in a procedure
and compiled later i have dropped the table used in the
package what would be the status of package specification
|using cursors salesman get bonus as 10% of their salary ,
managers get 20% , analalist get 30%. generae a report
showing the employee name, salary , bonus.
|how can i read files from a pl/sq l program
|How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?
|Where the Pre_defined_exceptions are stored ?
|how to find the second highest salary from emp table?
|What are the Diff B/W Cursor and REF Cursor
|i don't want the message as 14 rows updated just it should
update what it will do
|wtite down triggr not any entry on Sunday
|For more SQL PLSQL Interview Questions Click Here |