ORACLE PL/SQL Fundamentals - rey-njhi-20241210-131824

Visit the ORACLE PL/SQL Fundamentals course recordings page

                WEBVTT

00:00:00.000 --> 00:00:08.720
okay awesome so now um can you try to open the sql developer then click local

00:00:11.600 --> 00:00:21.680
let me share my screen here you should see you're able you should able to click this local folder here

00:00:24.100 --> 00:00:26.120
but may laman siyang employees

00:00:32.860 --> 00:00:39.820
yeah please please open the sql developer tool tapos try natin itong first code nato

00:00:39.820 --> 00:00:43.120
i'll paste it in the google sheet

00:00:47.600 --> 00:00:55.800
good yan so nakita natin may table na no you can use the filter like this please look at my screen

00:00:55.800 --> 00:00:59.720
i see so sir ray may issue pa doon sa ano

00:01:01.300 --> 00:01:07.940
ibig sabihin you're not connected po sa ano database ash blue okay so yeah that's a problem

00:01:07.940 --> 00:01:16.240
because the hostname is quite different uh can you open command prompt sir ray or terminal yeah

00:01:16.240 --> 00:01:22.140
command prompt okay open then type hostname nabago niyo po yung hostname kanina sir can

00:01:22.140 --> 00:01:30.860
click the folder please let's check if nabago niyo po talaga yeah yes there you go click that

00:01:31.540 --> 00:01:41.660
then let's try to edit that uh listener yeah open with code ah yun po yung line 19

00:01:41.660 --> 00:01:51.000
it should be ray dash f3 lz yung nakakonek na po you can refer to our google docs tapos

00:01:51.000 --> 00:01:56.860
kwede niyo po i-try yung code doon while i'm helping sir ray uh napalitan mo na po sir

00:01:56.860 --> 00:02:05.620
na save mo na po sir ray perfect okay you save that yung isang files po na edit mo na rin po yung

00:02:05.620 --> 00:02:13.220
yan yung tns ra okay that's good now you have to restart your computer again if the command

00:02:13.220 --> 00:02:19.120
will not work but yeah let's try it but i think you have to restart it yeah you please

00:02:19.120 --> 00:02:22.000
restart po again thank you sir for that sir

00:02:24.420 --> 00:02:26.800
you know as you can see nakita ko meron ng ano no

00:02:29.260 --> 00:02:35.440
so magtatari tayo mag debug so can you try that command sir jerry error no kasi

00:02:36.440 --> 00:02:43.700
ngayon eh practice natin um try tayo mag try naman natin gamitin yung sql plus

00:02:43.700 --> 00:02:48.900
so tingnan natin yung employees table ano bang laman nya so pwede mong burihin ulit yan

00:02:48.900 --> 00:02:54.420
sir tapos tayo natin i-describe gamit i-apply natin yung natutunan natin kanina umaga

00:02:54.420 --> 00:03:01.380
so remove that um para gagamitin natin later on so type mo describe employees yung error

00:03:01.380 --> 00:03:05.440
nya sabi nya walang first name no siti tingnan natin ko may first name ba talaga yung table

00:03:05.440 --> 00:03:12.740
or so let's run ano pong laman nya may laman po bang ano first name wala po no wala so

00:03:12.740 --> 00:03:17.780
we will alter the table alam nyo na po pa na mag-alter ng table

00:03:21.920 --> 00:03:26.420
yan para hindi po kay mahirapang maghanap diya ng table pwede nyo po i-click yung filter

00:03:27.260 --> 00:03:32.560
dun po sa taas yan sa tables click nyo po tapos click nyo yung filter icon

00:03:32.560 --> 00:03:38.340
tas type nyo employees indicate yung isang filter lang po yan employees there go

00:03:39.560 --> 00:03:45.360
pwede tayo mag-add tayo ng first underscore name at syaka salary para mag run yung code natin

00:03:45.360 --> 00:03:56.040
example code natin but i'll provide the code sa google docs if you want to do it in

00:03:56.040 --> 00:04:06.300
in the terminal or run run the sql code so alter table employees add first name we declare

00:04:06.300 --> 00:04:13.260
bar chart eto po yung nasa google docs mag-add tayo ng first name tapos mag-add tayo ng

00:04:13.260 --> 00:04:20.460
salary na decimal then pwede na natin tong maran hindi na sya mag-result sa error so sir joseph it's running

00:04:21.800 --> 00:04:28.040
sir miguel oh may error ka pa rin sir miguel can wait wait wait

00:04:28.040 --> 00:04:28.620
starting

00:04:31.000 --> 00:04:36.840
no problem pero na change mo na ng maayos yung hostname no okay okay okay pas si

00:04:38.080 --> 00:04:47.840
sir joseph nag alter na okay add alter employees add first name okay comma okay so alter table

00:04:47.840 --> 00:04:55.160
employees add first name add salary can you na-try mo na pang error alter table employees add first

00:04:55.160 --> 00:04:58.360
employees anong error nya

00:05:00.920 --> 00:05:03.080
wait lang pa parin natin

00:05:34.920 --> 00:05:36.880
ah okay

00:05:36.880 --> 00:05:42.920
sir jerry can you put can you put ana new line after no second ad

00:05:42.920 --> 00:05:53.980
then enter tapos uh remove the comma yeah that can you try to run okay now let's um describe

00:05:53.980 --> 00:06:01.280
employees tingnan natin kung na alter na sya or you can refresh the ano yeah describe employees

00:06:01.280 --> 00:06:05.040
you have to select kita para hindi mag-run yung ano

00:06:06.200 --> 00:06:12.780
perfect so may first name na tayo may salary now you can try na yung declare yung first select natin

00:06:14.060 --> 00:06:19.420
you can remove it na tapos um yung select na

00:06:23.200 --> 00:06:31.440
okay restarting si sir ray si mame christine i'm looking at the sir joseph na screen okay can

00:06:31.440 --> 00:06:32.540
you try to run that now sir

00:06:39.160 --> 00:06:40.140
do you have an error

00:06:41.300 --> 00:06:47.520
sir yung kaya mga team uh not restarting no restarting na

00:06:48.760 --> 00:06:53.100
at tapos na okay let me refresh my