Skip to main content

Posts

NOCOPY Parameter Hint in PL/SQL

Before we get to understanding the NOCOPY parameter hint in PL/SQL, it would help to first look at PL/SQL parameter modes and the ways in which they pass values in and out of a subprogram. PL/SQL subprograms have three parameter modes: IN parameter mode is used to send values into the subprogram from the calling program. An IN parameter can only be read, its value cannot be modified inside the subprogram. OUT parameter mode is used to return values from the subprogram to the calling program. IN OUT parameter mode is a hybrid of IN and OUT. It is used to send values into the subprogram, and its value can be modified within the subprogram. On exit, the subprogram returns the updated value of the IN OUT parameter to the calling program.  Continue reading at Source :  NOCOPY Parameter Hint in PL/SQL
Recent posts

Mounting a Windows 8.1 partition on Ubuntu 14.04

If u guys have a problem mounting a Windows 8.1 partition on Ubuntu 14.04 , Here's a Quick fix that worked for me : Disable the default hibernation mode by using CMD program as administrator – Boot into Windows and type “cmd” in the search field on the built-in Windows search app >> launch the app and type: powercfg -h off >> press enter and your done.

Sublime Text 3 Ubuntu 14.04 Licence

Sublime Text 3 Ubuntu 14.04 —– BEGIN LICENSE —– Nicolas Hennion Single User License EA7E-866075 8A01AA83 1D668D24 4484AEBC 3B04512C 827B0DE5 69E9B07A A39ACCC0 F95F5410 729D5639 4C37CECB B2522FB3 8D37FDC1 72899363 BBA441AC A5F47F08 6CD3B3FE CEFB3783 B2E1BA96 71AAF7B4 AFB61B1D 0CC513E7 52FF2333 9F726D2C CDE53B4A 810C0D4F E1F419A3 CDA0832B 8440565A 35BF00F6 4CA9F869 ED10E245 469C233E —— END LICENSE ——