Is there anyway to auto format column width in Oracle SQL*Plus? I'm running some queries and they are not fitting on screen completely, getting truncated. What's the proper way to see all da...
hi all,
I have 1 textbox in Oracle form, with format ##0.00 => means that we can input 33.33
But now, I want to input to this textbox value like 33.3333333333333333334
pls help me defin...
I need to create a report in Crystal XI that displays multiple rows horizontally.
I have attached an spreadsheet showing a sample of the table and also how I need to report the data. Any h...
I have a table (in an Oracle 10g DB) with millions of rows and a column setup for varchar2(2000). Most of my inserts in this column are somewhat small (usu. less than 200 characters) but I ha...
One of our site is having some peculiar problem. When they are
running a procedure they are getting ORA-01089 immediate shutdown in progress
error. Same time they were able to login to the...
I have a query that is giving me issues with regards to getting a running total everytime new inventory is added. I have 2 tables, stock_receiving and stock_items. Stock receiving is where is ...
How to implement password complexity and account lockouts in Oracle?
In ORACLE procedure I am updating my table but before I commit I want to varify the count.
Any sysvariable that stores rows affected count?
Hi Experts ..
I have OracleEX 10g and Odp.net 11g installed on my machine, today I deinstalled Odp.net 11g, after that I could not make OracleExListener to run anymore!! each time I run i...
I'm a fairly advanced PHP/ASP.net developer, with a significant amount of SQL experience. I'm looking for permanent work in my area and there are tons of jobs asking for Oracle experience. I k...
Trying to obtain connection to Oracle 10g database from application served by Oracle HTTP server using PHP. This setup used to run in Oracle 9, upgrading it to 10.
I have backed out the appl...
I am running Oracle 10g on windows server 2003 64 bit edition. I have several databases that have grown significantly over the past few months...I looked at the undo and temp tablespaces and ...
Hi,
I have a query and i run that query in DEV environment and i saw the explain plan and same query i have run in UAT environment what i observed is the explain plan for query is different...
For some reason I cannot get the Oracle NOT IN statement to omit data in the query output.
the code below is what I have been using...
Thanks!
can you give the demo example for making date picker on oracle developer suite 10g
my email is : mfoad50@hotmail.com
Hello,
I need your help.
I've installed oracle 10g r2 database and apply patch 10.2.0.3
Than created database.
And I've managed to use dbconsole so everything was working (earlier i confi...
Have any idea how to call LogMiner in Oracle 10.2.0 ??
We have an InstallShield installer that installs Oracle and as part of that installation it runs emca.bat. We have success in our environment, but are finding that users are unable to run the ...
We have 10 column in the datafile and 3 column in our staging table. We need to pick the 7th column out of the data file and append into the 2nd column of the staging table using sql loader. ...
may i know the reason of the error
how can i resolve?
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>sqlplus /nol...
I upgrade my database to 10g. My statspack stop working! I did delete the perstat user all its objects to I can start clean statspack config. so I rin @?\RDBMS\ADMIN\SPCREATE.SQL and prom...
Hello!
In Oracle what is data type for nText of text in SQL Server?
I have a data which is more than 4000 (charachters, [sometimes]) or below of this nubmer some times... But I have more t...
Users are allowed to change the status of an item from a LOV in a drop down list. They change this value from the drop down and hit the apply change button. However, this does not work. Th...
At the time of RMAN recovery and backup database should be in archivelog mode or not...
When I use imp and exp
it is asking for password..
I dont know that..
If that is the case how can i use imp and exp utility
