Sales Tel: +63 945 7983492  |  Email Us    
SMDC Residences

Air Residences

Features and Amenities

Reflective Pool
Function Terrace
Seating Alcoves

Air Residences

Green 2 Residences

Features and Amenities:

Wifi ready study area
Swimming Pool
Gym and Function Room

Green 2 Residences

Bloom Residences

Features and Amenities:

Recreational Area
2 Lap Pools
Ground Floor Commercial Areas

Bloom Residences

Leaf Residences

Features and Amenities:

3 Swimming Pools
Gym and Fitness Center
Outdoor Basketball Court

Leaf Residences

Contact Us

Contact us today for a no obligation quotation:

+63 945 7983492
+63 908 8820391

Copyright © 2018 SMDC :: SM Residences, All Rights Reserved.

1Z0-101 dumps with Real exam Questions and Practice Test -

Great Place to download 100% free 1Z0-101 braindumps, real exam questions and practice test with VCE exam simulator to ensure your 100% success in the 1Z0-101 -

Pass4sure 1Z0-101 dumps | 1Z0-101 real questions |

1Z0-101 Develop PL/SQL Program Units

Study Guide Prepared by Oracle Dumps Experts

Exam Questions Updated On : 1Z0-101 Dumps and Real Questions

100% Real Questions - Exam Pass Guarantee with High Marks - Just Memorize the Answers

1Z0-101 exam Dumps Source : Develop PL/SQL Program Units

Test Code : 1Z0-101
Test Name : Develop PL/SQL Program Units
Vendor Name : Oracle
: 142 Real Questions

determined those most 1Z0-101 Questions in actual take a look at that I exceeded. tackled all my issues. Thinking about lengthy question and answers become a test. In any case with concise, my making plans for 1Z0-101 exam changed into without a doubt an agreeable revel in. I efficaciously passed this exam with 79% marks. It helped me remember without lifting a finger and solace. The Questions & answers in are fitting for get organized for this exam. A whole lot obliged in your backing. I could consider for lengthy really at the same time as I used killexams. Motivation and extremely good Reinforcement of inexperienced persons is one subject remember which i found difficult buttheir help make it so easy.

it's miles remarkable to have 1Z0-101 real exam questions.
A few good men cant bring an alteration to the worlds way but they can only tell you whether you have been the only guy who knew how to do this and I want to be known in this world and make my own mark and I have been so lame my whole way but I know now that I wanted to get a pass in my 1Z0-101 and this could make me famous maybe and yes I am short of glory but passing my A+ exams with was my morning and night glory.

Found an accurate source for real 1Z0-101 dumps.
I got 76% in 1Z0-101 exam. Way to the team of for making my effort so easy. I advocate to new customers to put together thru as its very complete.

frightened of failing 1Z0-101 examination!
I distinctly advocate this package deal to anyone planning to get 1Z0-101 q and a. Exams for this certification are difficult, and it takes a variety of work to pass them. does most of it for you. 1Z0-101 exam I got from this internet site had most of the questions provided throughout the exam. Without these dumps, I suppose I could fail, and this is why such a lot of people dont skip 1Z0-101 exam from the first strive.

it's miles great idea to memorize the ones 1Z0-101 present day dumps.
I cleared 1Z0-101 exam with excessive marks. Every time I had registered with which helped me to attain more marks. Its extraordinary to have help of questions and answers for such kind of test. Thanks to all.

Prepare these questions otherwise Be prepared to fail 1Z0-101 exam.
I am happy to tell that I have successfully passed the 1Z0-101 Exam. In this context I need to admit that your Question Bank did help (if now not fully) to tied over the exam because the questions asked in the exam had been now not absolutely blanketed with the aid of your questions bank. HOwever I need to congratulate your attempt to make us technically sound together with your s. Thanks to for clearing my 1Z0-101 exam in first elegance.

Real 1Z0-101 exam Questions to Pass exam at first attempt. materials are precisely as outstanding, and the percent spreads all that it need to blanket for an in depth exam making plans and i solved 89/one hundred questions using them. I got each certainly one of them by making plans for my tests with and exam Simulator, so this one wasnt an exemption. I am able to guarantee you that the 1Z0-101 is a ton harder than beyond checks, so get ready to sweat and tension.

Did you tried this great source of 1Z0-101 latest dumps.
attempted loads to clear my 1Z0-101 exam taking help from the books. however the difficult motives and toughinstance made things worse and i skipped the check two times. subsequently, my quality pal suggested me the question& solution by way of And agree with me, it worked so well! The quality contents were brilliant to go through and apprehend the subjects. I should without problems cram it too and answered the questions in barely a hundred and eighty minutes time. Felt elated to skip rightly. thanks, dumps. thanks to my cute pal too.

1Z0-101 bank is required to pass the exam at first attempt.
Heres yet another vote for because the pleasant manner to put together for 1Z0-101 exam. I opted for this kit to prepare for my 1Z0-101 exam. I didnt set my hopes too high and saved an eye fixed on the professional syllabus to ensure I do not pass over any subjects, and it turned out that had them all covered. The practise became very strong and i felt confident at the exam day. And what in reality made high-quality become the moment when Ifound out their questions were exactly similar to what actual exam had. simply as promised (which I didnt in reality count on to be authentic - you know the way it really works from time to time!). So, that is extraordinary. Dont hesitate, go for it.

preparing 1Z0-101 exam is rely of some hours now.
I had taken the 1Z0-101 instruction from the as that modified into a nice platform for the training and that had ultimately given me the fine degree of the steerage to get the splendid scores inside the 1Z0-101 take a glance atchecks. I simply loved the manner I got the topics completed within the interesting manner and through the help of the identical; I had in the long run had been given the detail on the line. It had made my guidance a good buy less complex and with the help of the I were capable of develop well within the existence.

Oracle Develop PL/SQL Program Units

Oracle PL/SQL Programming, sixth version | Real Questions and Pass4sure dumps

writer: Steven Feuerstein with invoice PrybilPublisher: O'Reilly, 2014Pages: 1392ISBN: 978-1449324452Aimed at: Oracle developersRating: 5Reviewed with the aid of: Kay Ewbank

this is a new version of Steven Feuerstein’s classic book on Oracle PL/SQL programming.

