S_NAME MARKS
ramu 60
ramu 40
ramu 50
karan 30
karan 96
karan 46

out put:
ramu "PASS"
karan "FAIL"

Elangovan

• Aug 13th, 2015

Code
 

Ritesh Kumar

• Mar 24th, 2015

"sql WITH t1 AS (SELECT name, COUNT ( result ) as tt_sub_pass FROM student WHERE result >= 40 group by name ...

Answer Question  Select Best Answer

How to retrieve odd and even number of rows from a table?

Sabbir

• Aug 17th, 2015

What programming language is this? Can you please provide this code in PHP ?

venkat

• Jun 27th, 2012

Code
 

union all

Code
 

Answer Question  Select Best Answer

Bharathiarun

• Aug 20th, 2015

Even if the Id is varchar, the rows are ordered by rownum.

Anand Prakash Joshi

• Aug 10th, 2015

Code
 

Answer Question  Select Best Answer

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...

Manjunath

• Sep 1st, 2015

Hello, Given example PL/SQL program is comes under Implicit, Bcz 1. if its Explicit then cursor has to be declared in declarative part along with SELECT statement to retrieve the data from Database ...

Justo

• Jul 15th, 2015

Its an implicit cursor.

Answer Question  Select Best Answer

How will you add additional conditions in SQL?

vikas patil

• Sep 25th, 2015

By using AND & OR

Answer Question  Select Best Answer

We have two type of constraints - Table Level and Column Level. Which is better and why..?

Mohit

• Oct 3rd, 2015

I think Table level contraints are imposed when we have to compare values in multiple columns,suppose delivery_date cannot be less than order_date..

abhilashnanupillai

 Profile Answers by abhilashnanupillai Questions by abhilashnanupillai

• Feb 20th, 2009

Constrains are the key word along with create table command. Different type of table constraints are primary key not null unique etc.

Answer Question  Select Best Answer

Bibhuprasad Behera

• Dec 4th, 2015

Can you please send me the example of the trigger?

Nivetha Thinakaran

 Profile Answers by Nivetha Thinakaran Questions by Nivetha Thinakaran

• May 5th, 2015

In an autonomous transactions, we can have commit inside trigger.

Answer Question  Select Best Answer

I am trying to get second highest age from the student table.Student table:SQL> desc student; Name Null? Type ----------------------------------------- -------- ----------------- ROLLNO NUMBER NAME VARCHAR2(20) AGE NUMBERAnd...

Sunil Badam

• Jan 29th, 2016

We can use rank function with partition by. It is very simple to use.

Code
 

Neeraj

• Jan 7th, 2016

Code
 

Answer Question  Select Best Answer

The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain the values that are passed to a procedure and receive results. Formal parameters are the placeholders for the values of actual parameters

srinivas

• Feb 6th, 2016

How can I differentiate local veritable and formal parameter? In class I have variable called a, in that class one method has formal parameter is "a" and another local variable also "a".

Ravindra Kumar

• Dec 7th, 2015

The actual parameter is when you actually pass real value in calling that function. And, the formal parameter is the parameter as defined on the function signature.

Answer Question  Select Best Answer

Hi,

Let us take a scenario such that I issue a delete on table emp and truncate on table emp1 which is exact replica (in terms of both structure and data) of emp table.Now , I issue a commit on both sessions.

If I do a select * from emp and select * from emp1 now, which one should execute faster and why?

sumanamara2016

 Profile Answers by sumanamara2016 Questions by sumanamara2016

• Mar 18th, 2016

TRUNCATE TRUNCATE does not return number of deleted rows. TRUNCATE TABLE always locks the table and page but not each row. DELETE When we have to use DELETE Command then the data deleted can be ...

Mohammad Mansoor

• Feb 24th, 2016

Truncate and Drop commands Rollback is not possible for Table, whereas Delete Command we rollback the Data

Answer Question  Select Best Answer

Write SQL Query to find the department (ID) wise counts in the company.
Schema "employee" contains "employee_id", "employee_name", "dept_id".

sumanamara2016

 Profile Answers by sumanamara2016 Questions by sumanamara2016

• Mar 18th, 2016

