SYAMS-Info: Juni 2012

Oracle:: How to remove New Line characters and Tab's in the SQL output

Oracle:: How to remove New Line characters and Tab's in the SQL output-
a bit explanation from prasad22cm :
If the data in your database is POSTED from HTML form TextArea controls, different browsers use different New Line characters:

Firefox separates lines with CHR(10) only
Internet Explorer separates lines with CHR(13) + CHR(10)
Apple (pre-OSX) separates lines with CHR(13) only

So, we can conclude that to remove the new line, there were 3 CHR's type that we had to remove. . . .
and to remove 3rd of the new line types, you may need this syntax :

select REPLACE(REPLACE(REPLACE(your_char, CHR(10)), CHR(13)), CHR(9)) from your_table;

#source : http://sairamgoudmalla.blogspot.com/2009/03/how-to-remove-new-line-characters-and.html & http://prasad22cm.blogspot.com/2012/03/remove-new-line-characters-and-tabs-in.html?showComment=1340959422541#c9135826570768930447

more than 20 Sets Of Free and Useful Patterns for your Gimp

more than 20 Sets Of Free and Useful Patterns for your Gimp- do you know guys? patterns,textures and brushers are important equipments for graphic designer. whatever, you use Photoshop,Gimp, or others tool 4 design. . . you need this patterns tool. . .

Especially if you find high quality resources then you have to add into your collection.One day,they will definitely come in.

Anyway,today i have a great pattern collection. i hope you like !!!

High Quality Fabric Patterns

Pattern Source

Vintage Retro Grunge Wallpaper Patterns

Pattern Source

Seamless Colorful Grunge Polkadot Patterns

Pattern Source

White Washed Blue and Beige Grunge Patterns

Pattern Source

Seamless Baby Blue Photoshop Patterns

Pattern Source

Pattern Pack

Pattern Source

Free Vector Patterns

Pattern Source

Wallpaper Patterns

Pattern Source

Softly Plaidly- Peachy Keen

Pattern Source

Damask Brites Patterns

Pattern Source

Tartan Patterns

Pattern Source

Vivid Red Tileable Patterns

Pattern Source

Free Vector Patterns – Helvetica Abc

Pattern Source

Seamless Vector Patterns – Autumn Leaves

Pattern Source

Vector Repeat Patterns – Gears and Cogs

Pattern Source
Seamless Repeat Pattern in Vector Format free pattern set

Pattern Source

Diagonal Lines with and without Gradients

Pattern Source

Seamless Patterns Blue, Grey Mosaic

Pattern Source

Free Subtle Web Patterns

Pattern Source

Free Paper Pattern Set

Pattern Source

High Quality Linen Pattern

Pattern Source

after all patterns, you could download a lot of patterns on this site http://www.texturemate.com.

find your lovely patterns else!!!

more then 100 scripts fu for gimp 2.6

more then 100 script fu for gimp 2.6

more then 100 script fu for gimp 2.6-FX-Foundry project is constantly updating custom scripts for each major Gimp release.
Last pack contain more then 100 scripts updated for gimp 2.6
In case you do not need such huge pack you may also search (for category, name, author's name etc) and download single scripts.

Note that many scripts included are not listed in this registry, before ask in this or other gimp forum help to update some old script you may better check on FX-Foundry ,good chances was already updated

DOWNLOAD
last script pack for gimp 2.6
http://downloads.sourceforge.net/gimpfx-foundry/gimpfx-foundry-scriptpac...

Install Instructions

Put the scripts in :

Windows Vista/7)
C:\Program Files\GIMP 2\share\gimp\2.0\scripts
or
C:\Users\YOUR-NAME\.gimp-2.8\scripts

Windows XP
C:\Program Files\GIMP 2\share\gimp\2.0\scripts
or
C:\Documents and Settings\yourname\.gimp-2.8\scripts

Linux
/home/yourname/.gimp-2.8/scripts

Linux system-wide
/usr/share/gimp/2.0/scripts

#source : http://registry.gimp.org/node/13661

GIMP 2.8 Script-FUs is a collection of more than 100 scripts

