-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathb4exam
5095 lines (3669 loc) · 98.2 KB
/
b4exam
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
//practice programs for plsql
//creating a table
create table vivek(name varchar2(20),age number,rollno number)
//desc the table
desc vivek
//inserting values into table
insert into vivek values('Altaf',19,55)
//using select into
//%type is anchored data type can be used with databse colum or prev def var
declare
name vivek.name%type;
begin
select name into name from vivek name where age=22;
dbms_output.put_line(name);
end;
//declaring a constant
declare
pi constant number(7,6):=3.14192;
begin
dbms_output.put_line(pi);
end;
//declaring bind variable in plsql
// think of it as variable of global scope
//not declared inside a block
VARIABLE myvar number(20);
//initialize bind variable
EXEC: myvar:=1000;
//if statement
declare
num number:=10;
begin
if num <11 and num >10 then
dbms_output.put_line('Condition passed');
end if;
end;
//if else
declare
num number:=10;
begin
if num <11 and num >10 then
dbms_output.put_line('Condition passed');
else
dbms_output.put_line('Condition failed');
end if;
end;
declare
num number:=:enter;
begin
if num <11 and num >10 then
dbms_output.put_line('Condition passed');
else
dbms_output.put_line('Condition failed');
end if;
end;
// spelling for else if is not elseif its elsif
//simple loop
declare
i number:=0;
begin
loop
dbms_output.put_line(i);
i:=i+1;
exit when i>10;
end loop;
end;
//no need to declare i it is an implicit index vairvale
// for loops
declare
i number:=0;
begin
for i in reverse 1..1000 loop
dbms_output.put_line(i);
end loop;
end;
// cursor in plsql
declare
vname vivek.name%type;
cursor mycur is select name from vivek where age=22;
begin
open mycur;
fetch mycur into vname;
dbms_output.put_line(vname);
close mycur;
end;
// cursors
declare
name EMP.ENAME%type;
cursor getname is select ENAME from EMP where SAL>200;
begin
open getname;
loop
fetch getname into name;
dbms_output.put_line(name);
exit when getname%notfound;
end loop;
close getname;
end;
// Records in PLSQL
declare
myrec VIVEK%ROWTYPE;
cursor mycur is select * from vivek;
begin
for myrec in mycur
loop
dbms_output.put_line(myrec.name||myrec.age);
end loop;
end;
declare
var VIVEK%ROWTYPE;
begin
select * into var from vivek where age=22;
dbms_output.put_line(var.name||' aged: '||var.age);
end;
declare
cursor mycur is select name,age from vivek where age=22;
myrec mycur%rowtype;
begin
open mycur;
fetch mycur into myrec;
dbms_output.put_line(myrec.name||myrec.age);
end;
declare
type myrec is record(
name varchar2(20),
age number);
myrecvar myrec;
begin
myrecvar.name:='Vivek';
myrecvar.age:=22;
dbms_output.put_line(myrecvar.name);
end;
create or replace function myfunc(var1 number,var2 number) return number is
begin
if var1 > var2 then
return var1;
else
return var2;
end if;
end;
begin
dbms_output.put_line(myfunc(1,2));
end;
create or replace function myfunc(var1 number,var2 number)
return number is
myvar number;
begin
if var1 > var2 then
return var1;
else
return var2;
end if;
end;
begin
dbms_output.put_line(myfunc(1,2));
end;
create or replace procedure myproc is
name varchar2(20):='Vivek';
begin
dbms_output.put_line(name);
end;
begin
myproc;
end;
declare
type mynestedtable is table of number;
varmytb mynestedtable:=mynestedtable(1,6,8,9,5);
begin
for i in 1..5
loop
dbms_output.put_line(varmytb(i));
end loop;
end;
declare
type mynestedtable is table of number;
varmytb mynestedtable:=mynestedtable(1,6,8,9,5);
begin
for i in 1..varmytb.count
loop
dbms_output.put_line(varmytb(i));
end loop;
end;
// nested table as database object
create or replace type mynestedtable is table of number;
create or replace type mynestedtable is table of number;
create table mydummy(
name varchar2(20),
mynum mynestedtable
)nested table mynum store as nested_space_tab;
desc mydummy
insert into mydummy values('Vivek',mynestedtable(1,2,3,4,5));
select * from mydummy
declare
type mysso is table of number index by varchar2(20);
mytab mysso;
begin
mytab('Book1'):=1;
mytab('Book2'):=2;
mytab('Book3'):=3;
mytab('Book4'):=4;
dbms_output.put_line(mytab('Book1'));
end;
declare
type mysso is table of number index by varchar2(20);
mytab mysso;
flag varchar2(20);
begin
mytab('Book1'):=1;
mytab('Book2'):=2;
mytab('Book3'):=3;
mytab('Book4'):=4;
flag:=mytab.first;
while flag is not null
loop
dbms_output.put_line(mytab(flag));
flag:=mytab.next(flag);
end loop;
end;
declare
type mystrongcur is ref cursor return VIVEK%ROWTYPE;
myvar mystrongcur;
myrec vivek%rowtype;
begin
open myvar for select * from vivek where age=22;
fetch myvar into myrec;
dbms_output.put_line(myrec.name);
end;
declare
myvar SYS_REFCURSOR;
myrec vivek%rowtype;
begin
open myvar for select * from vivek where age=22;
fetch myvar into myrec;
dbms_output.put_line(myrec.name);
end;
declare
type myarray is varray(30) of EMP.ENAME%TYPE;
myvar myarray;
begin
select ENAME bulk collect into myvar from emp;
for i in 1..myvar.count
loop
dbms_output.put_line(myvar(i));
end loop;
end;
Skip to content
Using Gmail with screen readers
Conversations
edX
🤗 15 trending courses. Find yours today!
- Discover exciting courses in Marketing Analytics, Project Management, Animal Ethics and more! Sign Into Your Account What do you want to learn? Explore exciting
9:04 PM
Faraz Hussain
Fwd: plsql programs
- ---------- Forwarded message --------- From: Faraz Hussain <[email protected]> Date: Sat, May 5, 2018, 23:09 Subject: plsql programs To: <[email protected]>
Attachments
pl sql.txt
plsql ques.txt
plsql.txt
7:27 PM
Freeletics
Hypertrophy: It is time to go big!
- When it comes to muscle, size matters. Let’s be honest, who doesn’t like to see the results of their hard work in the mirror? But did you know that hypertrophy,
3:50 PM
Amazon.in
Amazon recommends "Elove® Dual Port USB Charger..." and more
- Your Amazon.in Today's Deals Get Amazon App Hello Vivek Singh, Here are personalized recommendations for you based on items you purchased or reviewed. Click her
5:50 AM
Mark Manson
How self-aware are you?
- Hey, Mark here. What do a 16th-century Indian guru, Facebook addiction, spoon castration and bad sexual metaphors all have in common? That's right: another Mark
1:51 AM
mail
You are invited to join Examly
- Hi Examly user, Welcome to Examly! Please set your password and activate your account by clicking the below link: Activate Account Regards, Team Examly
12:42 AM
mail
You have been enrolled in a course
- Hi Examly user, You have been newly enrolled in the following course: Informatica Mock Test Regards, Team Examly
12:42 AM
Ministry of Railway.
Get Your Meals Delivered to Your Berth
- Having trouble reading this email? View in your Mobile/Web browser /PiyushGoyalOfficial @PiyushGoyal www.piyushgoyal.in /RailMinIndia
May 5
Udacity India
All New Front-end Nanodegree Program - Explore Now
- Get started with Machine Learning Explore our all new and updated Front-End Web Developer Nanodegree Program. Enroll in the program to learn Front-end skills fr
May 5
MakeMyTrip
Open ASAP! Summer Surprise Inside
- Grab 1 Free Night Stay on Hotels. Hurry! Rs.2000 FREE Mywallet Cash on New App Install. Download Now View T&Cs Follow us on: Click here to view our contact deta
May 5
Sarabjit Kumar
Reminder to fill survey for Summer Training and Inputs during Summer PEP Classes
- Dear Students, Hope you all will be doing good in your examinations. This mail is a reminder to you all for filling your preference for Summer Training and Inpu
May 5
Dr. Sunaina Ahuja
Seven-Day Workshop on Econometrics-Time Series & Panel Data Analysis
- Dear Ma'am/Sir, Greetings from Lovely Professional University - Human Resource Development Center! Data based decisions have acquired great significance in this
Attachment
Brochure-Workshop on Econometrics.pdf
May 5
Udemy Instructor: K.
Season 2 of Avanced framework development Selenium C#
- New Educational Announcement Hi Vivek, an announcement has been made from Karthik, instructor of Understanding Docker and using it for Selenium automation. Dear
May 5
Facebook
Tony Nongrum and Sylvanus Lamare have birthdays today
- Help Tony Nongrum and Sylvanus Lamare celebrate their birthdays Saturday, May 5th Tony Nongrum Write on his timeline Sylvanus Lamare Write on his timeline Faceb
May 5
Simplilearn
Thanks for your interest in Simplilearn’s DevOps certification training
- Welcome to Simplilearn Hi [email protected], Welcome and thank you for your interest in the Simplilearn DevOps Practitioner certification training program.
May 5
Amazon.in
Amazon recommends "Algorithm Design Techniques:..." and more
- Your Amazon.in Today's Deals Get Amazon App Hello Vivek Singh, Here are personalized recommendations for you based on items you purchased or reviewed. Click her
May 5
Udemy
Your Weekly Course Catalog is here. 15 fresh picks just for you.
- A weekly roundup of 15 courses picked just for you, straight to your inbox. Discover your next course. My Courses | Featured TFS Agile Planning Tools View Cours
May 4
Twitter
Vivek, see 3 new updates from Randy Orton
- Updates you should see Updates for Randy Orton 1 Tweet 2 likes See all updates Settings | Help | Unsubscribe | Not my account We sent this email to @Hybriodomin
May 4
alerts
You have paid Rs.90 to Daksh
- Money Sent Successfully ₹ 90 To Daksh's Paytm Wallet Linked to 9872853663 From VIVEK SINGH's Paytm Wallet Linked to 9473087056 May 4, 2018 20:54:38 Transaction
May 4
Naukri Alerts
Job Openings for Analyst, Java Fresher, Developer
- PLC Programmer/engineer Keyskills: Written Communication, Communication Skills, Plc Programming, Plc - Scada Dear Vivek Singh You last updated your profile on 1
May 4
Mark Manson
How to get motivated and take action
- Hey Mark here. One of the best habits I ever got into was writing consistently, and it's definitely paid off for me in the long run. But even though I've come t
May 4
Udacity India
Make a career transition with the power of Python
- Most popular programming language in Machine learning world Beginner-friendly, versatile, and multi-library support have made Python one of the most powerful la
May 4
Picubed
Eligible for projects
- Lovely Professional University Jalandhar-Delhi G.T. Road, NH-1, Near Chaheru Railway Bridge Hi Vivek Singh, You are eligible in 2 projects. project Details Proj
May 4
Picubed
Eligible for job
- Lovely Professional University Jalandhar-Delhi G.T. Road, NH-1, Near Chaheru Railway Bridge Hey Vivek Singh, New job opportunity from iheal healthtech pvt limit
May 4
Sarabjit Kumar
Reminder to fill survey for Summer Training and Inputs during Summer PEP Classes
- Dear Students, Hope you all will be doing good in your examinations. This mail is a reminder to you all for filling your preference for Summer Training and Inpu
May 4
Mukesh Singh Rajput.
Mukesh Singh Rajput tagged you in a post on Facebook
- Mukesh Singh Rajput tagged you in a memory . You can choose if you want to add it to your timeline. Remember: Posts you hide from your timeline may still appear
May 4
Amazon.in
Realme 1, Huawei P20 Lite, Nokia 7 plus & more new smartphones
- Latest in smartphones shop now Your Amazon.in Today's Deals Amazon App Offers on Smartphones Huawei P20 Lite Galaxy On7 Prime iPhone SE Vivo V9 Youth Smartphone
May 4
Amazon.in
ACER A315-21-2109 NX.GNVSI.005 AMD...
- Your Amazon.in Today's Deals Get Amazon App Hello Vivek Singh, Are you looking for something in our Laptops store? If so, you might be interested in these items
May 4
The Chef
CodeChef's May Challenge 2018
- View in browser 4th May 2018 CodeChef's May Challenge 2018 Hi Vivek Singh, Greetings from Chef! Each contest in Chefland is a new one to practice, perform and w
May 4
MakeMyTrip
What's your Excuse to Travel This Summer?
- 4 Reasons to Book Your Summer Holiday Now. For web version, click here Here are our top trending destinations to help you decide: Download MakeMyTrip Mobile App
May 4
Quincy Larson
How a 33-year-old museum tour guide became a professional web developer - her 18 month coding journey
- Here are this week's five links that are worth your time: 1. How a 33-year-old museum tour guide became a professional web developer - her 18 month coding journ
May 4
Twitter
Vivek, see 3 new updates from Randy Orton
- Updates you should see Updates for Randy Orton 3 likes See all updates Settings | Help | Unsubscribe | Not my account We sent this email to @Hybriodominator Twi
May 4
Saavn
All Your Music, All The Time
- Unlimited Downloads! With the power of unlimited downloads, you can listen offline no matter where you are. All you have to do is create a playlist, or pick fro
May 3
HackerRank Team
Improve your Coding Skills with Java Exception Handling (Try-catch)
- Hi Vivek, Improve your skills with this challenge recommended for you: Java Exception Handling (Try-catch) Java | 28,569 submissions Use try-catch to test a blo
May 3
Naukri.com Recruite.
Follow jobs of Datamatics recruiters
- Follow recruiters having relevant jobs for you Abhishek Saha Hr Manager Hiring for : 24 Online Info Technologies Private Limited Follow Send Message 277 Followe
May 3
edX
⚡Enroll Now!⚡ Master new skills in 6 weeks or less.
- Discover exciting courses in Java, Virtual Reality, Entrepreneurial Mindset, Retail Fundamentals, and more! Sign Into Your Account Take your skills to the next
May 3
Faraz, Draft 2
N queens
- Thanks a lot. Vivek Singh Red Hat Certified Professional | MCA(Hons) at Lovely Professional University P +91-8210012897 M +919473087056 E [email protected]
May 3
Udacity India
Become a Data Analyst: One of the hottest job roles of 2018!
- 59% of organizations claim an increase in the number of positions requiring data analysis skills. Data science: Most promising job area of 2018! According to a
May 3
Paytm
You have paid Rs.50 to BHASHKAR YADAV
- Money Sent Successfully ₹ 50 To BHASHKAR YADAV's Paytm Wallet Linked to 9506377763 From VIVEK SINGH's Paytm Wallet Linked to 9473087056 May 3, 2018 18:47:42 Tra
May 3
Udemy
Last chance at this week's top courses for only ₹770!
- It's our instructors that make Udemy what it is. Have you ever considered sharing your knowledge with millions of students worldwide? My Courses | Featured CHAN
May 3
Picubed
Eligible for projects
- Lovely Professional University Jalandhar-Delhi G.T. Road, NH-1, Near Chaheru Railway Bridge Hi Vivek Singh, You are eligible in 2 projects. project Details Proj
May 3
Amazon Web Services
AWSome Day Online Conference | Get Yourself Trained on AWS!
- Get Trained on AWS at AWSome Day Online Conference Join Amazon Web Services for AWSome Day Online Conference, a free, online training event that will provide yo
May 3
Snapdeal
Last chance : 1-2-3 sale ends tonight
- 10% off using IndusInd bank cards. Daily Needs Store Daily Deals Smartwatches Recommended for you! lycan Home Gym 14 Kg Rubber Weight , D Rod , 3 Feet , Strate
May 3
Coursera
Learn Skills That Get Results
- Real Skills, Real Results It’s never been easier to build your career with Coursera Reach your goals with flexible learning programs that fit your schedule.COUR
May 3
Amazon.in
Turn your house into a home
- Home decor, furnishing, furniture and more. See more Your Amazon.in Today's Deals Amazon App Home decor to turn your house into a home Furnishing to reflect you
May 3
Twitter
Top Tweets about Randy Orton
- Tweets about your top topics Randy Orton megan @megreyes_ So many of my former clients have been Day 1 when the Warriors played in the Cow Palace. I understand
May 3
LinkedIn
Associate Engineer, SW at HARMAN International and 9 other jobs for you.
- Vivek Singh Top job picks for you Associate Engineer, SW HARMAN International · Bangalore, IN 1 alum Software Engineer (Java / Python / Ruby / Javascript / PHP
May 3
Twitter
Vivek, see 8 new updates from Randy Orton
- Updates you should see Updates for Randy Orton 8 likes See all updates Settings | Help | Unsubscribe | Not my account We sent this email to @Hybriodominator Twi
May 2
Sarabjit Kumar
Update in survey for MCA Summer Training 2018
- Dear Students, Two more options have been provided you for summer training to be held during June - July 2018. 1. Mean Stack Web Development (Online) 2. Manual
May 2
MakeMyTrip
FREE Cancellation on Flights & Hotels!
- Enroll for MMTDOUBLEBLACK Now! Dear Customer, MMTDOUBLEBLACK is now available for Rs. 2,499 Rs. 1,499* only per year! Sign-up to be a part of this exclusive tra
May 2
3.59 GB (23%) of 15 GB used
Manage
Terms - Privacy
Last account activity: 0 minutes ago
Details
///////////////////////////////////////////////////////////////////////////passsing cursor as procedure arguments
declare
type cr is ref cursor;
c1 cr;
type rec is Record
(
name varchar2(20),
sal integer
);
r rec;
procedure p(c1 cr) is
begin
loop
fetch c1 into r;
exit when c1%notfound;
dbms_output.put_line(r.name || ' salary: '|| r.sal);
end loop;
end p;
begin
open c1 for select ename,sal from emp;
p(c1);
end;
//////////////////////////////////////////////////////////////////////////Map - to compare two objects
create or replace type tname as object
(
num number,
map member function m1 return number
);
create or replace type body tname is
map member function m1 return number
is
begin
return num;
end;
end;
declare
n tname:=tname(10);
n1 tname:=tname(20);
begin
if(n1>n) then
dbms_output.put_line('Greater');
else
dbms_output.put_line('Lesser');
end if;
end;
//////////////////////////////////////////////////////////////////////////Index- Simple - Composite - Unique
create index index_name on table_name (col name);
create index index_name on table_name(col1,col2);
create unique
/////////////////////////////////////////////////////////////////////////Abstract Class
CREATE TYPE food_t AS OBJECT
(
name VARCHAR2 (100),
food_group VARCHAR2 (100),
grown_in VARCHAR2 (100),
/* Generic foods cannot have a price, but we can
insist that all subtypes DO implement a price
function. */
NOT INSTANTIABLE MEMBER FUNCTION price RETURN NUMBER
)
NOT FINAL NOT INSTANTIABLE;
/
CREATE TYPE dessert_t UNDER food_t (
contains_chocolate CHAR (1),
year_created NUMBER (4),
OVERRIDING MEMBER FUNCTION price RETURN NUMBER
)
NOT FINAL;
/
CREATE OR REPLACE TYPE BODY dessert_t
IS
OVERRIDING MEMBER FUNCTION price RETURN NUMBER
IS
multiplier NUMBER := 1;
BEGIN
DBMS_OUTPUT.put_line ('Dessert price!');
IF self.contains_chocolate = 'Y'
THEN
multiplier := 2;
END IF;
IF self.year_created < 1900
THEN
multiplier := multiplier + 0.5;
END IF;
RETURN (10.00 * multiplier);
END;
END;
/
CREATE TYPE cake_t UNDER dessert_t (
diameter NUMBER,
inscription VARCHAR2 (200),
/* Inscription and diameter determine the price */
OVERRIDING MEMBER FUNCTION price RETURN NUMBER
);
/
CREATE OR REPLACE TYPE BODY cake_t
IS
OVERRIDING MEMBER FUNCTION price
RETURN NUMBER
IS
BEGIN
DBMS_OUTPUT.put_line ('Cake price!');
RETURN (5.00 + 0.25 * (LENGTH (self.inscription)) + 0.50 * diameter);
END;
END;
/
DECLARE
last_resort_dessert dessert_t
:= dessert_t ('Jello',
'PROTEIN',
'bowl',
'N',
1887);
heavenly_cake cake_t
:= cake_t ('Marzepan Delight',