Wiki articles in category How-tos tagged with "database"

Default date format in Oracle is DD-MON-RR (25-JAN-18). With that output, we can't using date formatting.

Suppose we want to set a category to product (or an item in general term), Also suppose categories has sub-categories (multi-level)

The classic Yii way for doing an update action is as follows:

create a class file under protected\components named RActiveRecord.php

I used another example posted here a while back where the person was modifying the index.php and adding in a switch case for different domains and loading separate config files. This was actually too much for me, because all my portals are the exact same (as far as routes, modules, extensions, etc) and if I ever wanted to add another route it wouldn't be feasible opening up all the config files t...

Relational databases do not support inheritance so if we need to represent it, we have to somehow store meta info while keeping performance by minimizing JOINs. One way to solve this problem is using single table inheritance. All fields for the whole class tree are stored in a single table. Class name is stored in the type field...

The customary configuration of a Yii application includes just a single database section in the protected/config/main.php file, but it's easy to extend this to support more than one, tying each Model to one of the databases.