SQL PLSQL Interview Questions
Questions Answers Views Company eMail

can i write pl/sql code in a package

2 5750

can i give user defined exception in a package

2 6333

after tell procedure whole code he asked can i write the same way in a function

3 4473

can i use dbms_output.put_line in a function u are telling as return statement

7 15942

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 3968

difference between cursor and procedure in a package

PCS,

3 28036

difference between oracle 8i and oracle 9i

8 23555

full outer join syntax

5 7006

what is called after appearing where clause

3 5168

how can i create a user defined datatype

3 6326

how can i read write files from pl/sql

3 8222

what is global variable in pl/sql

1 10902

can i call procedure in package

TCS,

3 8767

four procedures is are there should i write their in a package

2 5245

package specification-3 procedures package body-2 procedures will is execute

PWC,

2 9577


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is view explain with example?

518


what does it mean to have quoted_identifier on? : Sql dba

678


What do you mean by table in sql?

525


what is sub-query? : Transact sql

597


Which query operators in sql is used for pattern matching?

543






What are the most important characteristics of pl/sql?

576


Which are the different case manipulation functions in sql?

538


which types of join is used in sql widely? : Sql dba

539


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3238


What does where 1/2 mean in sql?

530


How run sql*plus commands that are stored in a local file?

520


How do you use a while loop in pl sql?

539


how to start mysql server? : Sql dba

613


What does select count (*) mean in sql?

549


Explain ddl statements in pl/sql?

578