SOURCE SAVE Save the Source Code and Table and Index Structures using PL/SQL After having gone through some papers on this subject, the need for a robust system has to be developed plugging all the holes, is felt and the result is this. The basic idea and the first paper that has been seen is …
PL/SQL TUTORIALS – DYNAMIC SQL PL/SQL Tutorials – DYNAMIC SQL Within PL/SQL, you can execute any kind of SQL statement (even data definition and data control statements) without resorting to cumbersome programmatic approaches. Dynamic SQL blends seamlessly into your programs, making them more efficient, readable, and concise You need dynamic SQL in the following situations: …
ONLINE MOVE PARTITION EXAMPLES SQL> ALTER TABLE test1 MOVE PARTITION test1_PART1 ONLINE; Table altered SQL> ALTER TABLE test1 MOVE PARTITIONtest1_PART1 ONLINE UPDATE INDEXES; Table altered SQL> ALTER TABLE test1 MOVE PARTITIONtest1_PART1 ONLINE UPDATE GLOBAL INDEXES; Table altered Source: Oracle
MY FIRST PROGRAM PLSQL Tutorials – MY FIRST PROGRAM IN PL/SQL DBMS_OUTPUT This supplied package is an essential tool to debug the program written. So, use this and write your first program. This package prints the output of the program on to the screen. You will read about many important supplied packages as you go …
PL/SQL TUTORIALS – DYNAMIC SQL PL/SQL Tutorials – DYNAMIC SQL Within PL/SQL, you can execute any kind of SQL statement (even data definition and data control statements) without resorting to cumbersome programmatic approaches. Dynamic SQL blends seamlessly into your programs, making them more efficient, readable, and concise You need dynamic SQL in the following situations: …
ERROR AND EXCEPTION HANDLING PLSQL handles the errors caused at the server level and publishes them using the following functions: EXCEPTION Thisdatatype is declared in DECLARE section of the PLSQL code enables to call those as and when they are required. An internal exception is raised implicitly whenever your PL/SQL program violates an Oracle rule …
Copyright © 2002-2023 Srinivas Maddali, All rights reserved.