GIMP 2.8 Script-FUs is a collection of more than 100 scripts,
initially created for GIMP 2.4, that have been fixed/updated recently to work with the latest GIMP 2.8. Besides filters and effects, there are also some scripts that allow you to easily create a calendar, create a CD label, add watermark and more.

Scripts included in the latest GIMP 2.8 Script-FU pack:

Artist: Angled strokes, Color Pencil, Conte-charcoal crayon, Crosshatched, Cutout, Inkpen, Note Paper, Paletter Knife, Pastel, WaterColor
Color: Invert, Saturation, BW from Graphic, Color Temp, Funky Color, Grey Point, Split Tone With ED, Tone Mapping
Contrast: Shadow Recovery, Auto Contrast, Change Contrast, High Pass, ISO Noise Reduction
Create new: CD label, GlassEffect Text, Glossy Orb, Letter Drop Animation, Scribbled Text, Text Balloon, Text Circle
Disorts: Circle Maker, Photocopy, Wrap Effect
Edges: Fade Outline, Fuzzy Border, Jagged Border, Translucent Border, Add Matte, Art Border, Frame like poster with strait corners, Frame like slide with round corners, Frame with Bevel, Frame with hover effect and round corners, Photo Border Fancy, Photo Frame, Tasty Frame
Effects: Cartoon 2, Blackboard Effect, Cartoon Quick, Chrome Image, Cross Light, Fog, Landscape Illustrator, Lomo, Reflection, Sepoina Graf-ix
Effects Selection: Bevel Selection, Chisel Or Carve, Glass Selection, Glow Selection
Photo: Picture to graphic, Copyright text, EZ Red Skin Fix, Film Grain, Fix Overblown, Halftone, Highlight to Sky and Clouds, Infrared Simulation, Red Eye by Selected Area, Red Eye Desaturate, Vintage Photo, Web Photo Editor
Shapes: CD Mask, Circle Draw, Old Paper, Stampify
Sharpness: High-Passs Sharpen, BSSS-Sharpen, Midtone-Sharp, Smart Sharpening, Wisest Sharpen, Blur Non-Edges, Make wonderful, Orton effect, Pixel Gradient, Sharp Blur, Soft Focus, Soft Focus Simple, Wrap Sharp
Sketch: quick sketch, Drawing, Line Sketch, Pastel Sketch, Pencil Sketch, Pen Drawn, Roy Lichtenstein, Synthetic Edges, Toned Line Art
Texture: Patchwork, Stained Glass, Texturizer
Misc: Arrow, Calendar Month, Calendar year, Prepare for Colorize, Remove Paths, Remove Settings, Step Resize, Stoked text, Watermark

DO NOT INSTALL these scripts into a 2.6 series release of GIMP

Download GIMP 2.8 Script FUs

Install Instructions

Put the scripts in :

Windows Vista/7)
C:\Program Files\GIMP 2\share\gimp\2.0\scripts
or
C:\Users\YOUR-NAME\.gimp-2.8\scripts

Windows XP
C:\Program Files\GIMP 2\share\gimp\2.0\scripts
or
C:\Documents and Settings\yourname\.gimp-2.8\scripts

Linux
/home/yourname/.gimp-2.8/scripts

Linux system-wide
/usr/share/gimp/2.0/scripts

#source : http://www.webupd8.org/2012/05/download-gimp-28-script-fus-pack-more.html & http://www.gimphelp.org/script28.shtml

How To Install Ubuntu 12.04 On Non-PAE Capable Hardware

Physical Address Extension (PAE) is a feature to allow (32-bit) x86 processors to access a physical address space, with larger than 4 gigabytes.

Ubuntu 12.04 (as well as Kubuntu 12.04) uses the PAE Linux kernel by default for 32bit ISOs so old computers that don't support PAE can't boot the latest Ubuntu version. But there is a way to install Ubuntu 12.04 LTS Precise Pangolin on computers without PAE support: using the non-PAE netboot Minimal IS.

The non-PAE netboot mini ISO lets you install the non-PAE kernel and the desktop environment you want: you can select to install Ubuntu Desktop , Kubuntu Desktop and so on. One note though: since the minimal CD will download packages from online archives at installation time instead of providing them on the install CD itself, you need a working Internet connection during the installation.

How to Install Ubuntu 12.04 LTS on non-PAE capable systems using the netboot minimal ISO

