In Oracle Database 11g , when you need to update values of certain records from one table, and the value and the records to update are determined by a second table, you can use a subquery in the update statement to achieve the update. Using “EMPLOYEE” and “EMPLOYEE_STAGING” tables as an example , we want […]
Yii is an open source, object-oriented, component-based MVC PHP web application framework. Yii is pronounced as “Yee” or [ji:] and it’s an acronym for “Yes It Is! The first thing you need in order to use the Yii Framework is access to a Web server with PHP installed, of course. But if you’re reading […]
SQL injection as a matter of security can be approached from multiple angles. One must first be sure that the targeted application has a confidential database structure, since this is the main thing that makes SQL injection possible. Also, it’s important to notice that SQL injection is not something that happens arbitrary or from time […]
Hey there ! Welcome to the second part of the Android product flavors tutorial. In the first part we learned how to setup our project to use product flavors, and how to add custom icons and resources to the flavors. The second part will cover using custom layouts and adding custom code to the product […]
By now, every Android developer has heard of product flavors. We all know they allow us to add small customization to our application, for example, we could change the app icon or the app colors. This sounds great, imagine all the things you could do ! But what if you’ve never had the chance to […]
Android Studio has introduced a lot of new features that make our lifes a lot easier. One of those features is generating signed apks using Gradle. The basic idea is that you provide all the required properties (keystore password, alias and alias password) in the build.gradle file of the application you want to sign. But […]
If you want to enable Server Filtering on Kendo Grid, first step is to tell Kendo that you want to enable that functionality because, by default, the data source performs filtering on client side. var dataSource = new kendo.data.DataSource({ transport: { read: function (options) { var filter = options.data.filter; /* send the filter to the […]
If you’ve worked with AngularJS you most definitely have found yourself in the situation of using templates. While good for release and keeping your code clean, templates can often times pose a problem while developing. Since AngularJS has an implemented cache method, everytime you modfidy a template it will load from cache, therefore not allowing […]
In some occasions it is necessary to concatenate data from a number of rows into a single row. Using HR.DEMO table as an example , we want to retrieve a list of employees for each department. Base Data : Desired Output :
If you find yourself googling in order to make your new local server work online, you’ve come to the right place. Most Web Server packages today (WAMP, XAMPP or Uniform Server) are configured to work with the “old” Apache 2.2 version and have a major flaw. Since 2.4, Apache has dropped the directive “Allow” in […]
By continuing to use the site, you agree to the use of cookies. More information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.