Databases Interview Questions
Questions Answers Views Company eMail

Can you tell me how to add new column in existing views?how?How is possible?



I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

IBM, Saama Tech,


How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from ; except this you can't use another select statement. You can use no of variables as per requirement.


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.



how to find 6th highest salary

Chetak Logistics,


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this


difference of using cursor for loop and open,fetch,close.which one is better



Un-Answered Questions { Databases }

How would you determine who has added a row to a table?


Which is better Oracle or MS SQL? Why?


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?


can u pls share responsibilities for production how to environment in odi?and how to generate report ?


all the queries used in sql


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?


Is there any link between pr form(purchse requisition)and po form(purchase order)


Can a formula column be obtained through a select statement ?


i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........


i want to know about the javaBean.what is its purpose and how it can use in Forms.


What are the Roles and responsibilities of database administrator?


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f


How can set the multipal database ?


can we use lexical perameter in oracle plsql if yes how