-
Display your name 10 times in PL/SQL
Write a PL/SQL anonymous block with exception handling to print your name 10 times?
-
What is a cursor ? Why Cursor is required ?
Cursor is a named private SQL area from where information can be accessed. Cursors are required to process rows individually for queries returning multiple rows.
-
-
-
ORA-01756: quoted string not properly terminated
Hi Can anyone explain what this mean? I have practise PL/SQL about REF obj_type, my codes are: CREATE or REPLACE TYPE home_type AS OBJECT (street VARCHAR2(50), city VARCHAR2(20), state VARCHAR2(20), zipcode VARCHAR2(6), owner VARCHAR2(10));/CREATE TABLE homes OF home_type;INSERT INTO homes VALUES ('300 Regina St', 'WATERLOO', 'ON', '010010', 'HFWANG');INSERT INTO homes VALUES ('301 Regina St', 'WATERLOO',...
-
Validate String as Alphanumeric
Write a PLSQL function that accepts some text and validates that the text has only Alphanumeic characters and returns true else returns false
-
What is difference between a PROCEDURE & FUNCTION ?
A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.
-
-
Performance Issue: Gathering Statistics- dbms_stats
What are the advantages of Gathering Statistics?
-
Procedure Vs Function
Explain when do we use a Procedure and when do we prefer using functions.
-
RANK TRANSFORMATION TYPE and RANGE by PARTITION
Difference between RANK TRANSFORMATION TYPE and RANGE by PARTITION. Simple Code in loading data into FACT Table using the above Two methods
-
Why do we need Package?
If I create N number of small procedures with one PL/SQL block (or) procedure why we need package?
-
-
How do you set table for read only access ?
if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible
-
What is Simple Cursor? and What is Parametrized cursor?
Explain what is Simple Cursor and What is Parameterized Cursor? And Difference between both??
-
-
Create Package body with one private subprogram only without package specification
Case 1:
Create package with body only it contains only one private sub program
CREATE PACKAGE BODY no_spec AS
PROCEDURE myproc AS BEGIN null;
END;
END no_spec;
/
Case 2:
Create package with body only it contains no sub programs
CREATE PACKAGE BODY no_spec AS
END no_spec;
/ -
-
Global Temporary Table
What is Global temporary table? and what are the benefits of it?
-
Hidden Package
How can we hide a package from other users?
PL/SQL Interview Questions
Ans