SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Can we use threading in pl/sql?

607

Difference between table function and pipelined function?

676

What is the difference between explicit and implicit cursors in oracle?

601

How to convert comma separated string to array in pl/sql?

696

How to raise user-defined exception with custom sqlerrm ?

763

Can you select everything, but 1 or 2 fields, without writer's cramp?

588

Does oracle roll back the transaction on an error?

622

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

764

What is the difference between function and procedure in pl/sql?

634

How can I get the number of records affected by a stored procedure?

667

How to return an array from java to pl/sql?

686

what is table? : Sql dba

678

what is text? : Sql dba

664

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

730

how to use myisamchk to check or repair myisam tables? : Sql dba

601


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain the difference between triggers and constraints?

603


What is the largest value that can be stored in a byte data field?

601


What is your daily office routine?

1895


describe transaction-safe table types in mysql : sql dba

597


What is the purpose of a sql?

606






What is set serveroutput on?

741


what is the difference between char and varchar data types? : Sql dba

627


What can sql server reporting services do?

691


What are the different schemas objects that can be created using pl/sql?

624


What found sql?

598


What is a heap in sql?

623


How can a pl sql block be executed?

612


What packages(if any) has oracle provided for use by developers?

5153


what is csv? : Sql dba

669


Which is better join or subquery?

700