Extend varchar2 data type length 4K to 32K in 12c

Oracle 12c নিউ ফিচার গাইড অনুযায়ী-

The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32,767 bytes. Increasing the allotted size for these data types allows users to store more information in character data types before switching to large objects (LOBs). This is especially useful for brief textual data types and the capabilities to build indexes on these types of columns.
(Oracle® Database New Features Guide 12c Release 1 (12.1) E17906-16 Page 1-13) Continue reading Extend varchar2 data type length 4K to 32K in 12c

WordPress Checklist: 101+ easy steps to launch your next website!

WordPress is hands down, the best CMS to build a beautiful and fully-functional website today. Thanks to the availability of a number of tools, facilities and extremely resourceful plugins, creating a website with WordPress is a relatively easier task, as compared to building websites with other CMS. However, even though WordPress is one of the most user-friendly CMS’ in the market, creating a WordPress website can still be a daunting task, especially when it comes to knowing all the steps involved in the process.

And even if you are aware of all the steps involved in building a website using WordPress, remembering all of them, every time you work on a WordPress website is not always possible. In such a case, having an all-inclusive WordPress checklist would be most helpful! Thanks to the team of Capsicum Mediaworks, we do have a fully comprehensive WordPress checklist, which covers all possible steps involved in creating a WordPress website, from pre-development steps, development procedure, launch and SEO process, to security and maintenance aspects. All you need to do is download this checklist, and you will be able to build an awesome WordPress website, time after time!

Killer WordPress Checklist [Infographic] by the team at Capsicum Mediaworks, LLP

wordpress checklist infographic

Download PDF Version

Tips and Tricks – 1

1. Create unique case-insensitive constraint on a column.

Solution: Add function level unique index, example –

 CREATE UNIQUE INDEX index_name on table_name (UPPER(Column_Name));

2. Cannot create service/sid using ORADIM (DIM-00019: create service error O/S-Error: (OS 5) Access is denied.)

Solution: Make sure your oracle service is running. then create instance.
To create instance- Open CMD (command prompt) with admin privilege. the type the following then hit enter.