"sql WITH EMP2 AS( SELECT DEPTNO,COUNT(*) LASAL FROM EMP GROUP BY DEPTNO) SELECT E.EMPNO,E.ENAME,E.DEPTNO,E2.LASAL FROM EMP E ,(SELECT * FROM EMP2) E2 WHERE E.DEP...

M JAGADADEESH

• Mar 10th, 2016

Code
 

Answer Question  Select Best Answer

Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a CLUSTER. A CLUSTER provides a means for storing data from different tables together for faster retrieval than if the table placement were left to the RDBMS.

sumanamara2016

 Profile Answers by sumanamara2016 Questions by sumanamara2016

• Mar 18th, 2016

CLUSTERS A cluster is a schema object that contains data from one or more tables If you two are more tables are joined together on a single column and most of the time you issue join queries on ...

VIKRAM

• Dec 18th, 2015

In this case does the cluster avoid the JOIN Condition or not?

Answer Question  Select Best Answer

How to date track 2 tables to a previous month, using SQL code

suman

• Mar 18th, 2016

Date Track allows you to maintain a continuous history of the record or information over a period of time. You can use date track history to view a report of every update ever made to a record. Whene...

Answer Question  Select Best Answer

Query to select distinct values without using distinct

Ashok

• Mar 21st, 2016

There are four ways for this.
1. Using distinct keyword
2. Using group by on all columns
3. Using Union operator
4. Using Analytical functions

Akshay Kadam

• Mar 27th, 2015

SELECT DISTINCT LASTNAME FIRSTNAME
FROM EMP;

Answer Question  Select Best Answer

SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle database. SQL is a language used to query the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query result, Set options, Edit SQL commands and PL/SQL.

qptopm

 Profile Answers by qptopm Questions by qptopm

• May 12th, 2016

PL/SQL provides the capability of the programming language and supports the above mentioned list. It also supports running of SQL statements inside the PL/SQL blocks. SQL provides access to the database for retrieving data from the objects. However SQL does not have the programming capabilities.

Das

• Nov 4th, 2015

Simply put, like a command prompt in Windows Operating system, we have SQL PLUS tool in Oracle DBA.

Answer Question  Select Best Answer

Sampath Kumar

• May 24th, 2016

Does Oracle 12c supports these 12 Codd Rules

aaravindkumar

 Profile Answers by aaravindkumar Questions by aaravindkumar

• Dec 13th, 2007

The only rule that is not satisfied by oracle db is the systamatic treatment of NULL values. NULL in oracle is treated as absence of a value or unknown status (in case of comparision of values) and it...

Answer Question  Select Best Answer

SQL query to replace every alternate character in a string to capital.

Input string:- govardhana
I need output as gOvArDhAnA
And vice versa i.e, GOVARDHANA and required output as GoVaRdHaNa

Provide 2 separate queries for above scenarios

Vishnu

• Jun 23rd, 2016

Code
 

Vishnu

• Jun 23rd, 2016

For Instance consider EMP Table.

Code
 

Answer Question  Select Best Answer

Hi guys try this query

If any student fails in one subject also his result should be Faile r else Pass
condtion is(marks>=40 "PASS" marks

nancy

• Jul 19th, 2016

Code
 

SOnali

• Jun 29th, 2016

Select Name,
when Min(Mark)>40
Then Pass
Else Fail
End
From TableName
Group By Name

Answer Question  Select Best Answer

What is mean by Performance Tuning? Explain with example.

Akash S. Patil

• Nov 16th, 2016

Database tuning is a group of activities used to optimize the performance of the database. Goal of database tuning: 1. To maximize use of system resources. 2. To perform task as efficiently. 3. To wo...

Answer Question  Select Best Answer

It is a column that is not an actual column in the table.eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.

Amol Kulkarni

• Dec 3rd, 2016

Pseudo columns are used to pass additional information on a row. A pseudo column is not actually part of a row like any other columns. but exists due to the row property, they cannot be updated or mod...

qptopm

 Profile Answers by qptopm Questions by qptopm

• Nov 7th, 2016

It behaves like a table column, but is not actually stored in the table.

Answer Question  Select Best Answer