Follow Our FB Page << >> 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?


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



What is the Diff b/w Constraints and Trigeer


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?


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


How delete all data from all tables in sql?


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


Why use truncate instead of delete?


Which is faster subquery or join?


what are null values? : Sql dba


what is timestamp in mysql? : Sql dba


Can a table contain multiple foreign key’s?


does sql support programming? : Sql dba


what is text? : Sql dba


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


What does truncate mean in sql?


What is column?


Can we create view in stored procedure?


What does select top 1 do in sql?