REMAINDER FUNCTION,MOD FUNCTION

Remainder function does the same job with mod.
But valid for 10g,11g,12c

Mod function is valid for 8i,9i,10g,11g,12c database versions.

Some repetittions;

select abs(-10) from dual;

10

select ceil(1.3) from dual;

2

select floor(1.3) from dual;

1

select power(3,2) from dual;

9

select round(22.5) from dual;

23

select round (-22.5) from dual;

-23

select sign(-30) from dual;

-

ORA-06502 PL/SQL: numeric or value error

This problem occured when our periodic request stopped in our E-Bussiness Suite.

System stopped the request. There is not any answer for now.

Inside the request,there was control filling a table each day twice with varchar2 datatype approxametely having 7-10 size.

It means varchar2(7) and varchar(10) for each row.


But in our code varchar2 type which hold these datas has varchar2(100) size. So in there days,it filled up the table with 55 rows. It equals nearly 55x10=550 size.


So,

Our parameter was not enough sized to hold these datas.


This is a case. It might depend on the issue that you are carrying out.

Jinitiator problem 1 ----->Mozilla Firefox !

I had experimented one method that was useful at the begining for internet explorer.
Which is,


1-)Install Java jre
2-)Install Jinitiator
3-)Copy and replace jvm.dll (you can find it from googling) to JInitiator\bin\hotspot path.

But it had once worked but soon  i have had struggles at some computers.

And keep trying on Mozilla Firefox.

Caught up the solution.

Copy files from

JInitiator\bin 

to

Mozilla Firefox\plugins


Close your browser and re-open again. Here we go!

STRANGE TYPE OF PATH WHILE CHANGING DIRECTORY IN LINUX(cd)

In my scenerio, i had to change directory to media (inside CD-ROM) in Linux.

But here is a strange typing of path.
If you have a path with characters without any space between, it is easy. Just writing cd command will shortly direct you.For instance,

>cd /oracle

But what if you have a file with a long name such as 'oracle database information'

you may not be able to go into that file's directory by just writing

>cd /oracle database information

It is a bit different.


For instance i had a cd installed on my desktop with 'OL5.9 x86_64 dvd 20130111'

To go into directory Server which is located inside it, i have to write reverse slash before the spaces inside path then space can be set respectively.

Just like here;

HOW TO CREATE TKPROF FILE FROM A TRACE FILE IN IBM AIX SERVER FOR AN ORACLE APPLICATION FORM

In IBM Aix server system, you have to find firstly the directory of tkprof.sh file which is located under

ora_home/.../bin

How can i find tkprof.sh file ? That is so easy. Write the code as shown below to your console (Putty,SecureCRT...etc) providing connection to your server.

It will show up the directory where tkprof.sh is located.


Next step you will go into that directory with cd (change directory) command

To execute tkproof.sh and receive and output file from your trace file, you have a format which you have to carry out.That is ;


>tkprof  <full_path_of_trace_file> <output_file> explain=apps/apps_pwd sort='(prsela,exeela,fchela)'

But here one thing you have to be aware.

while executing an sh file you need to write './' at the head of file's name.

eg.--> ./tkprof <full_path_of_trace_file> <output_file> explain=apps/apps_pwd sort='(prsela,exeela,fchela)'

Then it will extract the file to the directory of tkprof.sh file.

Here we go.