Oracle World

bootstrap css library framework from twitter

2012-01-04T10:00:00.000+02:00

Are you only coder like me ?
Can't you find good and cheap designer for your apps ?
Don't you want to bother with basic css and js tricks ?

http://twitter.github.com/bootstrap/ is your best friend.

Bootstrap is very easy to use css library from well known social platform twitter.

They are also using this library in their site.
I tried to implement bootstrap library in http://freedjangohosting.com

how to remove dublicates from your mysql table

2012-01-04T00:31:00.002+02:00

nice mysql syntax for removing dublicates from your tables

strategy as follows

clone your table with
create table a as select * from b

truncate your table
truncate b

create unique index
create unique index u_indx1 on b (x,y,z)

insert all rows back to table with ignore
insert ignore into b select * from a

Django mysql innodb transaction

2011-08-24T04:49:00.000+03:00

Development is really headache without transactions in database.

change your mysql database storage engine to innodb

and add commit on success annotation to your procedures in django to work with transaction enabled environment

http://djangosaur.tumblr.com/post/357759467/django-transaction-mysql-engine-innodb

Freelancer

2010-11-25T10:36:00.000+02:00

Just launched my new freelance web site:
http://frlnc.com

All comments welcome.

Thanks.

Freelance Profiles,Freelance Job Opportunities

2010-11-25T10:34:00.000+02:00

Just launched my new freelance web site:
http://frlnc.com

All comments welcome.

Thanks.

how to download whole website with wget

2010-10-11T19:43:00.000+03:00

wget is incredible software you don't any fancy program to download entire site for offline browsing

you can use wget -m WEBSITEURLTODOWNLOAD

how to get yesterday in bash shell script

2010-08-13T16:15:00.000+03:00

YESTERDAY=`date --date=yesterday +'%Y%m%d'`
echo $YESTERDAY

converting utf8 file to ascii

2010-08-06T21:03:00.000+03:00

iconv --from-code UTF-8 --to-code US-ASCII -c inputfile > outputfile

installing Scrapy in shared server environment

2010-06-16T14:10:00.000+03:00

installing Scrapy in shared server environment as easy as below
you only need to define install directory

easy_install --install-dir=/home/py/www/programs/ -U Scrapy

recovering /etc/fstab file

2010-06-01T13:39:00.000+03:00

if you place errornous enrty in /etc/fstab

after rebooting your system

run following command to edit etc/fstab file

mount -w -o remount /

sqlldr primary key column with null values

2010-01-26T10:12:00.003+02:00

It's nice to be here i mean in my oracle blog again after a long time period :)

I will tell you how can you populate primary key column with getting data from sequence when you insert data with sqlloader.

for instance think about table structure below

create table T_SERVICE_AVAILABILITY_ID
(
ID NUMBER,
HOSTNAME VARCHAR2(50),
VRFNAME VARCHAR2(50),
VRFSTATUS VARCHAR2(5),
DATEX DATE
)

and you want to load data such as

HOST01,SERVICE1,up,26/01/10 09:48:40
HOST01,SERVICE1,up,26/01/10 09:48:40
HOST01,SERVICE2,down,26/01/10 09:48:41

as you see here we have an id column on table but not in data
so we must create appropriate trigger and sequence pair to get pk values from trigger
I'm skipping this step, it's pretty easy

then our control.ctl file should be like below format

LOAD DATA
BADFILE 'import.bad'
APPEND
INTO TABLE T_SERVICE_AVAILABILITY_ID
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
HOSTNAME CHAR NULLIF HOSTNAME = BLANKS,
VRFNAME CHAR NULLIF VRFNAME = BLANKS,
VRFSTATUS CHAR NULLIF VRFSTATUS = BLANKS,
DATEX DATE "DD/MM/YY,HH24:MI:SS" NULLIF DATEX = BLANKS
)

Important thing is here TRAILING NULLCOLS parameter to treat oracle to pk field as null
in other words by sending null for id column

How to add pagination to django comments for your model

2009-08-30T11:47:00.000+03:00

First step is
import Comment and ContentType to your view like below

from django.contrib.comments.models import Comment
from django.contrib.contenttypes.models import ContentType

Second step is defining your model which you want to paginate its comments
content_type_id=
ContentType.objects.get_for_model(YOUR_MODEL_NAME)

Last
get comments of specific instance of your model class with defining object_pk as filter parameter
comments = Comment.objects.filter(content_type=content_type_id,object_pk=quote_id)

here is complete view code

from django.core.paginator import Paginator, InvalidPage, EmptyPage
from django.contrib.comments.models import Comment
from django.contrib.contenttypes.models import ContentType
def quote_show_page(request,quote_id):
quote = get_object_or_404(Quote, id=quote_id)
content_type_id=ContentType.objects.get_for_model(Quote)
comments = Comment.objects.filter(content_type=content_type_id,object_pk=quote_id)
paginator = Paginator(comments, 5) # Show 5 comments per page

# Make sure page request is an int. If not, deliver first page.
try:
    page = int(request.GET.get('page', '1'))
