Basic Pl sql
Popular Posts
-
Thank you for your interest in my profile! Here is some detail about myself, in case you wondered. I am an Oracle Trainer working... -
An In_condition is a membership condition. it tests a value for membership in a list of values or subquery. The Condition defined using ...
-
1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, ora...
PLSQL INTERVIEW QUESTION
About Me
Thank you very much for your kind words and really happy that my little knowledge is helping you.plz contact hemalatatech@gmail.com for all training related queries
Popular Posts
-
Thank you for your interest in my profile! Here is some detail about myself, in case you wondered. I am an Oracle Trainer working...
-
An In_condition is a membership condition. it tests a value for membership in a list of values or subquery. The Condition defined using ...
-
1. Anonymous is unnamed plsql block A stored procedure or a named block is a pl/sql block. 2. Anonymous cannot save in database, ora...
-
CREATING MANUAL DATABASE Create the following directories in a folder where u want to create database: -- c:\oracl...
-
The Oracle PL/SQL EXIT statement is used to skip the current block. It can be used to terminate loops or stop processing based on a condit...
-
The oracle group by clause is used in a select statement to gather data across multiple records and group the results by one or more colum...
-
A record is a composite datatype, which means that it can hold more than one piece of information, as compared to a scalar datatype, such a...
-
declare v_foundrows boolean := false; begin for r in ( select * from employees where employee_id= &dno ) loop dbms_...
-
SQL ALTER TABLE Statement The SQL ALTER TABLE command is used to modify the definition (structure) of a table by modifying the definitio...
-
In this example , a Pl sql block attempts to divide by 0. Zero_divide is a predefined exception & it is used for to trap the error...
0 comments:
Post a Comment
Thank you for your comments we will get back to soon