-
Display Time in SQL
How to display current system time in SQL.
-
Bulk Data Operations
You are developing a PL/SQL block designed for bulk data operations. When attemping to store table data for multiple rows in a PL/SQL variable, which one of the following choices identifies the mechanism best suited for this task (choose one)? A. cursorB. varchar2C. recordD. table of records
-
Average Department Salary
How to Get the employee details whose salary is less than the average salary of the department.
-
Call SQL Script
How to call SQL script file from PL/SQL?
-
-
write a query to update third column such that
There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 303 30 10 304 35 25 355 20 40 40write a query to update column maxmarks such that maxmarks column contains whatever be the greater value among marks1...
-
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
-
Rename a Column
How to rename a column in a SQL table?
-
Oracle admin Scenario based question
I have applied the following commands:Shutdown abortstartupNow what will happen, will the database will give an error / it will work.
-
Online backup of a Control File
Can you take online backup of a Control File If yes, How?
-
-
-
-
-
-
-
SQL Query to find Nth maximum of Nth row?
1. Queries for Nth maximum Nth row?2. In One table there are 5 fields. empno, ename, deptcd, managr_id, salary.Select the departments whose sum of the salary greater than the sum of salaries of any department?3. When index will be usd in the Query?
-
-
-
-
-
-
What constitute an ORACLE Instance ?
SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
-
There is a % sign in one field of a column. What will be the query to find it?
'' Should be used before '%'.
-
There is a string 120000 12 0 .125 , how you will find the position of the decimal place?
INSTR('120000 12 0 .125',1,'.')output 13
-
-