Download mini.iso from HERE, write it on a CD or USB stick and boot from the ISO like with the regular Ubuntu ISO and select "Install":

The installer will now ask you a bunch of questions regarding the keyboard, etc. - select the options you want (use TAB to move through fields, SPACE to select and ENTER to activate buttons / continue). If you use a proxy, you'll be asked to enter it before the installation starts:

Basically, all the info available in the regular installer are also available for the mini ISO, like selecting your country, choose if you want to encrypt you home directory, partition the hard disk and so on:

After partitioning your hard disk, the installer will start downloading the core packages:

If some packages fail to download, you can select to continue and at the end of this step, you'll get to the Ubuntu Installer Main Menu where you can select "Install the base system" so the installer will try to redownload the packages for which the download failed:

Next, you'll be asked to select the Linux kernel you want to use - here, select "linux-generic":

The next important step is to select the desktop environment you want to use. Select it using the SPACE key (don't just press enter or else you'll end up with the core system only and without a graphical desktop environment!):

for Unity, select "Ubuntu Desktop"
for KDE / Kubuntu, select "Kubuntu Desktop"

Next, make sure you install the GRUB bootloader (by simply selecting "Yes" when you reach the screen below):

And that's about it, after you complete the above steps, you should have a working Ubuntu 12.04 LTS (with Unity or KDE) that runs on non-PAE supported hardware.

You can also watch a video with the whole non-PAE Mini ISO Ubuntu 12.04 installation process, below:

(Direct video link)

Alternatives

Like I was telling you above, using the non-PAE mini ISO isn't the only way to install Ubuntu 12.04 Precise Pangolin on computers that don't support PAE. You can also install Xubuntu or Lubuntu since both come with non-PAE Linux kernels, and if you don't want to use XFCE or LXDE, simply open a terminal and type:

- for Unity (and all the default Ubuntu packages):

sudo apt-get install ubuntu-desktop

- for KDE:

sudo apt-get install kubuntu-desktop

Update: there's also an unofficial non-pae Ubuntu 12.04 ISO available for download HERE

#source : http://www.webupd8.org/2012/05/how-to-install-ubuntu-1204-on-non-pae.html

Oracle::–How to import xls File to Oracle DataBase?

Oracle::–How to import xls File to Oracle DataBase?-ok, sometimes we need to import xls file to our oracle DB, because we have data from xls file and we need to use the data on our oracle DB. of course we have to import xls File to Oracle DataBase.

and now i ll show you How to import xls File to Oracle DataBase? step by setp.

Here it’s :

1. You need to exp your .xls to .csv with save as your xls file
and change file type be comes CSV(text csv)

with Filed options :

*Character Set Unicode (UTF-8)
*Filed delimited ,
*and Text delimited “

and then OK and click save
open your .csv file with your text editor till U get data like this below :

“0061031″,”Mr”,”B”,”A”,”Williams A”
“0061032″,”Mr”,”B”,”A”,”Williams B”
“0061033″,”Mr”,”B”,”A”,”Williams C”
and on

2.Create a new file with your text editor and copas scripts below :
explanation

LOAD DATA
INFILE name.csv –>your csv path
APPEND
INTO TABLE RE.contacts –>your table name on your DB
FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ –>your column name on your table
(
URN,
TITLE,
FIRST_NAME,
OTHER_NAME,
LAST_NAME
)

this is mine

LOAD DATA
INFILE name.csv
APPEND
INTO TABLE RE.contacts
FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘
(
URN,
TITLE,
FIRST_NAME,
OTHER_NAME,
LAST_NAME
)

save and named file with name.ctl
3.Run your name.ctl on Terminal with :

sqlldr userid=user/pass control=name.ctl

you re finish now . . . good luck!

How to Install Oracle Application Server 10g Release 2 on Ubuntu

Oracle Application Server 10g is a comprehensive solution for developing, integrating, and deploying your enterprise’s applications, portals, and Web services. Oracle Application Server 10g Based on a powerful and scalable J2EE server, Oracle Application Server 10g provides complete business integration and business intelligence suites, and best-of-breed portal software.

