My name is Daniel Norwood. I'm a product manager here at Dell in the information management group. And today, I'd like to show you a little bit of information about the Toad Mac Edition, our newest product in the Toad family.
OK, so in this demo, we're going to create a new user, and we're going to add some objects to the user's schema. And then, we're going to do a few things to illustrate some of the features that we have in the product. First, I'm going to make a connection to the database to go ahead and create that user.
To create the user, I'm going to use the wizard that we've got here. And on the next screen, I'm going to add a couple of roles. OK. And that's done.
So now that we've got our new user named Mike, we're going to go ahead and create a new connection to connect as Mike. So I'll do a new connection. You can see here that we have Oracle Support, support for Postgres, as well as for MySQL. Today, we're working with Oracle. So I'm going to go ahead and fill this out for our Mike user really quick.
Now, I like to save the password for these, but you can choose not to. And you can see that the connection name has already been filled in for us, but you can obviously change that as well. Let's just name this one Mike for simplicity. And let's give it a color too, so we can easily identify it.
Next, we can test the connection to make sure that it works, which it does. And we'll go ahead and save that connection and connect. So you can see here confirmation that we've connected as Mike, and you can see here the color as well. So that means, if I click over here, this is going to be that first connection that I was connected as, the sys connection. So I can go ahead and disconnect that one, and it'll close those worksheets for me.
All right, so the next thing I want to do is go ahead and execute a script, which I've got saved here. So I'll do File, Open, grab our script here, and we'll execute it. OK, and you can see that our statements were processed pretty quickly. You can also see here the SQL Recall as a record of all the different statements which were just executed. So you can scroll through each of those and see what was executed against the database. We can also see that our schema now has been updated. All the objects which we just created are also here, represented in the tree.
Now, interestingly, one of our functions seems to have a problem, so let's take a look at that. If I click on it, we'll see the viewer for this. We'll see the information arguments, many other things. Let's take a look at the source. So in the source, you can see that I've got two errors, which obviously stem from a misspelling in our syntax here. So you can see a little bit of more information if I hover over it as well. So let's actually edit this really quick to fix it. So we'll click the Edit button here, and we'll fix that one.
Now that it's fixed, you can see the error goes away. Toad will also show you which line was changed here in the margin, and we'll go ahead and execute that and compile it back to the database. So now you also have a status update here that it was successfully compiled.
Now, to save a little bit of time, I went ahead and inserted a bunch of data into our tables. So let's take the next step and take a look at one of those tables. So here's the table browser. You can see a lot of information here about the table. You can also see Indexes, Constraints, Triggers, the Data, Script, Grants, Synonyms, Stats, Uses, and Used By. So lots of information here that you can see.
One of the things that we need to do next is make a quick change to our T_IMG table. Our IMAGE_ID is actually the wrong data type. So let's go ahead and edit this column's data type. In this case, I'd like to go ahead and make that type an INTEGER. And if you want, you can also take a look at the SQL here. And then, we'll go ahead and change that.
Let's also add a new column really quick. So we can do that here. Let's do IMG_ADDED, and let's give it a data type of DATE, and we'll go ahead and click OK on that. And we're also going to create a sequence really quick. So we can use one of our wizards for this. So you can see a number of different database object types that we support with wizards. So let's create a sequence, and we'll give that a name. And we'll leave this one really simple. OK, so you can see that was also created there. Now, I've got a couple of triggers that I want created, and I've got a script created for that. So let's go ahead and open and run it really quick. And with that done, I want to go ahead and add some pictures, some blobs basically, to our table.
So let's go back to the table here, and we'll go to the Data tab. And we're going to add some records. So the first thing I want to do is go ahead and import the blob from a file. So I've saved all my images here. So let's start with The Godfather, a classic movie. So we'll open that up, and for the title and director, we've actually got that referenced in the database here. So we don't even have to remember all that. So we'll go ahead and link that