TOO_MANY_ROWSORA-01422When you use SELECT in a PL/SQL block, it's important to make sure that exactly one row will always be returned by your query. ... If more than one row is returned, the TOO_MANY_ROWS exception occurs.Single row SELECT returned more than one row.Example:create or replace procedure pro1(deptno in number)DECLARE V_NAME...
Wednesday, November 24, 2021
What is Exception Handling in PL/SQL?
What is Exception Handling in PL/SQL?An exception occurs when the PL/SQL engine encounters an instruction which it cannot execute due to an error that occurs at run-time. These errors will not be captured at the time of compilation and hence these needed to handle only at the run-time.For example, if PL/SQL engine receives an instruction to divide...
Friday, January 8, 2021
Functions in Plsql/Sql
Trim :- Removes leading and /or trailing blanks(or other characters ) from a string.Syntax:- TRim([[<trim_spec >] char ]SQL> select trim(' Aptech Computer') from dual;Returns the following result.TRIM('APTECHCOM---------------Aptech ComputerConcate Function:--The syntax for the oracle concat function is :concat(string1,string2)Parameters...
Saturday, December 5, 2020
Hiw to create job schedulers in plsql Oracle
A user with a Create any job privilege can create a job in any schema except the sys schema. Attaching a job with a particular class requires the execute privileges for that class.Oracle database 10g offers a collection a rich set of functionality for complex scheduling tasks.The component that causes something to be executed at a specified time...
Forgot sys password in Oracle how to solve
Hi,Log on to your Windows server as a member of the Administrators group or a member of the ORA_DBA group.Try the below stepsMicrosoft Windows [Version 6.1.7601]Copyright (c) 2009 Microsoft Corporation. All rights reserved.C:\Users\NIIT>set oracle_sid=orclC:\Users\NIIT>sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Mon Jan...
Friday, July 12, 2019
Open Cursor in plsql
What is CURSOR in PL/SQL?
A Cursor is a pointer to this context area. Oracle creates context area for processing an SQL statement which contains all information about the statement.
PL/SQL allows the programmer to control the context area through the cursor. A cursor holds the rows returned by the SQL statement. The set of rows the cursor holds...