The archive logs I will probably have configured by default device type backup type to compress Mac upset and so I’m going to be favoring up to space from I do that and then we have the scripture you saw yesterday backup incremental level 14 recover of coffee with the tank, so this one scratch … Read more
The idea is we use store script, we use script stored scripts are stored in the repository but not in the control file repository you have to have a catalog database if you’re going to store scripts in the repository have three in the catalog repository if you don’t have that use operating system scripts … Read more
The effect of file multiplexing how many files/face if I were for example to back up database files per set one looks not connected to Oracle, okay you go in again I was about our balance with automation systems I said backup database files percent one right I’m now going to guess I’ve got about … Read more
DML data manipulation language the three main things in DML are inserting updating and deleting rows and so we’ll cover those topics and then we’re going to talk about transactions that make your changes permanent or remove your changes I’m going to talk about how you control transactions with the commit or rollback and who … Read more
The first one select region name from region’s natural join countries where country name equal Canada so it’s just for the country name of coal Canada it’s going to do a natural join and it’s going to do it only on matching column names here’s a join from countries natural join our regions where region … Read more
When you have multiple tables that have the same field basically so take it from here, not from another table that’s correct if you have multiple tables with the same name you must fully qualify them the column name because Oracle doesn’t know which table you’re going to get it from its catcher thank you … Read more
Restricting and sorting data, the where clause and sorting date of the order by Clause and we’re also going to do something called ampersand substitution which we’re going to get into someone had asked about can you like write it write some statements that allow you to prompt the user for some data and then … Read more
The difference between the list and minimum and alias that max actual savings so here we have our list prices a second column min price is the third list minus list price minus min price as the fourth and then we have a column alias in double-quotes max actual savings so we get it displayed … Read more
We are writing the query for a report we have used query-specific column names and validate the query and then we also have used generic column names and only try to parse the query at runtime well what are we used by default well by default um where you go there if we edit our … Read more
Customizing reports so this is something that we definitely are reports or an object that we definitely or a component that we definitely deal with a lot in our applications right they typically have a lot of data we want to expose that data well the first type of report that would take a quick … Read more