As such it wants little or no introduction to the Oracle developer community; it will be unusual to discover a bookshelf belonging to an Oracle developer without this publication on it, and it deserves its area, having been probably the most useful booklet on the discipline for the ultimate twenty years. This newest version brings the book up thus far with Oracle Database 12c free up 1.

here's no easy read, both in length or in content. It’s not a tutorial with the aid of any capability, but Feuerstein explains the internal workings of PL/SQL with a lot of code examples. He has a brilliant writing trend and makes use of humor and an easy chatty vogue to make the manner of knowing PL/SQL as painless as possible. through the years and variations diverse authors have co-authored with Feuerstein; this edition is written with invoice Prybil, notwithstanding actually a considerable number of chapters have been authored or co-authored with the aid of distinct writers, each and every taking their personal area of talents. One aspect to be aware is that Feuerstein does count on you be aware of Oracle’s edition of SQL, so if you’re coming to the book from a different history such as T-SQL, you’ll should get up to velocity with Oracle SQL first to make the most of this booklet.


if you’re not frequent with the publication, the crucial factor is that it covers every thing from the fundamentals of the language through application constitution, coping with records, SQL in PL/SQL, constructing purposes, to advanced PL/SQL issues reminiscent of software security and using Java from PL/SQL. There are extensive guidance on the way to write first rate code, hints on where issues could turn up, and assistance of the way to optimize your solutions. once the language has been delivered within the first ingredients of the ebook, later chapters seem greater at selected issues and reveal a way to clear up them with descriptions and dialogue of why a selected route has been chosen. in many situations you’re shown an instance written in a single method, then modified to utilize a particular characteristic or concept to demonstrate you the way it alters the style you're employed and the way you code for it.

The leading alterations between this edition and the outdated one are information on the adjustments to Oracle 12C, starting with the ACCESSIBLE_BY clause, which specifies which software instruments in a kit are allowed to invoke subprograms. This skill subprograms are with no trouble hidden from all other software gadgets except you say otherwise.

a different trade that’s coated is BEQUEATH CURRENT_USER for views. This means which you can furnish roles to particular person PL/SQL programs and standalone classes. BEQUEATH CURRENT_USER acts as even though it were an invoker rights unit.

the new conditional compilation directives are defined, as are the two new ways of enhancing PL/SQL characteristic performance – WITH function and including the UDF pragma to the program unit.

As that you would be able to probably inform from this listing, the changes from the outdated version are fairly particular and except you’re battling knowing them in particular, you could be happy along with your fifth version. if you don’t have an previous edition and also you need to software PL/SQL, here is the book to buy. 

Oracle's newest PL/SQL function 'purchasable with the aid of' | Real Questions and Pass4sure dumps

Oracle has offered programs for a while now, but until recently it's been complicated, if not impossible, to keep away from 'out of context' execution of features and procedures; in many circumstances equipment code is designed to be used in the context of the kit, now not as stand-alone methods and services. In free up, Oracle has addressed this difficulty with the accessible by means of clause. This clause allows developers to refine the scope of a system or feature name and generate an error message when that method or feature is referred to as outside of the equipment context. Let's construct an illustration for example how this is written and what effects are acquired when the context-restrained code is done in context and out.

accessible by using can hinder certain styles of program units or named application gadgets of an unspecified class. The syntax for the clause is:

accessible with the aid of ([unit_kind] [schema.]unit_name)

...where [unit_kind] is an non-compulsory parameter indicating technique, characteristic, package, trigger or category, [schema] is the schema the place the unit is determined and unit_name is the identify of the technique, feature or equipment having constrained entry. When [unit_kind] is offered then a particular kit, procedure, feature, trigger or type can best be known as or used from within the defined context. When [unit_kind] isn't supplied then any of the listed kinds may also be referenced provided that they've the declared unit_name. they are going to start with an access by using name illustration:

SQL> -- SQL> -- Create a method only attainable SQL> -- by way of a named itemSQL> -- SQL> -- Object can have any supported class SQL> -- SQL> create or change technique my_restrict_proc 2 purchasable by using (restrict_fc) three as 4 start 5 dbms_output.put_line('executed my_restrict_proc.'); 6 conclusion; 7 / process created. SQL> SQL> -- SQL> -- Create a characteristic most effective purchasable SQL> -- by means of a triggerSQL> -- SQL> create or change feature top_protected_f return number 2 obtainable by means of (set off restrict_fc ) as 3 begin four return 1.27349; 5 end top_protected_f; 6 / function created. SQL> SQL> -- SQL> -- Create a feature SQL> -- SQL> -- function calls the technique that may name SQL> -- the unit having the confined nameSQL> -- SQL> create or change feature restrict_fc RETURN number AUTHID DEFINER IS 2 function g RETURN quantity DETERMINISTIC IS 3 begin 4 RETURN 1.27349; 5 conclusion g; 6 start 7 my_restrict_proc; eight RETURN g() - DBMS_RANDOM.value(); 9 conclusion restrict_fc; 10 / characteristic created. SQL> SQL> -- SQL> -- Execute the function SQL> -- SQL> select restrict_fc FROM twin; RESTRICT_FC ----------- .78662621 done my_restrict_proc. SQL>

for the reason that they didn't are attempting to bypass the 'security' they worked to enforce the limited code accomplished devoid of error. notice that they weren't required to declare any unit_kind in the preliminary attainable by using clause, which allowed us to declare the unit_kind in a different PL/SQL software unit 'down the road'; this makes it less difficult in programs to put in writing an available through clause that can also be reused in different packages or stand-by myself procedures that use objects of the equal identify but having diverse unit_kind definitions.

Let's now look at a equipment that includes each public (executable with the aid of any person in any context) and personal (executable best by means of the declared program unit) methods and spot what happens when an attempt is made to execute the 'private' method backyard of its declared context:

