Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 4474👍, 0💬
Popular Posts:
How To Retrieve Input Values for Checkboxes Properly? - PHP Script Tips - Processing Web Forms If mu...
What will be printed as the result of the operation below: main() { int a=0; if (a==0) printf("Cisco...
Can you have virtual functions in Java? Yes, all functions in Java are virtual by default. This is a...
What is the difference between RegisterClientScriptBloc kand RegisterStartupScript? RegisterClientSc...
How To Retrieve the Count of Updated Rows? - Oracle DBA FAQ - Working with Database Objects in PL/SQ...