As the only platform designed for grid computing as well as full lifecycle support for Service-Oriented Architecture (SOA), Oracle Application Server 10g gives you unmatched scalability, availability, manageability, and security.

and now i ll show you,

How to Install Oracle Application Server 10g Release 2 on Ubuntu?

1.

Create ‘oracle’ user and ‘oracle’ group

sudo adduser oracle
sudo addgroup oracle

2.

Now you need to add user ‘oracle’ add ‘root’ to secondary list of groups
You need to change the permissions of opt directory using the following command :

sudo chmod 775 /opt

3.

Log out and log in as oracle user
To fix a missing ‘ntcontab.o’ error, install the following packages

sudo apt-get install gcc make manpages-dev autoconf automake libtool flex bison gdb gcc-2.95-doc binutils

sudo apt-get install libdb1-compat

4.

Download the Oracle Application file ‘as_linux_x86_core_101202.cpio’ from here

5.

Extract in local user directory and run the installer using the following command

./runInstaller -ignoreSysPrereqs

At the end of the install near 95% if is says that it cannot verify that the instance is running(message:
/opmn/bin/opmnctl start), hit continue.

Waiting the installation process, when done then exit.
That’s all.

Go to :

http://localhost:1156

for the admin console.

Thanks for visiting and consider to share this article if you find it useful.

#source : http://www.ubuntugeek.com/install-oracle-application-server-10g-release-2-in-ubuntu.html

How to use meta tag ::SEO Friendly:: on blogspot

How to use meta tag ::SEO Friendly:: on blogspot -

Usually bloggers who used blogspot, use this way to crawled them blogs.

You know, the result is quite satisfied for my blog. . .

and you need this one to crawled your blog traffic. . .

How to use meta tag ::SEO Friendly:: on blogspot?

following these :

1. Logging in on your Blogspot account

2.Go to your blogspot dashboard>>Template>>Edit HTML

3.Do not forget to mark "Expand Template Widget"

Find this script <title><data:blog.title/></title>

and put these scripts bellow :

Meta keywords : Add All keywords that related on your blog

<meta name="keywords" content="blog, Blogger, Google Blogger, template, Blogger template, tutorial, blogger tutorial, tips, tricks, blogger tips, blogger tricks, blogger tips and tricks" />

Meta description : describe your blog here

<meta name="description" content="Help, tips and tricks for bloggers using the Google Blogger platform for their blogs. Some posts also relevant for those using other blogging platform" />

Meta author : put your name here

<meta name="author" content="nuur wahid anshary" />

And i do not know, why?? but google referenced to add this script,

for a better "SEO Friendly"

<meta name="ROBOTS" content="ALL" />

#source : http://www.bloggertipsandtricks.com/2007/05/meta-tags-for-blogger.html
& http://permathic.blogspot.com/2012/06/cara-memasang-meta-tag-seo-friendly-di.html

How to add ::related posts:: widget on blogspot?

How to add ::related posts:: widget on blogspot

How to add ::related posts:: widget on blogspot?-
i need this tutorial so much. . . you know? this widget is important,
it makes my blog simple guide and easy. . .
you can read my blog comfortable. . .

and now,
i ll share a little bit about " How to add ::related posts:: widget on blogspot?"

Here it's :

1. Logging in on your Blogspot account

2.Go to your blogspot dashboard>>Template>>Edit HTML

3.Do not forget to mark "Expand Template Widget"

Find this text <data:post.body/>

and put this scripts bellow :

<b:if cond='data:blog.pageType == "item"'>

<div class='similiar'>

<div class='widget-content'>
<br/>
<br/>
<br/>
<h4>Artikel Lain Yang Mungkin Anda Cari:</h4>

<div id='data2007'/><br/><br/>

<script type='text/javascript'>

var homeUrl3 = "<data:blog.homepageUrl/>";

var maxNumberOfPostsPerLabel = 4;

var maxNumberOfLabels = 10;

maxNumberOfPostsPerLabel = 100;

maxNumberOfLabels = 3;