SQL> SQL> set echo on linesize a hundred and fifty serveroutput on size 1000000 SQL> SQL> -- SQL> -- Create a package with public and private approaches SQL> -- SQL> create or exchange kit my_top_lvl_pkg as 2 method my_first_lvl_proc; three process my_next_lvl_proc accessible by way of (manner my_top_lvl_proc); four end my_top_lvl_pkg; 5 / equipment created. SQL> SQL> show errors No blunders. SQL> SQL> -- SQL> -- outline those approaches and who/what can access them SQL> -- SQL> create or exchange package body my_top_lvl_pkg 2 as 3 method my_first_lvl_proc as four start 5 dbms_output.put_line('achieved my_top_lvl_pkg.my_first_lvl_proc'); 6 end; 7 system my_next_lvl_proc purchasable by means of (process my_top_lvl_proc) as eight start 9 dbms_output.put_line('accomplished my_top_lvl_pkg.my_next_lvl_proc'); 10 end; 11 end; 12 / equipment physique created. SQL> SQL> reveal error No errors. SQL> SQL> -- SQL> -- Create process to execute both package methods SQL> -- SQL> create or substitute process my_top_lvl_proc 2 as three begin four dbms_output.put_line('my_top_lvl_proc calls my_top_lvl_pkg.my_next_lvl_proc '); 5 my_top_lvl_pkg.my_next_lvl_proc; 6 end; 7 / manner created. SQL> SQL> display blunders No errors. SQL> SQL> -- SQL> -- Execute methods as intended, from in the equipment SQL> -- SQL> exec my_top_lvl_proc; my_top_lvl_proc calls my_top_lvl_pkg.my_next_lvl_proc completed my_top_lvl_pkg.my_next_lvl_proc PL/SQL method efficiently achieved. SQL> SQL> SQL> -- SQL> -- are attempting to call included technique stand-on my own SQL> -- SQL> exec my_top_lvl_pkg.my_next_lvl_proc; start my_top_lvl_pkg.my_next_lvl_proc; end; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00904: insufficient privilege to entry object MY_NEXT_LVL_PROC SQL>

We see that any try and execute MY_NEXT_LVL_PROC with the aid of itself generates an error, which continues it in the desired context in order that undesired effects cannot be generated. [As mentioned before some procedures and functions in a package can rely on variables and intermediate results generated by program units within that package; executing program units with such dependencies as 'stand-alone' program units can produce incorrect results.]

Being capable of prevent the execution atmosphere on PL/SQL program instruments that count on definite conditions to be met is a long past due feature that should be investigated and used via builders. no longer will programmers ought to clarify why a method or function would not work appropriately when called outdoor of its intended ambiance; it effectively might not execute outdoor of the mandatory context. And, to cite Martha Stewart, "it truly is a good issue."

See all articles by way of David Fitzjarrell

PL/SQL Developer makes Oracle less difficult to make use of | Real Questions and Pass4sure dumps

As many builders will attest, Oracle's database utilities can be elaborate to work with. however a new shareware program called PL/SQL may additionally make it less demanding to increase and configure apps using Oracle. This product evaluate examines PL/SQL's capabilities.

via Stuart Vessels

Wouldn’t or not it's quality if you may edit an Oracle database desk directly inside a spreadsheet-like grid, the manner that you would be able to in access and Microsoft SQL’s business manager? As many Oracle clients are painfully aware, the database equipment doesn't offer an app that permits you to display the consequences of a question within an editable grid. The closest device Oracle presents is its SQL Plus utility, which is in fact a command prompt for executing SQL statements. The results are not in a grid, and they’re now not editable.

happily, there’s a advantageous and simply attainable third-birthday party shareware utility that offers a grid-like interface for viewing and editing Oracle tables. The product, proven in figure A, is PL/SQL Developer. It’s produced by Dutch software enterprise Allround Automations.

NotePL/SQL Developer will run on windows ninety five and windows NT 4 or later. To hook up with an Oracle database, PL/SQL Developer requires any 32-bit SQL*net or Net8 version.

actually, PL/SQL Developer is a great deal greater than simply an Oracle table editor. It’s an integrated building environment that has an unbelievable assortment of points designed to make it more convenient to increase, test, debug, and optimize Oracle PL/SQL-saved software gadgets, equivalent to applications and triggers.

however you don’t need to be a developer to respect PL/SQL Developer’s SQL Window. you can use this device to monitor the outcomes of any SQL observation in an editable grid, as proven in determine B. once you edit a field entry or add a new listing, you commit the change to the database through clicking the Commit icon. The SQL Window even permits you to opt for and copy data, columns, or rows. you could then use this approach to stick new records into a table, or you can paste the records into an Excel or observe file. Of path, there’s a menu command for exporting query outcomes to a lot of generic file codecs, corresponding to Excel or be aware. additionally, the program remembers the SQL statements you execute by means of storing them in a historical past buffer. Recalling previously accomplished SQL statements is as easy as looking a listing and clicking on the one you desire.

The SQL Window is barely the tip of the iceberg. PL/SQL Developer has many greater tools and lines so that you can attraction to developers and database directors. to see simply how potent this software can be, check out Allround Automations complete aspects list.

Unquestionably it is hard assignment to pick dependable certification questions/answers assets regarding review, reputation and validity since individuals get sham because of picking incorrectly benefit. ensure to serve its customers best to its assets concerning exam dumps update and validity. The vast majority of other's sham report dissension customers come to us for the brain dumps and pass their exams joyfully and effortlessly. They never trade off on their review, reputation and quality on the grounds that killexams review, killexams reputation and killexams customer certainty is imperative to us. Uniquely they deal with review, reputation, sham report objection, trust, validity, report and scam. On the off chance that you see any false report posted by their rivals with the name killexams sham report grievance web, sham report, scam, protest or something like this, simply remember there are constantly awful individuals harming reputation of good administrations because of their advantages. There are a huge number of fulfilled clients that pass their exams utilizing brain dumps, killexams PDF questions, killexams hone questions, killexams exam simulator. Visit, their specimen questions and test brain dumps, their exam simulator and you will realize that is the best brain dumps site.

Back to Braindumps Menu

300-180 test prep | 000-315 real questions | ACSM-GEI exam prep | M9060-719 dump | 000-386 VCE | 000-442 test prep | 00M-249 cram | COG-706 dumps | ST0-135 practice test | 006-002 brain dumps | 000-918 dumps questions | 6002 exam questions | 648-247 Practice Test | 700-101 real questions | OG0-9AB study guide | HP0-090 braindumps | 00M-646 brain dumps | 9L0-507 exam prep | HP0-022 braindumps | 000-536 free pdf |

