Q&A Categories

PL-SQL

You have compiled some PL/SQL packages in your schema, and found aome errors in one procedure.how do

You have compiled some PL/SQL packages in your schema, and found aome errors in one procedure.how do you find which procedure produced the error?how do you find which section of the code produced the error...

Answers No Answers In: PL-SQL By: vikas [ Grey Star Level] Sep 8, 2010

Write sample code that can create a hierachical set of data without using a start with and connect by

Write sample code that can create a hierachical set of data without using a start with and connect by clause in PL/SQL '

Answers No Answers In: PL-SQL By: ramesh [ Grey Star Level] Sep 7, 2010

Write  the  order  of precedence for validation of a column in a table ?

Write  the  order  of precedence for validation of a column in a table ?           I.  done using Database triggers.         ...

Answers No Answers In: PL-SQL By: ramesh [ Grey Star Level] Sep 7, 2010

Writing Pl/SQL function

Writing Pl/SQL function Write a PL/SQL fuction named say TRUN, which does the same work as the oracle predefined function "TRUNCATE".'

Answers No Answers In: PL-SQL By: sunil [ Grey Star Level] Sep 7, 2010

Without closing the cursor, If you want to open it what will happen. If error, get what is the error?

Without closing the cursor, If you want to open it what will happen. If error, get what is the error? '

Answers No Answers In: PL-SQL By: faiz [ Grey Star Level] Sep 7, 2010

Why we use instead of trigger. what is the basic structure of the instead of trigger. Explain specific

Why we use instead of trigger. what is the basic structure of the instead of trigger. Explain specific business reason of it's use '

Answers No Answers In: PL-SQL By: sam [ Grey Star Level] Sep 7, 2010

Why Functions are used in oracle ?Can Functions Return more than 1 values?Why Procedures are used in

Why Functions are used in oracle ?Can Functions Return more than 1 values?Why Procedures are used in oracle ?What are the Disadvantages of packages?What are the Global Variables in Packages? '

Answers No Answers In: PL-SQL By: @mahesh@ [1 Grey Star Level] Sep 6, 2010

Why do we need to create a force view?what is its purpose?give some examples?

Why do we need to create a force view?what is its purpose?give some examples? '

Answers No Answers In: PL-SQL By: yogesh [ Grey Star Level] Sep 6, 2010

Why DUAL table is not visible?

Why DUAL table is not visible? '

Answers No Answers In: PL-SQL By: bipin [ Grey Star Level] Sep 6, 2010

Which type of binding does PL/SQL use?

Which type of binding does PL/SQL use? '

Answers No Answers In: PL-SQL By: rakesh [ Grey Star Level] Sep 5, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]