How can you easily make a bar chart through any data? make a bar chart through any data Well, I’d like it to be a bar chart. So I’m going to just use the three little dots in the upper right-hand corner. And we want to change our list table to– and we’re going to … Read more
The more care you take to create your reports, the more the user will get out of them. I’d like to think about the information the user can gain in the first five seconds of seeing a graph. If they’re still trying to work out what on earth the graph is showing them, then … Read more
What is the concept of the bitmap join index? The concept of the bitmap join index in a sense you index a table on a column it doesn’t have right this you can use certain data warehouse but it also worked very well in normalized structures you can use the bitmap join index to denormalize … Read more
The date functions remember you’re always at a number that’s the number of days you subtract the number you’re subtracting that number of days use that for days hours minutes seconds months weeks if you want months then you do your date likes estate eight months of cyst 8 commas 1 will add 1 … Read more
A control construction contract, contracting I wanted something where the o/n started in position to see if there’s another example it’s maybe a little bit more useful no that’ll be good we’ll see some others coming up so that’s in string you can find a position of where something starts substring also has multiple … Read more
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 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
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
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
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