1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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 7462

List the differences between plsql - function & procedures

TCS, Verizon,

2 6364

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

 10 15772

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

 6 12663

What is pl/sql tables?

TCS,

7 10086

What is a mutating table

TCS, Tech Mahindra,

5 9217

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

3 5017

what is the Default Libraries for Oracle Report 6i

IBM,

1824

What is the Diff b/w Constraints and Trigeer

HCL,

4 10983

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

 2 5654

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 7002

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

 4 6361

How do u count no of rows in a table?

CTS,

8 13485

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 3256

what is sql.

Ericsson, Hewitt,

6 8080

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are different types of keys?

515

What is the difference between row level and statement level trigger?

506

Differentiate between syntax and runtime errors.

627

How to run sql statements through the web interface?

499

How do I view an execution plan in sql?

518




What is a full join?

517

Can we call procedure in select statement?

510

Show how functions and procedures are called in a pl/sql block.

575

What does an inner join do?

545

How many tables can you join in sql?

520

What are the possible values for the boolean data field?

507

How do I view output in sql developer?

561

what is a stored procedure? : Sql dba

536

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

606

What are joins in sql?

522

For More Un-Answered { SQL PLSQL } Questions Click Here