function listEntries10(json) {

var ul = document.createElement('ul');

var maxPosts = (json.feed.entry.length <= maxNumberOfPostsPerLabel) ?

json.feed.entry.length : maxNumberOfPostsPerLabel;

for (var i = 0; i < maxPosts; i++) {

var entry = json.feed.entry[i];

var alturl;

for (var k = 0; k < entry.link.length; k++) {

if (entry.link[k].rel == 'alternate') {

alturl = entry.link[k].href;

break;

}

}

var li = document.createElement('li');

var a = document.createElement('a');

a.href = alturl;

if(a.href!=location.href) {

var txt = document.createTextNode(entry.title.$t);

a.appendChild(txt);

li.appendChild(a);

ul.appendChild(li);

}

}

for (var l = 0; l < json.feed.link.length; l++) {

if (json.feed.link[l].rel == 'alternate') {

var raw = json.feed.link[l].href;

var label = raw.substr(homeUrl3.length+13);

var k;

for (k=0; k<20; k++) label = label.replace("%20", " ");

var txt = document.createTextNode(label);

var h = document.createElement('b');

h.appendChild(txt);

var div1 = document.createElement('div');

div1.appendChild(h);

div1.appendChild(ul);

document.getElementById('data2007').appendChild(div1);

}

}

}

function search10(query, label) {

var script = document.createElement('script');

script.setAttribute('src', query + 'feeds/posts/default/-/'

+ label +

'?alt=json-in-script&callback=listEntries10');

script.setAttribute('type', 'text/javascript');

document.documentElement.firstChild.appendChild(script);

}

var labelArray = new Array();

var numLabel = 0;

<b:loop values='data:posts' var='post'>

<b:loop values='data:post.labels' var='label'>

textLabel = "<data:label.name/>";

var test = 0;

for (var i = 0; i < labelArray.length; i++)

if (labelArray[i] == textLabel) test = 1;

if (test == 0) {

labelArray.push(textLabel);

var maxLabels = (labelArray.length <= maxNumberOfLabels) ?

labelArray.length : maxNumberOfLabels;

if (numLabel < maxLabels) {

search10(homeUrl3, textLabel);

numLabel++;

}

}

</b:loop>

</b:loop>

</script>

</div>

</div>

</b:if>

#source : http://www.modalgratis.com/2011/04/tutorial-bolg-cara-membuat-related-post.html

How to enable VirtualBox Windows XP FullScreen with VboxGuestAdditions.iso on Ubuntu

Yesterday, i had a little bit problem with this "How to enable VirtualBox Windows XP FullScreen with VboxGuestAdditions.iso on Ubuntu?"

and yeah . . . i got a bit head-ache. . . but take a look,
what i found after googling around. . .

To fix this problem you ve 2 ways possible :

1. Download VBoxGuestAdditions.iso from here and put it in directory
/usr/share/virtualbox :

root@ubuntu:~# cd /usr/share/virtualbox

 root@ubuntu:/usr/share/virtualbox# wget http://www.pc-freak.net/files/VBoxGuestAdditions.iso

2. Download and install virtualbox-guest-additions-iso_4.1.2-1_all.deb



 root@ubuntu:~# dpkg -i virtualbox-guest-additions-iso_4.1.2-1_all.deb

Next to enable and install guest additions once again use menus:

Devices -> Install Guest Additions

VirtualBox Install Guest Additions Ubuntu Screenshot

VirtualBox Install Guest Additions Ubuntu Screenshot

The screen to appear next will be similar to:

VBox guest Additions windows Ubuntu

Further Follow the step by step :
1.next>>next>>next until finish
2.restart the Vbox
and
3.Windows will appear in Full screen in VirtualBox. . .

#source : http://www.pc-freak.net/blog/how-to-enable-virtualbox-windows-xp-fullscreen-with-vboxguestadditions-iso-on-ubuntu-11-10-linux/

Ubuntu::How to install Zoneminder on Ubuntu?

install zoneminder

3.4 Install Zoneminder

$ sudo apt-get install zoneminder

Installation should go on with no complications. If needed, fix broken dependencies with

$ sudo apt-get -f install

Instruct apache what to do with Zoneminder a force a reload:

$ sudo ln -s /etc/zm/apache.conf /etc/apache2/conf.d/zoneminder.conf

$ sudo /etc/init.d/apache2 force-reload

For zm you need to run

$ sudo mysql -u root -p < /usr/share/zoneminder/db/zm_create.sql