except ValueError:
    page = 1

# If page request (9999) is out of range, deliver last page of results.
try:
    comments = paginator.page(page)
except (EmptyPage, InvalidPage):
    comments = paginator.page(paginator.num_pages)


variables = RequestContext(request, {
'quote':quote,
'comments':comments
})
return render_to_response('quoteshow.html', variables)


add following lines to your template

{% for comment in comments.object_list %}
<lu>
<hr>
<li>{{comment.user}} dedi ki: </li>
<br>
{{comment.comment}}
({{comment.submit_date}})
<br>
</lu>
{% endfor %}
<br>
<div class="pagination">
<span class="step-links">
{% if comments.has_previous %}
<a href="?page={{ comments.previous_page_number }}">previous</a>
{% endif %}

<span class="current">
Page {{ comments.number }} of {{ comments.paginator.num_pages }}.
</span>

{% if comments.has_next %}
<a href="?page={{ comments.next_page_number }}">next</a>
{% endif %}
</span>
</div>

Download from rapidshare free , like premium , no wait

2009-06-10T23:04:00.000+03:00


'''
Created on Jun 5, 2009

@author: www.pythonum.blogspot.com
'''

import telnetlib
import os, re
import time
from mechanize import Browser, HTTPError
import sys,datetime

H=HOST = "192.168.2.1"
U=USER = "root"
######EDIT THESE LINES################
P=PASSWORD = "yourmodempasswordhere"
DOWNLOAD_LIST_FILE="rapidsharelinksfile"
################################
WAIT_TIME=20
APP_NAME="RapidSZ"
VERSION=1.0

mech = Browser()

def reset_ip():
print "resetting ip"
tn = telnetlib.Telnet(HOST)
tn.read_until("login: ")
tn.write(USER + "\n")
if PASSWORD:
  tn.read_until("Password: ")
  tn.write(PASSWORD + "\n")

tn.write("kill -9 `cat /var/run/ppp0.pid`\n")
tn.write("exit\n")

tn.read_all()
tn.close()
time.sleep(WAIT_TIME)
print "wait " + str(WAIT_TIME) +" sec to get new ip ..."
print "ip reset done"

def resolved_link(link):
print "resolving link ..."
page = 0
mech.open(link)
mech.select_form(nr=0)

try:
  page = mech.submit()
  time.sleep(100)
except HTTPError, e:
  sys.exit("post failed: %d: %s" % (e.code, e.msg))


file = page.read()
lines = file.split("\n")
url = 0

for rapidlink in lines:
  dirlink = re.search("var tt", rapidlink)
  if(dirlink):
      url = rapidlink.split("\"")[3]
      break
print "url resolved %s" % url
return url

def download_file(url):
print "starting to download %s " % str(url)
filename = os.path.basename(url)
f = open(filename, "wb")
r = mech.open(url)
while 1:
  data = r.read(1024)
  if not data: break
  f.write(data)
f.close()
print "total " , os.stat(filename).st_size, "bytes"
print "download completed"

def main(file):
links=open(file,"r")
for link in links:
  reset_ip()
  download_file(resolved_link(link))


if __name__ == "__main__":
main(DOWNLOAD_LIST_FILE)

-----------

i wrote a little script above, i can download from rapidshare with no wait, i have airties rt 205 modem , i am connecting my modem with telnet and with reset_ip() procedure reseting modem ip after download a file and continue to download without wait , if you have a airties rt 205 modem then you can use this script to download from rapidshare free :)

save script as rapidsz.py

download and install mechanize module to your python library

enter your modem password in this line
P=PASSWORD = "yourmodempasswordhere"
example:


P=PASSWORD = "1234"

then
create list of links of files which you want to download and edit this line


DOWNLOAD_LIST_FILE="rapidsharelinksfile"
example:

DOWNLOAD_LIST_FILE="/opt/home/rapidlinks.txt"

links file content example:
http://rapidshare.com/files/236597473/file1.rar
http://rapidshare.com/files/236597473/file2.rar
http://rapidshare.com/files/236597473/file3.rar

and finally run script with

python rapidsz.py


-----------
tested with
python 2.5.2
suse 11.0
but most probably
will work with windows

glade and pygtk

2009-06-02T21:41:00.000+03:00

fantastic video tutorial about gtk glade python very beginning level

error: invalid Python installation

2009-05-26T20:03:00.000+03:00

if you are getting same exception below you have not a development version of python installed on your suse
error: invalid Python installation: unable to open /usr/lib/python2.5/config/Makefile (No such file or directory)

find devel package of your python version specific and install it

interesting python functions

2009-05-17T15:36:00.000+03:00

# send each member of range(5) sequence to p function which is simply printing it's argument

def p(x):
print x
map(p,range(5))

#filter sequence for given condition

seq=[2,22,22.2]
z=filter(lambda x:x>2, seq)
print z

#take first two argument of sequence as x,y then apply x*y , take result of this as a new first argument take 3rd argument which is 3 here as a new second argument and continue to process till the end of sequence