Individuals utilized these Oracle dumps to get 100% marks Oracle Certification ponder guides are setup by means of IT specialists. The vast majority objection that there are an examcollection of questions in this sort of monster amount of training exams and exam asset, and they might be nowadays can not stand to deal with the charge of any additional. Seeing specialists instructional meeting this far achieving version while by and by affirmation that each one the becoming acquainted with is anchored after significant research

If you are attempting to find Pass4sure Oracle 1Z0-101 Dumps containing actual exams questions and answers for the Develop PL/SQL Program Units Exam instruction, they provide most up to date and quality wellspring of 1Z0-101 Dumps this is They have aggregated a database of 1Z0-101 Dumps questions from real exams with a selected cease purpose to give you a risk free get ready and pass 1Z0-101 exam at the first attempt. Huge Discount Coupons and Promo Codes are as below;
WC2017 : 60% Discount Coupon for all tests on website
PROF17 : 10% Discount Coupon for Orders more than $69
DEAL17 : 15% Discount Coupon for Orders extra than $ninety nine
DECSPECIAL : 10% Special Discount Coupon for All Orders

At, they give surveyed Oracle 1Z0-101 tutoring assets which can be the best to pass 1Z0-101 test, and to get authorized by Oracle. It is an extraordinary inclination to quicken your vocation as an expert in the Information Technology undertaking. They are content with their notoriety of supporting individuals pass the 1Z0-101 exam of their first attempts. Their prosperity costs in the previous years had been actually amazing, on account of their happy customers currently ready to help their profession inside the rapid path. is the essential decision among IT experts, particularly the individuals looking to move up the chain of command goes speedier in their separate partnerships. Oracle is the venture pioneer in records age, and getting ensured by them is a guaranteed approach to win with IT professions. They enable you to do precisely that with their inordinate lovely Oracle 1Z0-101 tutoring materials.

Oracle 1Z0-101 is ubiquitous all around the globe, and the business undertaking and programming arrangements given by utilizing them are grasped by method for about the greater part of the associations. They have helped in driving bunches of offices on the beyond any doubt shot course of pass. Extensive data of Oracle items are taken into preparation a totally essential capability, and the specialists certified by method for them are very esteemed in all associations.

We offer real 1Z0-101 pdf exam questions and answers braindumps in groups. Download PDF and Practice Tests. Pass Oracle 1Z0-101 digital book Exam rapidly and effectively. The 1Z0-101 braindumps PDF compose is to be had for perusing and printing. You can print more prominent and exercise regularly. Their pass rate is high to 98.9% and the comparability percent between their 1Z0-101 syllabus ponder manual and actual exam is 90% construct absolutely with respect to their seven-yr instructing background. Do you need accomplishments inside the 1Z0-101 exam in only one attempt? I am as of now breaking down for the Oracle 1Z0-101 real exam.

As the only thing in any way important here is passing the 1Z0-101 - Develop PL/SQL Program Units exam. As all which you require is a high score of Oracle 1Z0-101 exam. The best one viewpoint you have to do is downloading braindumps of 1Z0-101 exam courses now. They will never again will give you a chance to down with their cash back guarantee. The specialists also protect rhythm with the greatest progressive exam so you can give the a great many people of updated materials. Three months free get section to as an approach to them through the date of purchase. Each applicant may likewise bear the cost of the 1Z0-101 exam dumps through at a low cost. Regularly there might be a decrease for all individuals all.

Within the sight of the legitimate exam substance of the brain dumps at you may effectively extend your specialty. For the IT experts, it's far critical to adjust their aptitudes predictable with their calling prerequisite. They make it smooth for their clients to take accreditation exam with the assistance of demonstrated and certified exam material. For a splendid future in its realm, their brain dumps are the top notch decision. Huge Discount Coupons and Promo Codes are as under;
WC2017: 60% Discount Coupon for all exams on website
PROF17: 10% Discount Coupon for Orders greater than $69
DEAL17: 15% Discount Coupon for Orders greater than $99
DECSPECIAL: 10% Special Discount Coupon for All Orders

A best dumps composing is an absolutely fundamental element that makes it simple a decent method to take Oracle certifications. Be that as it may, 1Z0-101 braindumps PDF gives accommodation for applicants. The IT accreditation is a significant troublesome task if one does now not find right direction inside the type of honest to goodness valuable asset material. Subsequently, we've genuine and up and coming substance material for the instruction of accreditation exam.

1Z0-101 | 1Z0-101 | 1Z0-101 | 1Z0-101 | 1Z0-101 | 1Z0-101

Killexams 1Z0-337 VCE | Killexams 000-428 test prep | Killexams JN0-690 test prep | Killexams MB4-219 practice test | Killexams HP5-H09D brain dumps | Killexams LOT-917 braindumps | Killexams 132-S-916.2 cheat sheets | Killexams 000-M63 test prep | Killexams HP0-Y31 test questions | Killexams HP0-J64 exam prep | Killexams A2040-402 dumps | Killexams 000-120 braindumps | Killexams C9030-644 exam prep | Killexams 000-907 pdf download | Killexams CCB-400 study guide | Killexams HP2-K40 real questions | Killexams 310-110 dump | Killexams 210-060 free pdf | Killexams ST0-093 braindumps | Killexams 9L0-061 real questions | huge List of Exam Braindumps

View Complete list of Brain dumps

Killexams 9A0-502 questions and answers | Killexams FINRA cram | Killexams C2020-004 VCE | Killexams 1Z0-105 brain dumps | Killexams 000-M47 mock exam | Killexams CAT-160 free pdf download | Killexams C9510-319 real questions | Killexams 9A0-066 test prep | Killexams EE0-513 test questions | Killexams NS0-502 braindumps | Killexams ST0-247 test prep | Killexams 000-645 cheat sheets | Killexams 1Y0-731 questions answers | Killexams C2020-632 free pdf | Killexams 000-M245 practice questions | Killexams 000-164 practice test | Killexams 7303-1 free pdf | Killexams VCS-255 braindumps | Killexams C9560-023 exam prep | Killexams 7220X exam questions |

Develop PL/SQL Program Units

Pass 4 sure 1Z0-101 dumps | 1Z0-101 real questions |

Learning the Basics of PL/SQL - Page 4 | real questions and Pass4sure dumps