$mysql -u root -p

>grant select,insert,update,delete on zm.* to 'zmuser'@localhost identified by 'zmpass';

           >flush privileges;

           >quit

           $ sudo chmod 4755 /usr/bin/zmfix

           $ zmfix -a

           $ sudo adduser www-data video

$ sudo nano /etc/sysctl.conf

1. Shared memory settings changed for ZoneMinder (ZM) add this at bottom (128 MB)

kernel.shmall = 134217728 kernel.shmmax = 134217728

$ sudo gedit /etc/modules

#This file contains the names of kernel modules that should be loaded
# at boot time, one per line. Lines beginning with "#" are ignored.

lp
rtc
bttv

$sudo gedit /etc/modprobe.d/options

#add these scripts below

alias char-major-81 bttv
options bttv gbuffers=16 card=150

#add these scripts below

$ sudo gedit /etc/modprobe.d/bttv

# i2c
alias char-major-89 i2c-devb
options i2c-algo-bit bit_test=1
# bttv
alias char-major-81 videodev
alias char-major-81-0 bttv

options bttv card=150

Ubuntu::How to install mysql-server,apache2,php5&phpmyadmin on Ubuntu

1.install MYSQL-->>

sudo apt-get install mysql-server mysql-client

dependency : mysql-common libnet-daemon-perl libplrpc-perl libdbi-perl libmysqlclient16
libdbd-mysql-perl mysql-client-core-5.1 mysql-client-5.1
mysql-server-core-5.1 mysql-server-5.1 libhtml-template-perl mysql-client
mysql-server

2.install apache2--->

sudo apt-get install apache2

dependency : libssl0.9.8 libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap
apache2.2-bin apache2-utils apache2.2-common apache2-mpm-worker apache2

3.install php5 --->

sudo apt-get install php5 libapache2-mod-php5 php5-mysql php5-curl php5-gd php5-idn php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-mhash php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl php5-json

dependency : apache2-mpm-prefork php5-common libapache2-mod-php5 mlock libc-client2007e
libmcrypt4 libming1 libt1-5 libtidy-0.99-0 php5-cli php-pear php5 php5-curl
php5-gd php5-idn php5-imagick php5-imap php5-mcrypt php5-memcache php5-ming
php5-mysql pslib1 php5-ps php5-pspell php5-recode php5-snmp php5-sqlite
php5-tidy php5-xmlrpc php5-xsl

4.install phpmyadmin --->

sudo apt-get install phpmyadmin

dependency : dbconfig-common wwwconfig-common javascript-common libjs-mootools phpmyadmin

Oracle::PLSQL named system exceptions

these're types of named system exceptions. . . .

DUP_VAL_ON_INDEX
ORA-00001
You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.

TIMEOUT_ON_RESOURCE
ORA-00051
You were waiting for a resource and you timed out.

TRANSACTION_BACKED_OUT
ORA-00061
The remote portion of a transaction has rolled back.

INVALID_CURSOR
ORA-01001
You tried to reference a cursor that does not yet exist. This may have happened because you’ve executed a FETCH cursor or CLOSE cursor before OPENing the cursor.

NOT_LOGGED_ON
ORA-01012
You tried to execute a call to Oracle before logging in.

LOGIN_DENIED
ORA-01017
You tried to log into Oracle with an invalid username/password combination.

NO_DATA_FOUND
ORA-01403
You tried one of the following:
1. You executed a SELECT INTO statement and no rows were returned.
2. You referenced an uninitialized row in a table.
3. You read past the end of file with the UTL_FILE package.

TOO_MANY_ROWS
ORA-01422
You tried to execute a SELECT INTO statement and more than one row was returned.

ZERO_DIVIDE
ORA-01476
You tried to divide a number by zero.

INVALID_NUMBER
ORA-01722
You tried to execute an SQL statement that tried to convert a string to a number, but it was unsuccessful.

STORAGE_ERROR
ORA-06500
You ran out of memory or memory was corrupted.

PROGRAM_ERROR
ORA-06501
This is a generic “Contact Oracle support” message because an internal problem was encountered.

VALUE_ERROR
ORA-06502
You tried to perform an operation and there was a error on a conversion, truncation, or invalid constraining of numeric or character data.