numbers=[1,2,3,4,5]
print reduce(lambda x,y:x*y,numbers)

here are the outputs of functions above
0
1
2
3
4

[22, 22.199999999999999]

120

--------------------------------------------------
Python Environment
--------------------------------------------------
version = 2.5.4 (r254:67916, Dec 23 2008, 15:10:54) [MSC v.1310 32 bit (Intel)]
platform = win32

python toolbox

2009-04-13T21:49:00.000+03:00

useful toolbox links for python

http://mashable.com/2007/10/02/python-toolbox/

pyscripter

2009-04-11T20:20:00.000+03:00

pyscripter really really fantastic ide for python

http://mmm-experts.com/Products.aspx?ProductId=4

Sql Tuning Teknikleri Sunumu

2009-02-22T13:58:00.009+02:00

Turkcell Teknoloji 2009 çalıştayı Sql Tuning Teknikleri sunumum

21Subat_Sql_Tuning_Techniques_Presentation [English Content]

Turkcell Teknoloji , Hasan Tonguç Yılmaz ve çalıştayı gerçekleştirmemizde emeği geçen herkese teşekkürler.

Sunumda kullanılan kaynaklar - references
Christian Antognini - Troubleshooting Oracle Performance
optimizermagic.blogspot.com
Oracle Performance Tuning Guide 10.2

Content Management Sunumu

2008-10-19T08:24:00.008+03:00

Bireysel eğitim merkezinde
Oracle Akademi Türkiye kapsamında yaptığım
Oracle Spatial , Large Objects , XML DB ve Oracle Text konularını içeren sunumum.

18 Ekim Sunum[English Content]

Sunum yapanlara, yetkililere ve katılımcılara teşekkürler çok keyifli bir gün oldu.

apex upload store as clob

2008-10-06T12:07:00.003+03:00

i'll provide a function which i have used in my latest project.This function getting uploaded blob content and converting this to clob.

you know apex file browse item storing uploded content into wwv_flow_files as blob after that developer responsible for storing this content in application spesific tables via fetching from wwv_flow_files

if you need to store your uploded content from apex as clob
you can use this function


FUNCTION uploaded_clob(p_name IN VARCHAR2) RETURN CLOB IS
  
    l_clob_content CLOB;
    l_blob_content BLOB;
    l_w            PLS_INTEGER;
    l_d_offset     PLS_INTEGER := 1;
    l_s_offset     PLS_INTEGER := 1;
    l_lc           PLS_INTEGER := dbms_lob.default_lang_ctx;
  
  BEGIN
  
    dbms_lob.createtemporary(lob_loc => l_clob_content, cache => TRUE);
  
    SELECT *
    INTO   l_blob_content
    FROM   (SELECT t.blob_content
            FROM   wwv_flow_files t
            WHERE  t.NAME = p_name
            ORDER  BY created_by DESC)
    WHERE  rownum < 2;
  
    dbms_lob.converttoclob(dest_lob     => l_clob_content,
                           src_blob     => l_blob_content,
                           amount       => dbms_lob.lobmaxsize,
                           dest_offset  => l_d_offset,
                           src_offset   => l_s_offset,
                           blob_csid    => dbms_lob.default_csid,
                           lang_context => l_lc,
                           warning      => l_w);
  
    RETURN l_clob_content;
  
  END uploaded_clob;

annoying broken images problem after apex installation solved

2008-08-30T10:48:00.003+03:00

you decided to upgrade your apex 3.1
everyting fine you executed installation script and then pointed your browser to

localhost:8080/apex

very nice page opened but some images missing and javascript doesntwork

you read some blog posts about this problem and they say execute
@apxldimg script like below

say directory_you_unzipped_apex_zip = d:\apex
@apxldimg.sql directory_you_unzipped_apex_zip -> this is wrong !

when i look inside apxldimg.sql i saw

create directory APEX_IMAGES as '&1/apex/images';

so you should use this script as

parent_directory_you_unzipped_apex_zip = d:\
@apxldimg.sql parent_directory_you_unzipped_apex_zip

after script is loading images to database xml

how to switch between multiple oracle home (version) on same machine

2008-08-05T11:49:00.003+03:00

there is a nice tool for switching oracle homes in universal installer
from installed products on environment tab just send up your choise and apply it

installing apex to 11g

2008-08-04T16:50:00.003+03:00

i have installed 11g to windows xp, you know apex 3.0 which is coming bundled with 11g , after the installation

i followed this great tutorial provided by oracle
http://www.oracle.com/technology/obe/11gr1_db/install/apexinst/apexinst.htm#o

and successfuly started to use apex

how to set Environment Variable in linux

2008-07-25T21:14:00.000+03:00

setting Environment Variable in suse linux
for example

$ ORACLE_HOSTNAME=somehost.us.acme.com
$ export ORACLE_HOSTNAME

and this command is for unsetting
$ unset ORACLE_HOME

see variables with
echo $ORACLE_HOME