Executing PL/SQL Using Developer 2000's Procedure Builder

Procedure Builder is part of Oracle's Developer 2000 development environment. It allows you to develop and debug PL/SQL program units for use in Developer 2000 applications. With Developer 2000, PL/SQL is used on the client to program the behavior behind the forms, reports, and menus that you develop. You end up with a PL/SQL engine on the client as well as on the server. A nice benefit of this is that Procedure Builder can be used to execute PL/SQL code without having to be connected to a database.

Note - Many of the advanced features discussed later in this book are available only when executing PL/SQL code in the database.

Starting Procedure Builder

If you have Developer 2000 installed, you start Procedure Builder by selecting Start, Programs, Developer 2000 R2.0, Procedure Builder. The opening screen is shown in Figure 1.5 and is divided into three sections.

Procedure Builder's opening screen.Procedure Builder's opening screen.(Click for full size)

As you can see, the Procedure Builder window is divided into three major parts. The Object Navigator window allows you to navigate through the various program units, PL/SQL libraries, and database objects to which you have access. The other two parts of the display combine to make up the PL/SQL Interpreter window. The top pane is used when debugging PL/SQL code and shows the code being debugged. The bottom pane is where you can type in and execute ad-hoc PL/SQL blocks.

New Term - PL/SQL may be used to write procedures, functions, package bodies, package types, and triggers. These constructs are referred to as program units.

Using Interactive PL/SQL

The PL/SQL interpreter allows you to enter a PL/SQL anonymous block and have it executed. The small block in Listing 1.2, that you typed in earlier, is one such anonymous block. You can type that block into Procedure Builder and execute it, but first you need to make one small change. The code shown in Listing 1.2 contains the following two calls to DBMS_OUTPUT:

dbms_output.put_line('The variable X = '); dbms_output.put_line(x);

DBMS_OUTPUT is a package that only exists within the database server. Procedure Builder will return errors if you try to execute the code as it stands now. Fortunately, Oracle has a package similar to DBMS_OUTPUT that can be used in its place when you are executing code on a client. The name of that package is TEXT_IO, and it also contains an entry point named PUT_LINE. Take the code shown in Listing 1.2, replace the calls to DBMS_OUTPUT.PUT_LINE with TEXT_IO.PUT_LINE, and you have the code shown in Listing 1.6. This code will run from Procedure Builder.

Listing 1.6 A PL/SQL Block Using TEXT_IO That Will Run from Procedure Builder DECLARE x INTEGER; BEGIN x := 72600; text_io.put_line('The variable X = '); text_io.put_line(x); END;

Now, you can take this code and type it into Procedure Builder's PL/SQL Interpreter. The interpreter will automatically execute the block when you finish entering the last line. The results will look like the following:

The variable X = 72600

Procedure Builder has been written specifically to work with PL/SQL. Unlike SQL*Plus, you do not need to enter a forward-slash to tell Procedure Builder that you are done entering a block of PL/SQL.

Creating the SS_THRESH Function

Creating a function (or any other program unit such as a procedure or package) using Procedure Builder requires a bit more than just typing the CREATE FUNCTION statement into the interpreter. To create a function, you need to tell Procedure Builder that you want to create a new program unit. Do this by selecting the File, New, Program Unit menu option. You will see the dialog box shown in Figure 1.6.

Creating a New Program Unit.Creating a New Program Unit.

This dialog contains radio buttons allowing you to choose the type of program unit that you are creating and also contains a textbox for the program unit's name. Choose Function, type the name SS_THRESH into the textbox, and click OK. You will see a screen similar to that shown in Figure 1.7.

Entering the code for SS_THRESH.Entering the code for SS_THRESH.

Figure 1.7 shows the function with the code already written. Of course, Procedure Builder does not write the code for you. When Procedure Builder opens this window, it places a skeleton function in the textbox. You have to fill in the details. When you get the code entered the way that you want it, click the Compile button to compile it, and then click the Close button to close the window.

To execute the function that you just created, type the following statement into the PL/SQL interpreter:


When you execute this statement, Procedure Builder will execute the function and display the following results:

72600 Connecting to a Database

In addition to creating PL/SQL program units on the client, Procedure Builder can also be used to create and execute program units in a database. To do this, you first need to connect to a database. Use the File, Connect menu option to connect to a database. Once you've logged in, you will be able to browse database program units using the Object Navigator. Figure 1.8 shows the program units owned by the user named JEFF.

Program units in the JEFF schema.Program units in the JEFF schema.

