Tell me about your self? 11g features? What are the issues you faced in using Cursors? What is varry and nested tables? How the query executed?? Write a query to display even/odd number from a table.? What is the exception?explain raise_application error?...
Oracle 11g New Features Today I will cover some of the new features of Oracle 11g for developers. 1. The new REGEXP_COUNT function returns the number of times the search pattern appears in source string. 2. SIMPLE_INTEGER Datatype The SIMPLE_INTEGER datatype...
Tell me about your self? Which version database using in your company? Can you please major differences in oracle 11h,12c ? What does instr () and substr () returns. Write syntax for both? Write a query to delete duplicate rows from a table? Can use dml...
1. EXPLAIN CONSTRAINTS? 2.WHAT IS CHECK CONSTRAINT? WHEN YOU USE THAT? 3.DEFINE VIEW? DIFFERENCE BETWEEN WHERE CLAUSE AND HAVING CLAUSE? 5.WHAT IS INDEX USE OF INDEXES? 6.WHAT IS TOP CLAUSE? 5.WHAT IS WILD CARD EXPLAIN? 7.GOALS OF NORMALIZATION? DIFFERENCE...
1 . What are the Forward Declarations? PL/SQL is rather fussy about its requirement that you declare a variable, cursor, or module before you use it in your code. Otherwise, how can PL/SQL be sure that the way you are using the object is appropriate?...
