Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 5418

List the differences between plsql - function & procedures

TCS, Verizon,

2 5432

How do you retrieve the last N records from a table?

10 13626

Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 11159

What is pl/sql tables?

TCS,

7 7891

What is a mutating table

TCS, Tech Mahindra,

5 7308

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott

3 4036

what is the Default Libraries for Oracle Report 6i

IBM,

1455

What is the Diff b/w Constraints and Trigeer

HCL,

4 9521

If the base table structure is changed what will happen to join index????

2 4872

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 5826

what is the different between unique+not null & primary key,

4 5289

How do u count no of rows in a table?

CTS,

8 11115

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 2636

what is sql.

Ericsson, Hewitt,

6 6154


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

how many tables will create when we create table, what are they? : Sql dba

166


How delete all data from all tables in sql?

157


what are all different types of collation sensitivity? : Sql dba

175


Why use truncate instead of delete?

132


Which is faster subquery or join?

159






what are null values? : Sql dba

165


what is timestamp in mysql? : Sql dba

165


Can a table contain multiple foreign key’s?

162


does sql support programming? : Sql dba

181


what is text? : Sql dba

172


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

1536


What does truncate mean in sql?

144


What is column?

164


Can we create view in stored procedure?

151


What does select top 1 do in sql?

149