Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Use SQL Statements in PL/SQL
How To Use SQL Statements in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL
✍: FYIcenter.com
SQL DML (Data Manipulation Language) statements can be included in PL/SQL code blocks directly without any changes. See the script below for examples:
SQL> CREATE TABLE tip (id NUMBER(5) PRIMARY KEY, 2 subject VARCHAR(80) NOT NULL, 3 description VARCHAR(256) NOT NULL); Table created. SQL> BEGIN 2 INSERT INTO tip VALUES(1, 'PL/SQL', 3 'Good for beginners.'); 4 UPDATE tip SET description = 'Good for beginners.'; 5 END; 6 / PL/SQL procedure successfully completed. SQL> COL subject FORMAT A12; SQL> COL description FORMAT A24; SQL> SELECT * FROM tip; ID SUBJECT DESCRIPTION ---------- ------------ ------------------- 1 PL/SQL Good for beginners. SQL> DROP TABLE tip; Table dropped.
This script example actually has 3 parts:
2007-04-25, 4712👍, 0💬
Popular Posts:
How can I execute a PHP script using command line? Just run the PHP CLI (Command Line Interface) pro...
What does a special set of tags <?= and ?> do in a PHP script page? <?= express...
.NET INTERVIEW QUESTIONS - How can you avoid deadlock in threading? A good and careful planning can ...
What are the different storage classes in C? C has three types of storage: automatic, static and all...
How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access...