-
Is it possible to create Synonym for Triggers ?
If your answer is yes, explain the steps.
-
How will you delete duplicating rows from a base table?
Delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); ordelete duplicate_values_field_name dv from table_name ta where rowid <(select min(rowid) from table_name tb where ta.dv=tb.dv);
-
HAVING vs WHERE Clause
Where clause restricts rows, what does having clause restricts ?1. only group results.2. rows results.3. both rows and groups result.
-
View - Base Tables
Does View occupy memory? If we delete the base table of existing view, What happens?
-
-
-
-
-
Rename a Column
How to rename a column in a SQL table?
-
-
Difference between nested query,sub query and nested query?
What is difference between nested query,sub query and nested query? explain clearly with an example?
-
There is a % sign in one field of a column. What will be the query to find it?
'' Should be used before '%'.
-
Pair Wise & Non-Pair Wise Columns
What are Pair Wise & Non-Pair Wise Columns?
-
-
How to convert rows in column using SQL in Oracle
How to convert rows in column using SQL in Oracle;
for example
sl_no
1
2
3
4
output is 1234;
How to convert one column value into rows using SQL
for example
employee_name
Kumar
output
K
u
m
a
r -
Find manager for employee
ID employee department manager----------------------------------------------1 Suresh c++ NULL 2 Suresh c++ NUll3 Suresh c++ 25 Sarathy testing 26 Rajaraman c# 17 joe Flash 1I have the employee detail table ,In that i want to find the manager for each employee .The employee...
-
Select from table without using column name
How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let me know the answer
-
Avoid Data Duplication
If in a table we dont use primary key or any other unique key then how to avoid duplication of data?
-
-
Difference between an implicit & an explicit cursor.
PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including quries that return only one row. However,queries that return more than one row you must declare an explicit cursor or use a cursor FOR loop.Explicit cursor is a cursor in which the cursor name is explicitly assigned to a SELECT statement via the CURSOR...IS statement. An implicit cursor is used for all SQL statements...
Oracle SQL Interview Questions
Ans