[Oracle] Startup & Shutdown Oracle Instance

Posted by cikul | Posted in Oracle, SQL | Posted on 17-07-2012-05-2008


For DBA,  starting up and shutting down database is a routine operation. How to start and stop Oracle database (windows & Unix base)

Starting Up Oracle Database

To starting up Oracle Database,  you must connect using SQLPLUS /as sysdba or an oracle account that has DBA privilege.

Read the rest of this entry »

[SQL-Oracle] Copying data from one table to another

Posted by cikul | Posted in SQL | Posted on 29-06-2012-05-2008


How to simply copy data from one Oracle table into another one? There is several ways to copy data, the common usage is exporting the data and then reupload the data to new table.

Read the rest of this entry »

[PHP] Connect to SOAP API using WSDL

Posted by cikul | Posted in PHP, Programming | Posted on 26-06-2012-05-2008


SOAP is a simple XML-based protocol that allows applications to exchange information over HTTP. Or more simply: SOAP is a protocol for accessing a web service.

WSDL stands for Web Services Description Language. WSDL is a document written in XML. The document describes a Web service. It specifies the location of the service and the operations (or methods) the service exposes.

Read the rest of this entry »

Query data from specific date SQL Server

Posted by cikul | Posted in SQL, Tips | Posted on 01-03-2012-05-2008


for example, you have sort of data from table order :

Order id Order_date Value
1 2005-12-15 13:04:42.667 500
2 2006-03-16 19:08:30.423 350
3 2007-07-28 15:14:30.350 400
4 2006-03-16 20:11:25.413 150
5 2000-09-10 16:09:58.817 200

and you want to get data for date 2006-03-16,

Read the rest of this entry »

Free Portable PHP IDE with Drupal, Worpress, Codeigniter, Jquery Support

Posted by cikul | Posted in Freeware, PHP | Posted on 31-01-2011-05-2008


Are you tired looking for free PHP IDE that have compatibility with common Frameworks? Now you can try CodeLobster Portable PHP IDE, multifunctional portable IDE FREE absolutely with all standard features:

PHP/HTML/CSS/JavaScript highlighting, advanced PHP/HTML/CSS/JavaScript autocomplete, Powerful PHP debugger, SQL autocomplete, Context and Dynamic Help

Read the rest of this entry »

Incoming search terms:

codeigniter ide | 

Error upgrading to newer WordPress version

Posted by cikul | Posted in PHP, web, wordpress | Posted on 14-11-2009-05-2008


Today I trying to upgrade my WordPress to newer version (2.8.6), but while u try to upgrade i get this error :

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 2355240 bytes) in /home/cikul/public_html/dhika/wp-includes/http.php on line 1331

To Solve this problem, you must increasing your memory limit options for your application. In wordpress, to increase memory limit you must edit wp_settings.php in your wordpress installation folder.

Read the rest of this entry »

How to : Get Category ID in WordPress

Posted by cikul | Posted in PHP, wordpress | Posted on 23-03-2009-05-2008


If you’re working on wordpress Theme, sometimes you need to know the categories ID for some categories. For example, in my cases, i need to exclude  “projects” category from my blog posts lists, you can use query_posts(‘cat=-3) for example if you know that project assigned with category ID=3. But if your themes using by several sites, you will difficult to define the category ID, because it will be different on another wordpress installation.

Read the rest of this entry »

PHP Developers Day 2008

Posted by cikul | Posted in PHP | Posted on 12-06-2008-05-2008


LIPI, IlmuKomputer.com and Zend are very excited to invite you to the PHP Developers Day, hosted by PDII-LIPI. This event is held with cooperation from Microsoft, PHPUG and PHP-ID.org.

09:00 – 09:15 Opening by Dr. Ir. Putut Irwan Pudjiono, MSc. (PDII LIPI)
09:15 – 10:00 Software Engineer as a Profession by Romi Satria Wahono (IlmuKomputer.com)
10:00 – 11:00 Microsoft, Open Source and Interoperability by Irving Hutagalung (PT. Microsoft Indonesia)
11:00 – 12:00 PHP Application Lifecycle Management by Rama Yurindra (PT Rynet-Zend Technologies Representative for Indonesia)
12:00 – 13:00 Lunch
13:00 – 14:00 PHP Application Interoperability by Luri Darmawan (PHP-ID.org)
14:00 – 15:00 PHP Easy Step by Riyogarta (PHPUG)
15:00 – 15:30 Coffee Break
15:30 – 16:30 Web Performance Test with Visual Studio Team Tester 2008 by Risman Adnan (PT. Microsoft Indonesia)
16:30 – 16:45 Closing by Hendro Subagyo (PDII LIPI)

Thursday, June 19th, 2008 (please be there by 8.30 for registration)

Gedung PDII 2nd Floor
Jl. Gatot Subroto Kav. 10,

How Do I Register
– Send email to : phpdeveloperday@live.com
– In the email, tell us your name, company/organization name and URL.
– Only 200 seats are available.

aktifkan curl di xammp

Posted by cikul | Posted in PHP | Posted on 19-01-2007-05-2008


Untuk aktifkan curl di xammp, anda harus uncomment “extensions=php_curl.dll” di semua php.ini yang terdapat di directory xammp. Berikut ini daftar php.ini yang dirubah :
– xammp\apache\php.ini
– xammp\php\php.ini
– xammp\php\php4\php.ini
– xammp\php\php4\php4.ini

setelah itu coba restart apachenya..

Sekarang tinggal coba utak-atik untuk uniformserver.. udah seharian utak-atik dan cari infonya blom ketemu. ada yang tahu?

How to change hostname in CentOS

Posted by cikul | Posted in Linux, Python | Posted on 11-01-2007-05-2008


CentOS was popular linux distribution which based on RedHat. All of Dutahost Server use CentOS for production server.

How to change hostname in CentOS and how to build Python script to handle this?
Read the rest of this entry »

Incoming search terms:

dhika | python set hostname |