There’s a length function, so length function gives you the length of a character string okay so you’ve got a length of a character string so I say select star from countries where the length of country name greater than 10 so it’ll only give us country names where the number of characters in … Read more
The implicit conversion does not include time elements so that’s a key thing to remember a lot of people that’s something that gets confused a lot because you would think gee it should be able to convert the time and it doesn’t okay examples are using the functions and in the Select, so I … Read more
The multi-tenant option just the side step now I’m also going to take this from the bottom of the slide upwards non the code terminology there was a bit of a problem with terminology with multi-talents now I should say by the way I’m I was on the beta program for 12 see I’ve … Read more
View menu I see something called materials my interface is not the same as yours but I’ll just hack it instead what I’m going to do is rename exercises dot zip two exercises dots I don’t know it right and I’ll email that out okay it really is terrible isn’t it the facts you … Read more
The ten genes 11g database control would let you administer your ASM desk groups database express can’t do that it simply can’t work with desk groups which are perhaps a bit annoying there’s no interface to ASM at all in database control you can create a tablespace using data files on dis groups, yeah … Read more
I was doing some experimenting earlier and I may well have broken it perhaps term we closed my browser completely these are the sorts of issues you guess because of the security model and the browser issues it happens all the time with this if I really have broken it on my windows pc … Read more
Enterprise Manager this is a very quick look at the enterprise manager environment in 12c it’s a quick look at enterprise manager because we’re not going to use Enterprise Manager much in these four days some of the exercises you can use an enterprise manager if you want to spend as much time as … Read more
We’ve created macro variable lists using PROC SQL, both horizontal and vertical lists. Now we’re going to talk about creating those same types of lists using the DATA step. Using the DATA step is a little bit more complex than using PROC SQL, but there are times when it can be advantageous because you … Read more
If my original code was a text or a character value like Recipe name, and I want to compare it with a data value that’s a character, then it must include the macro in double quotes. So let’s take it to code now. And by the way, these are the dishes that have a … Read more
What is type of subquery is called a non-correlated subquery? And how do I know that this is a non-correlated subquery, and is it best practice, are probably a couple of questions you might be thinking about. Yes, a non-correlated, generally, is best practice. And how do I know? Second question. How do I … Read more