Answer / Bhudev Singh

PL/SQL (Procedural Language SQL) is a procedural extension of the SQL language used by Oracle Database Management System. The main differences between SQL and PL/SQL include:
1. Procedural features: PL/SQL supports variable declarations, loops, conditional statements, exception handling, functions, packages, etc.
2. Execution context: SQL is used for querying or manipulating data within the database, while PL/SQL is used to create stored procedures and functions that can perform complex tasks and multiple database operations.
3. Statements: SQL consists of standalone statements (DDL, DML, DCL), while PL/SQL contains both standalone statements and blocks of code enclosed within BEGIN and END keywords.

What are the two types of exceptions in pl/sql?

1 Answers  

---

Explain the difference between triggers and constraints?

1 Answers  

---

What is an inconsistent dependency?

1 Answers  

---

Why trigger is used in sql?

1 Answers  

---

What is vector point function?

1 Answers  

---

How do I save a stored procedure?

1 Answers  

---

what is sp_pkeys? : Transact sql

1 Answers  

---

How to sort the rows in sql.

1 Answers  

---

How can we implement rollback or commit statement in a trigger?

1 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

what is a constraint? : Sql dba

1 Answers  

---

what is bcp? When does it used? : Sql dba

0 Answers  

---