Skip to content

rgiapratama.net

Linux, CentOS, MySQL, IPPBX, PHP, Oracle

Tag: oracle

Database, Oracle

Get last data (last created) in Oracle using “over partition”

Source data : * I want to get rows in yellow highlight. Query : Result Query : Result : Reference : http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions137.htm

2012-10-10Giaoracle, partition, sqlLeave a comment
Database, Oracle

Get Week Number according to ISO Standard

ISO Standard : look a different with Reference : http://ss64.com/ora/syntax-fmt.html

2012-03-132012-05-11Giaoracle, PL/SQL, Week NumberLeave a comment
Database, openSUSE, Oracle

oci8 on openSUSE 11

Download oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip Download oracle-instantclient11.2-sdk-11.2.0.1.0-1.x86_64.zip unzip oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip unzip oracle-instantclient11.2-sdk-11.2.0.1.0-1.x86_64.zip mv instantclient_11_2/ /usr/local/instantclient11 cd /usr/local/instantclient11/ ln -s libclntsh.so.11.1 libclntsh.so

2010-10-282010-11-04Giaoci8, openSUSE, oracle, PHPLeave a comment
Fedora, Linux

Apache2, PHP5, Oracle Instant Client di Fedora Core 4

Baru sempet nulis nih :) dari dulu ga ada waktu terus, langsung aja ya. Yang perlu dipersiapkan pertama kali : Komputer yang sudah diinstall Fedora Core 4 Apache2 (2.2.0) PHP5 (5.2.2) Oracle Instant Client (Instant Client Package – Basic & Instant Client
Read More

2008-01-152008-02-22Giaapache, Fedora, oci, oracle, PHP2 Comments

Categories

  • Ads
  • Cisco
  • Database
    • MongoDB
    • MySQL
    • Oracle
  • FortiGate
  • Gadget
    • Blackberry
    • E51
  • Hardware
  • Internet
  • Joomla
  • Linux
    • centOS
    • Debian
    • Fedora
    • openSUSE
    • Slackware
    • Trustix
    • ubuntu
  • Mikrotik
  • Netsuite
  • Programming
    • PHP
      • Laravel
  • Proxmox
  • SAP
  • Uncategorized
  • Virus & Antivirus
  • VOIP
    • 3CX
    • Asterisk
    • freeswitch
  • Windows
  • Zimbra

Comments

  • Gia on Install Windows XP di TravelMate 6291
  • Dian Hardiansyah on Install Windows XP di TravelMate 6291
  • Fernando on Reset eXtplorer admin Password
  • Gia on Change VMID (KVM) in Proxmox 2.3
  • Gin on Change VMID (KVM) in Proxmox 2.3

© G7

Booking Table