CURSOR_ALREADY_OPEN
ORA-06511
You tried to open a cursor that is already open.

The syntax for the Named System Exception in a procedure is:

DECLARE
[anonymous]
BEGIN
executable_section
EXCEPTION
WHEN exception_name1 THEN
[statements]
WHEN exception_name2 THEN
[statements]
WHEN exception_name_n THEN
[statements]
WHEN OTHERS THEN
[statements]
END [procedure_name];

Oracle::How to install Oracle Designer 6i Repository

How to install Oracle Designer 6i Repository . . . .??

i ll try to present, How to install Oracle designer 6i Repository with simple way. . .

Following these steps :

1. download my designer.sql file here :
2. run the file as sys dba privilege :

sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.1.0 – Production on Sat Mar 10 13:01:45 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:

Connected to an idle instance.

SQL>

and run the sql file with :

SQL>@designer.sql

wait the generate process until finish . . . . after all preparation, log into your designer 6i with :

user : designer

pass : password

3. Go to Repository Administration Utility >>
configure your designer repository with
*DESIGNER,
*DESIGNER_INDEX,
*DESIGNER_TEMP tables space
and then?? start installation!!!
It should need very long time to wait installation progress . . . .
So, have a time to make a glass of coffee

after finished the installation . . . . . .
enjoy design your table . . . !!!

#Oracle Database 10g under Linux Ubuntu 9.10

#Developer 6i under Virtualbox 3.2.8 Ubuntu

Oracle::Playing wave on Developer 6i

How to play wave file on developer 6i??

1. Create item and set property “sound”
2. Put the code below on when_button_pressed

Go_Item(‘your_sound_item_property‘);
Read_Sound_File(‘path_of_your_waves_file‘, ‘WAVE’, ‘your_sound_item_property‘);
Play_Sound(‘your_sound_item_property‘);

example :

Go_Item(‘top_bar.playx‘);

Read_Sound_File(‘E:\bird_hawk.wav‘, ‘WAVE’, ‘top_bar.playx‘);
Play_Sound(‘top_bar.playx‘);

Oracle::How to treat “redo log” on oracle database. . .

The question here is how are the Oracle log files maintained, and what information do we have?
A couple of interesting Oracle views:
a)To view information on log files:

SELECT * FROM v$log;

b)To view information on log file history:

SELECT thread#, first_change#, TO_CHAR(first_time,’MM-DD-YY HH12:MIPM’),next_change# FROM v$log_history;

Operations on Oracle log files :

1. Forcing log file switches:

ALTER SYSTEM switch logfile;

ALTER SYSTEM checkpoint;

2. Clear A Log File If It Has Become Corrupt:

ALTER DATABASE CLEAR LOGFILE GROUP group_number;

3. This statement overcomes two situations where dropping redo logs is not possible: If there are only two log groups and if the corrupt redo log file belongs to the current group:

ALTER DATABASE CLEAR LOGFILE GROUP 4;

4. Clear A Log File If It Has Become Corrupt And Avoid Archiving:

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP group_number;

5. Use this version of clearing a log file if the corrupt log file has not been archived:

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

6. Privileges Related To Managing Log Files:

ALTER DATABASE
ALTER SYSTEM

7. Init File Parameters Related To Log Files:
log_checkpoint_timeout … set to 0
8. Managing Log File Members:

ALTER DATABASE ADD LOGFILE MEMBER ‘log_member_path_and_name’ TO GROUP group_number;

9. Adding log file group members:

ALTER DATABASE ADD LOGFILE MEMBER ‘/oracle/dbs/log2b.rdo’ TO GROUP 2;

10. Droping log file group members:

ALTER DATABASE DROP LOGFILE MEMBER log_member_path_and_name’;
ALTER DATABASE DROP LOGFILE MEMBER ‘/oracle/dbs/log3c.rdo’;

11. To create a new group of online redo log files, use the SQL statement ALTER DATABASE with the ADD LOGFILE clause:
The following statement adds a new group of redo Oracle log files to the database:

ALTER DATABASE ADD LOGFILE (‘/oracle/dbs/log1c.rdo’, ‘/ oracle/dbs/log2c.rdo’) SIZE 500K;