Answer / nashiinformaticssolutions

A PL/SQL package contains related procedures, functions, variables, and other PL/SQL constructs. It consists of two main parts:
• Package Specification: This defines the public interface of the package, including procedures, functions, and global variables that other programs can access.
• Package Body: This contains the actual implementation of the functions and procedures defined in the specification.

Answer / glibwaresoftsolutions

A PL/SQL package contains related procedures, functions, variables, and other PL/SQL constructs. It consists of two main parts:
• Package Specification: This defines the public interface of the package, including procedures, functions, and global variables that other programs can access.
• Package Body: This contains the actual implementation of the functions and procedures defined in the specification.

Answer / hr@tgksolutions.com

A PL/SQL package contains related procedures, functions, variables, and other PL/SQL constructs. It consists of two main parts:
• Package Specification: This defines the public interface of the package, including procedures, functions, and global variables that other programs can access.
• Package Body: This contains the actual implementation of the functions and procedures defined in the specification.

How bulk collect improves performance?

0 Answers  

---

What is time based sql injection?

0 Answers  

---

Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;

2 Answers  

---

four procedures is are there should i write their in a package

2 Answers  

---

What are the different dml commands in sql?

0 Answers  

---

What is the source code of a program?

0 Answers  

---

What is a recursive stored procedure?

0 Answers  

---

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

---

What do we need to check in database testing?

0 Answers  

---

What is a boolean in sql?

0 Answers  

---

What are some predefined exceptions in pl/sql?

0 Answers  

---