To create a stored function or other program unit in the database, follow these steps:

  • Click to highlight the Stored Program Units entry under the user's name.

  • Click the Create Toolbar button.

  • Proceed as you would when creating a local program unit.

  • Except for having to choose the schema, the process for creating a PL/SQL function in the database is the same as for creating one locally.

    Using SQLPlus Worksheet

    If you have Enterprise Manager available, consider using SQLPlus Worksheet for the examples in this book. SQLPlus Worksheet is completely compatible with SQL*Plus, and can be used for all the examples in this book. The advantage that SQL*Plus worksheet has over SQL*Plus is in the interface. Rather than type in large blocks of code one line at a time, you can use a text editor-like interface. After you get the code entered the way that you want it, you can click a toolbar button to execute it.

    Executing a PL/SQL Block Using SQLPlus Worksheet

    Figure 1.9 shows the SQLPlus Worksheet.

    The SQLPlus Worksheet.The SQLPlus Worksheet.

    As you can see, the SQLPlus Worksheet screen is divided into two halves. The upper half is used for the entry and editing of SQL statements and PL/SQL blocks. The lower half is used to display output. The execute toolbar button, the one with the lightning bolt, is used to execute the statements that you have entered in the upper pane.

    There are two ways to use SQLPlus Worksheet to execute commands from a file. One way is to use the File, Open menu option to load the contents of a file into the upper pane, and then click the lightning bolt button. The other way is to use the Worksheet, Run Local Script menu option.


    In this chapter you learned a little about PL/SQL, what it is, and why it is used. You know that PL/SQL is Oracle's procedural language extension to SQL, and that you can use it to write procedures and functions that execute on the server.

    This chapter also explains the relationship between PL/SQL, SQL, and SQL*Plus. This should give you a good grasp of how PL/SQL fits into the larger Oracle picture.

    You wrote your first PL/SQL stored function, which should give you a good feel for the mechanics of programming with PL/SQL.

    SQL*Plus is the tool used throughout this book for PL/SQL code examples. SQLPlus Worksheet and Procedure Builder are two other tools that may also be used to write and execute PL/SQL code.

    Q & A
  • Where does PL/SQL code execution take place?

  • Usually, execution takes place at the server level. For the examples in this book, that will always be the case. Some Oracle products, such as Developer/2000, also have the capability to execute PL/SQL blocks locally on the client machine.

  • Can I write a complete application with PL/SQL?

  • Generally speaking you cannot, at least not as most people envision an application. For an end-user application, you would still need a tool, such as PowerBuilder or Developer/2000, in order to design screens and generate reports.

  • I executed some PL/SQL code which used dbms_output.put_line() to print some data, but I didn't see anything. How come?

  • You probably forgot to enable the server output option. Use this SQL*Plus command:


    If you forget that, your PL/SQL output goes to oblivion.

  • I am using Procedure Builder, and I get errors when I try to execute code that contains calls to dbms_output.put_line(). Why?

  • When you use Procedure Builder to execute code locally, you must use text_io.put_line rather than dbms_output.put_line(). If you are using Procedure Builder, and you have connected to a database, you will be able to execute calls to dbms_output.put_line(), but you won't see the results.

  • Workshop

    Use the following workshop to test your comprehension of this chapter and put what you've learned into practice. You'll find the answers to the quiz and exercises in Appendix A, "Answers."

  • What tells SQL*Plus to send your PL/SQL code to the Oracle database for execution?

  • What is the fundamental basis of all PL/SQL code?

  • List an advantage of pushing program logic up to the server level.

  • Name three Oracle products that use PL/SQL.

  • What command tells SQL*Plus to display PL/SQL output?

  • Name at least two options for managing your PL/SQL source code.

  • Exercises
  • If you didn't encounter any errors when compiling your first function, try putting some in on purpose. Then try out the SHOW ERRORS command.

  • Try each of the three ways mentioned in the chapter for managing your source code. Become familiar with the SQL*Plus EDIT command. Try using the @ command or the START command to execute your PL/SQL code from a text file.

  • © Copyright Pearson Education. All rights reserved.

    This article is brought to you by Sams Publishing, publisher of Sams Teach Yourself PL/SQL in 21 Days, Second Edition.

    Development Environment aids users working with Oracle. | real questions and Pass4sure dumps

    Press Release Summary:

    In addition to facilitating SQL script and PL/SQL program unit development, OraDeveloper Studio v2.50 provides help with query creation and execution, user and privilege management, as well as exploration of existing databases. Solution also aids in schema objects modification, data export and import, and database project creation. Database Object Dependency is supported, and user comments are available for schema objects. Context-sensitive code completion is also included.

    Original Press Release: Core Lab Announces the Release of OraDeveloper Studio 2.50

    OraDeveloper Studio is a powerful development environment for working with Oracle. OraDeveloper Studio provides the easiest way to develop SQL scripts and PL/SQL program units, create and execute queries, manage users and privileges, explore existing databases, modify schema objects, export and import data, create database projects, and more.

    Version 2.50 introduces a large number of new features:

    o Advanced Context-sensitive Code Completiono Support for some new SQL*Plus commandso Keyboard Shortcut Customizationo Extremely customizable DDL generationo New Schema Objects Clusters: database links, cluster indexes, partitioned indexeso Database Object Dependency supportedo User comments available for schema objectso Enhanced Code Templates: templates preview and inserting by hotkey addedo Schema Export to SQL scripto New Database Project Wizardo Database Object Search Enhancementso Session Manager Improvementso Database Explorer Enhancements

    Other New Features

    o PL/SQL compilation warning support added.o Oracle Instant Client support added.o Date format can now be set for the Data Editor.o Same file can be included several times in the deployment order.o Table columns can now be created using copy/paste operations.

    You can try out the new version of OraDeveloper Studio by downloading it at They are looking forward to your comments and suggestions.

    Core Lab development team

    Related Thomas Industry Update Thomas For Industry

    500,000+ Detailed Supplier Profiles300,000+ Articles & Whitepapers6 Million+ Industrial Products10 Million+ 2D & 3D CAD Drawings

    PL/SQL Developer makes Oracle easier to use | real questions and Pass4sure dumps

    As many developers will attest, Oracle's database utilities can be difficult to work with. But a new shareware program called PL/SQL may make it easier to develop and configure apps using Oracle. This product review examines PL/SQL's capabilities.

    By Stuart Vessels

    Wouldn’t it be nice if you could edit an Oracle database table directly within a spreadsheet-like grid, the way you can in Access and Microsoft SQL’s Enterprise Manager? As many Oracle users are painfully aware, the database package does not offer an app that allows you to display the results of a query within an editable grid. The closest tool Oracle offers is its SQL Plus utility, which is basically a command prompt for executing SQL statements. The results are not in a grid, and they’re not editable.

    Fortunately, there’s a useful and easily accessible third-party shareware application that provides a grid-like interface for viewing and editing Oracle tables. The product, shown in Figure A, is PL/SQL Developer. It’s produced by Dutch software company Allround Automations.

    NotePL/SQL Developer will run on Windows 95 and Windows NT 4 or later. To connect to an Oracle database, PL/SQL Developer requires any 32-bit SQL*Net or Net8 version.

    Actually, PL/SQL Developer is much more than just an Oracle table editor. It’s an integrated development environment that has an impressive assortment of features designed to make it easier to develop, test, debug, and optimize Oracle PL/SQL-stored program units, such as packages and triggers.

    But you don’t have to be a developer to appreciate PL/SQL Developer’s SQL Window. You can use this tool to display the results of any SQL statement in an editable grid, as shown in Figure B. Once you edit a field entry or add a new record, you commit the modification to the database by clicking the Commit icon. The SQL Window even allows you to select and copy records, columns, or rows. You can then use this technique to paste new records into a table, or you can paste the data into an Excel or Word file. Of course, there’s a menu command for exporting query results to a variety of popular file formats, such as Excel or Word. In addition, the program remembers the SQL statements you execute by storing them in a history buffer. Recalling previously executed SQL statements is as easy as browsing a list and clicking on the one you want.

    The SQL Window is just the tip of the iceberg. PL/SQL Developer has many more tools and features that will appeal to developers and database administrators. To see just how powerful this program can be, check out Allround Automations comprehensive features list.

    Direct Download of over 5500 Certification Exams

    3COM [8 Certification Exam(s) ]
    AccessData [1 Certification Exam(s) ]
    ACFE [1 Certification Exam(s) ]
    ACI [3 Certification Exam(s) ]
    Acme-Packet [1 Certification Exam(s) ]
    ACSM [4 Certification Exam(s) ]
    ACT [1 Certification Exam(s) ]
    Admission-Tests [13 Certification Exam(s) ]
    ADOBE [93 Certification Exam(s) ]
    AFP [1 Certification Exam(s) ]
    AICPA [2 Certification Exam(s) ]
    AIIM [1 Certification Exam(s) ]
    Alcatel-Lucent [13 Certification Exam(s) ]
    Alfresco [1 Certification Exam(s) ]
    Altiris [3 Certification Exam(s) ]
    Amazon [2 Certification Exam(s) ]
    American-College [2 Certification Exam(s) ]
    Android [4 Certification Exam(s) ]
    APA [1 Certification Exam(s) ]
    APC [2 Certification Exam(s) ]
    APICS [2 Certification Exam(s) ]
    Apple [69 Certification Exam(s) ]
    AppSense [1 Certification Exam(s) ]
    APTUSC [1 Certification Exam(s) ]
    Arizona-Education [1 Certification Exam(s) ]
    ARM [1 Certification Exam(s) ]
    Aruba [8 Certification Exam(s) ]
    ASIS [2 Certification Exam(s) ]
    ASQ [3 Certification Exam(s) ]
    ASTQB [8 Certification Exam(s) ]
    Autodesk [2 Certification Exam(s) ]
    Avaya [101 Certification Exam(s) ]
    AXELOS [1 Certification Exam(s) ]
    Axis [1 Certification Exam(s) ]
    Banking [1 Certification Exam(s) ]
    BEA [5 Certification Exam(s) ]
    BICSI [2 Certification Exam(s) ]
    BlackBerry [17 Certification Exam(s) ]
    BlueCoat [2 Certification Exam(s) ]
    Brocade [4 Certification Exam(s) ]
    Business-Objects [11 Certification Exam(s) ]
    Business-Tests [4 Certification Exam(s) ]
    CA-Technologies [20 Certification Exam(s) ]
    Certification-Board [10 Certification Exam(s) ]
    Certiport [3 Certification Exam(s) ]
    CheckPoint [43 Certification Exam(s) ]
    CIDQ [1 Certification Exam(s) ]
    CIPS [4 Certification Exam(s) ]
    Cisco [318 Certification Exam(s) ]
    Citrix [48 Certification Exam(s) ]
    CIW [18 Certification Exam(s) ]
    Cloudera [10 Certification Exam(s) ]
    Cognos [19 Certification Exam(s) ]
    College-Board [2 Certification Exam(s) ]
    CompTIA [76 Certification Exam(s) ]
    ComputerAssociates [6 Certification Exam(s) ]
    Consultant [2 Certification Exam(s) ]
    Counselor [4 Certification Exam(s) ]
    CPP-Institute [4 Certification Exam(s) ]
    CSP [1 Certification Exam(s) ]
    CWNA [1 Certification Exam(s) ]
    CWNP [13 Certification Exam(s) ]
    CyberArk [1 Certification Exam(s) ]
    Dassault [2 Certification Exam(s) ]
    DELL [11 Certification Exam(s) ]
    DMI [1 Certification Exam(s) ]
    DRI [1 Certification Exam(s) ]
    ECCouncil [22 Certification Exam(s) ]
    ECDL [1 Certification Exam(s) ]
    EMC [128 Certification Exam(s) ]
    Enterasys [13 Certification Exam(s) ]
    Ericsson [5 Certification Exam(s) ]
    ESPA [1 Certification Exam(s) ]
    Esri [2 Certification Exam(s) ]
    ExamExpress [15 Certification Exam(s) ]
    Exin [40 Certification Exam(s) ]
    ExtremeNetworks [3 Certification Exam(s) ]
    F5-Networks [20 Certification Exam(s) ]
    FCTC [2 Certification Exam(s) ]
    Filemaker [9 Certification Exam(s) ]
    Financial [36 Certification Exam(s) ]
    Food [4 Certification Exam(s) ]
    Fortinet [14 Certification Exam(s) ]
    Foundry [6 Certification Exam(s) ]
    FSMTB [1 Certification Exam(s) ]
    Fujitsu [2 Certification Exam(s) ]
    GAQM [9 Certification Exam(s) ]
    Genesys [4 Certification Exam(s) ]
    GIAC [15 Certification Exam(s) ]
    Google [4 Certification Exam(s) ]
    GuidanceSoftware [2 Certification Exam(s) ]
    H3C [1 Certification Exam(s) ]
    HDI [9 Certification Exam(s) ]
    Healthcare [3 Certification Exam(s) ]
    HIPAA [2 Certification Exam(s) ]
    Hitachi [30 Certification Exam(s) ]
    Hortonworks [4 Certification Exam(s) ]
    Hospitality [2 Certification Exam(s) ]
    HP [752 Certification Exam(s) ]
    HR [4 Certification Exam(s) ]
    HRCI [1 Certification Exam(s) ]
    Huawei [21 Certification Exam(s) ]
    Hyperion [10 Certification Exam(s) ]
    IAAP [1 Certification Exam(s) ]
    IAHCSMM [1 Certification Exam(s) ]
    IBM [1533 Certification Exam(s) ]
    IBQH [1 Certification Exam(s) ]
    ICAI [1 Certification Exam(s) ]
    ICDL [6 Certification Exam(s) ]
    IEEE [1 Certification Exam(s) ]
    IELTS [1 Certification Exam(s) ]
    IFPUG [1 Certification Exam(s) ]
    IIA [3 Certification Exam(s) ]
    IIBA [2 Certification Exam(s) ]
    IISFA [1 Certification Exam(s) ]
    Intel [2 Certification Exam(s) ]
    IQN [1 Certification Exam(s) ]
    IRS [1 Certification Exam(s) ]
    ISA [1 Certification Exam(s) ]
    ISACA [4 Certification Exam(s) ]
    ISC2 [6 Certification Exam(s) ]
    ISEB [24 Certification Exam(s) ]
    Isilon [4 Certification Exam(s) ]
    ISM [6 Certification Exam(s) ]
    iSQI [7 Certification Exam(s) ]
    ITEC [1 Certification Exam(s) ]
    Juniper [65 Certification Exam(s) ]
    LEED [1 Certification Exam(s) ]
    Legato [5 Certification Exam(s) ]
    Liferay [1 Certification Exam(s) ]
    Logical-Operations [1 Certification Exam(s) ]
    Lotus [66 Certification Exam(s) ]
    LPI [24 Certification Exam(s) ]
    LSI [3 Certification Exam(s) ]
    Magento [3 Certification Exam(s) ]
    Maintenance [2 Certification Exam(s) ]
    McAfee [8 Certification Exam(s) ]
    McData [3 Certification Exam(s) ]
    Medical [68 Certification Exam(s) ]
    Microsoft [375 Certification Exam(s) ]
    Mile2 [3 Certification Exam(s) ]
    Military [1 Certification Exam(s) ]
    Misc [1 Certification Exam(s) ]
    Motorola [7 Certification Exam(s) ]
    mySQL [4 Certification Exam(s) ]
    NBSTSA [1 Certification Exam(s) ]
    NCEES [2 Certification Exam(s) ]
    NCIDQ [1 Certification Exam(s) ]
    NCLEX [3 Certification Exam(s) ]
    Network-General [12 Certification Exam(s) ]
    NetworkAppliance [39 Certification Exam(s) ]
    NI [1 Certification Exam(s) ]
    NIELIT [1 Certification Exam(s) ]
    Nokia [6 Certification Exam(s) ]
    Nortel [130 Certification Exam(s) ]
    Novell [37 Certification Exam(s) ]
    OMG [10 Certification Exam(s) ]
    Oracle [282 Certification Exam(s) ]
    P&C [2 Certification Exam(s) ]
    Palo-Alto [4 Certification Exam(s) ]
    PARCC [1 Certification Exam(s) ]
    PayPal [1 Certification Exam(s) ]
    Pegasystems [12 Certification Exam(s) ]
    PEOPLECERT [4 Certification Exam(s) ]
    PMI [15 Certification Exam(s) ]
    Polycom [2 Certification Exam(s) ]
    PostgreSQL-CE [1 Certification Exam(s) ]
    Prince2 [6 Certification Exam(s) ]
    PRMIA [1 Certification Exam(s) ]
    PsychCorp [1 Certification Exam(s) ]
    PTCB [2 Certification Exam(s) ]
    QAI [1 Certification Exam(s) ]
    QlikView [1 Certification Exam(s) ]
    Quality-Assurance [7 Certification Exam(s) ]
    RACC [1 Certification Exam(s) ]
    Real Estate [1 Certification Exam(s) ]
    Real-Estate [1 Certification Exam(s) ]
    RedHat [8 Certification Exam(s) ]
    RES [5 Certification Exam(s) ]
    Riverbed [8 Certification Exam(s) ]
    RSA [15 Certification Exam(s) ]
    Sair [8 Certification Exam(s) ]
    Salesforce [5 Certification Exam(s) ]
    SANS [1 Certification Exam(s) ]
    SAP [98 Certification Exam(s) ]
    SASInstitute [15 Certification Exam(s) ]
    SAT [1 Certification Exam(s) ]
    SCO [10 Certification Exam(s) ]
    SCP [6 Certification Exam(s) ]
    SDI [3 Certification Exam(s) ]
    See-Beyond [1 Certification Exam(s) ]
    Siemens [1 Certification Exam(s) ]
    Snia [7 Certification Exam(s) ]
    SOA [15 Certification Exam(s) ]
    Social-Work-Board [4 Certification Exam(s) ]
    SpringSource [1 Certification Exam(s) ]
    SUN [63 Certification Exam(s) ]
    SUSE [1 Certification Exam(s) ]
    Sybase [17 Certification Exam(s) ]
    Symantec [135 Certification Exam(s) ]
    Teacher-Certification [4 Certification Exam(s) ]
    The-Open-Group [8 Certification Exam(s) ]
    TIA [3 Certification Exam(s) ]
    Tibco [18 Certification Exam(s) ]
    Trainers [3 Certification Exam(s) ]
    Trend [1 Certification Exam(s) ]
    TruSecure [1 Certification Exam(s) ]
    USMLE [1 Certification Exam(s) ]
    VCE [6 Certification Exam(s) ]
    Veeam [2 Certification Exam(s) ]
    Veritas [33 Certification Exam(s) ]
    Vmware [58 Certification Exam(s) ]
    Wonderlic [2 Certification Exam(s) ]
    Worldatwork [2 Certification Exam(s) ]
    XML-Master [3 Certification Exam(s) ]
    Zend [6 Certification Exam(s) ]

    References :

    Issu :
    Dropmark :
    Wordpress :
    Dropmark-Text :
    Blogspot :
    RSS Feed : :

    Back to Main Page

    Killexams exams | Killexams certification | Pass4Sure questions and answers | Pass4sure | pass-guaratee | best test preparation | best training guides | examcollection | killexams | killexams review | killexams legit | kill example | kill example journalism | kill exams reviews | kill exam ripoff report | review | review quizlet | review login | review archives | review sheet | legitimate | legit | legitimacy | legitimation | legit check | legitimate program | legitimize | legitimate business | legitimate definition | legit site | legit online banking | legit website | legitimacy definition | pass 4 sure | pass for sure | p4s | pass4sure certification | pass4sure exam | IT certification | IT Exam | certification material provider | pass4sure login | pass4sure exams | pass4sure reviews | pass4sure aws | pass4sure security | pass4sure cisco | pass4sure coupon | pass4sure dumps | pass4sure cissp | pass4sure braindumps | pass4sure test | pass4sure torrent | pass4sure download | pass4surekey | pass4sure cap | pass4sure free | examsoft | examsoft login | exams | exams free | examsolutions | exams4pilots | examsoft download | exams questions | examslocal | exams practice | | | |