12:04
2024-12-10 13:02:57
6:53
2024-12-10 13:18:23
3:49:58
2024-12-10 13:29:28
9:46
2024-12-11 07:45:15
5:40:21
2024-12-11 09:08:49
5:22
2024-12-11 17:54:14
1:42
2024-12-11 18:04:44
2:05:58
2024-12-12 09:00:08
1:01:06
2024-12-12 12:26:38
3:59
2024-12-12 15:09:36
51:24
2024-12-12 15:24:00
8:06
2024-12-12 16:34:52
2:35
2024-12-12 17:17:14
3:05
2024-12-12 17:26:54
Visit the ORACLE PL/SQL Fundamentals course recordings page
WEBVTT
-->
Please confirm if all have access to their desktop because we will start decoding.
-->
I see Miguel has access, Joseph have access, and open the Oracle SQL Developer.
-->
Okay. Awesome.
-->
And to verify, you can see my screen, right?
-->
Select a statement.
-->
Yeah, so you want to try this?
-->
I already prepared an employee's table in the database there.
-->
All of you, can you open the SQL Developer tools?
-->
I already put a shortcut in your desktop if it's not already open.
-->
Yeah, just click run.
-->
Thank you, Christine.
-->
How about Jeremiah?
-->
I see Joseph, are you accessing individual desktop or you prefer to access one desktop in your conference or something?
-->
Individual.
-->
Yeah, yeah. And I think you have access, right?
-->
How about Miguel? Do you have access right now?
-->
Apo.
-->
Yeah, can you open the SQL Developer right now?
-->
It's the middle icon.
-->
Nakabukas na, sir.
-->
Yung sayo po, sir Miguel?
-->
Ayos po. Nakabukas na ko yung...
-->
Ang nakikita ko right now sayo, sir Miguel, is yung command prompt. Yung CMD, yung terminal.
-->
Okay.
-->
So can you click local? See if it is loading.
-->
For our password, please type ashblue.
-->
Jeremias.
-->
What is your nickname, Jer?
-->
Jerry.
-->
Yeah, can you type ashblue as password?
-->
Yeah, ashblue. A-S-H-B-L-U-E.
-->
A-S-H-B-L-U-E.
-->
Blue.
-->
Okay. So that's, oops, you closed the error, sir Jerry.
-->
So for example, in that case, so we're trying to debug here.
-->
How can I share...
-->
Yeah, for sir Jerry, how can I share...
-->
Let me share, okay.
-->
I'll reshare my screen, one moment.
-->
Let me know if you can see my desktop.
-->
Ayos po.
-->
Right now I'm looking at sir Jerry account.
-->
As you can see, the error is ora-12541, meaning the server is not running.
-->
Okay.
-->
To fix that, can you open the terminal, sir Jerry?
-->
Yes, sir.
-->
Yeah, command prompt, yep.
-->
Then let's check your hostname.
-->
Type hostname, enter.
-->
Okay. So we need to match the hostname.
-->
Can you open a folder, please?
-->
Okay. You see on the right side, the tnsnames.ora, can you open that file? Right click on that.
-->
Then let's open that in with code.
-->
With Visual Studio Code.
-->
There you go.
-->
As you can see, the reason why it's not running, first is the server, the database server is not running. It is stopped.
-->
One moment. Let me grab the code.
-->
So we have a few ways to fix that.
-->
So we're gonna replace, you see on the line 6, the ray-lhnw-resize.
-->
We have to replace every instant of that with your hostname, jeremias-93dn.
-->
Okay, perfect. Now click save.
-->
Control S, please.
-->
Sir Jerry. Okay, awesome. We can close that now.
-->
Then we need to, sorry, go back again to the folder, please.
-->
Let's edit the other one, the listener.ora.
-->
Okay. Yeah, let's edit that. That's the last piece we need. Right click and edit in Visual Studio Code.
-->
Okay, you see, yeah, there you go. Thank you.
-->
Then I send, how can I send? One moment.
-->
On the, on the, dun po sa zoom, may send ako na Google Sheet.
-->
Can you click that po, yung Google Sheet?
-->
I'll paste the code to start the server.
-->
Sorry, sir. Sa zoom po, I send them a link.
-->
I see two people already joined.
-->
Yes po.
-->
Okay, so lahat na po ba na update na natin yung hostname natin?
-->
Now we need to start using the command lsnrctl start.
-->
You, nakita mo pa, sir Jerry, yung lsnrctl space start.
-->
There you go.
-->
lsnrctl start.
-->
It's like shorter for listener control.
-->
ctl.
-->
Ito po yung ito type. lsnrctl start.
-->
Space po. Sir Joseph.
-->
Space start. Okay. So, good thing yan na nakita natin yung error.
-->
So, ibig sabihin yan, kailangan natin i-restart yung computer.
-->
So, pag na change na yung hostname, we have to restart your computer.
-->
Tapos iraran natin ulit yung command na lsnrctl space start. Yes po.
-->
Ano po ang name mo po, yung nag-speak? Miguel. Miguel, okay.
-->
Unable to open.
-->
Yan po, okay po. So lahat po nung may ganung error, please restart your computer po.
-->
We need to restart the computer para magtake effect yung hostname na inedit natin.
-->
Yes, please restart. Thank you.
-->
Okay, so while waiting, while restarting, if you can still see my screen.
-->
So, itatari natin itong copy-paste.
-->
So, since this is a presentation, ipipaste ko yung
-->
dun sa interactive coding natin na slides.
-->
So, line 87.
-->
Let me check your computer.
-->
Okay, nag-restart pa din.
-->
So, let's wait for it.
-->
So, while waiting for the computer to restart,
-->
So, in PLSQL, the SELECT statement is used to retrieve data from database table.
-->
So, yan, this statement can be used in different ways depending on the requirement.
-->
So, selecting data into variables.
-->
So, yung simple SELECT natin, pag may SQL lang, SELECT into FROM.
-->
While in kapag sa PLSQL, we again yung naaral natin, DECLARE, BEGIN, tapos END.
-->
So, we declare variable, we begin where we transact, where we query, then we can output the variable.
-->
Okay.
-->
So, let's try. Marami pa naman tayong code na natatry, pero we can proceed muna while we restart the computer.
-->
So, eto naman is handling kapag no data found or too many errors.
-->
Pero maganda ma-try din talaga natin.
-->
Okay.
-->
Okay.
-->
Okay.
-->
Okay.
-->
Okay.
-->
Okay.
-->
Okay.