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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

can we call a procedure from a function?

Mind Tree,

9 16486

how to sort records in sql?

 3 5612

what is the difference between implicit and explicit trigger

Tech Mahindra,

2 20179

can we delete the trigger in a view? if yes why if not why?

Tech Mahindra,

5 13062

What is mutating trigger?How to avoid it??

Tech Mahindra,

3 11866

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

 6 19139

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

IBM,

11 13596

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

Satyam,

14 31403

what will be the output: select 1 from emp union all select 2 from emp;

iNautix,

2 11866

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 23265

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

Cap Gemini, iNautix,

23 41445

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

IBM,

4 9417

if a table is getting updated what happens if a function is called from sql query?

RBS,

2 7766

how can create data base link for tow servers (scott schema) give examples plz

 2 3984

using comand prompt how can import table data and table space with example

 2 4254

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is sql comments?

508

Is sql a oracle?

372

What is the purpose of a sql?

373

What is procedure in pl sql?

376

What is nvarchar in sql?

365




How do I write a sql query in pgadmin 4?

407

How can a pl sql block be executed?

371

What is data profiling in sql?

363

Why is nosql good?

388

Is pl sql better than sql?

382

How bulk collect improves performance?

381

Does truncate require commit?

379

What is a column in a table?

375

Can dml statements be used in pl/sql?

425

What is a pl/sql block?

435

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