Description:
Oracle database administration/server topics.
|
|
|
Help with ORA-01000 Error
|
| |
Hi everyone,
we have to convert a fairly big application suite to use Oracle instead of SQL Server but we do not have much experience on the latter.
After testing our app for some time we optimized all queries to use Oracle and now everything runs as expected. After all, apart being very big, its... more »
|
|
|
For Loop w/time interval
|
| |
Hi,
I need to write a FOR LOOP which uses minutes as the interval, from a start time to and end time.
So, maybe something like this (pseudo english):
For x IN (8:30 - 3:00 INTERVAL 1 minute) LOOP
.
.
.
END LOOP
Where X will be the HH:MI that the loop is performing on. I'll need access to that HH:MI to compare it against other things.... more »
|
|
|
Cheap Nike Air Max 2013 Shoes Air Max Classic BW Shoes Air Max 90 Shoes wholesale www.Buy-Good-Goods.com
|
| |
[link] Buy Good Goods PayPal Payment Discount Cheap Price Free Shipping Wholesale Nike Shoes Jordan shoes,Ugg Boots,D&G Shoes,Gucci Shoes,Dsquared2 Shoes,Prada shoes,Hogan shoes,Shox NZ R4 shoes,Aidias shoes,Puma shoes,Timberland boots,jerseys,clothes,Moncler down Jackets,Canada Goose Down Jackets,t-shirts,jeans,underwe ar,handbags,belts,wallets,sung lasses,caps,watches,Monster headphones,iphone... more »
|
|
|
update statement with unacceptable performance
|
| |
hello
I have to update (snap) the coordinates of a first table (geometry) to the cordinates of a second table (point) if the difference is > 0 and < 0.0007 meter. I wrote the following statements:
SQL> select count(*) from geometry
COUNT(*) -------- 218037
1 Zeilen ausgewählt.
SQL> select count(*) from point... more »
|
|
|
Spatial and native dynamic compilation
|
| |
We have 10.2.0.4 database used for Spatial. It runs on AIX LPAR.
Most SQL statements look like this:
SELECT FROM TABLE WHERE SDO_RELATE(B.GEOLOC, SDO_GEOMETRY(value1, value2, SDO_POINT_TYPE(:XCoord, :YCoord, NULL),NULL,NULL), 'MASK=CONTAINS+COVERS') = 'TRUE'
Plan shows access based on DOMAIN INDEX. We are looking at allocating... more »
|
|
|
Passing parameter > 32k
|
| |
Hi,
Our application is written in PHP and uses OCI and such to call stored procedures.
Aside from coding the insert statement in the PHP code, is there a way to call a stored procedure passing a parameter > 32k? What we are seeing is that anything < 32k is working fine. Once the parameter is > 32k, the procedure call does not work.... more »
|
|
|
Adding a table to a join removes parallel execution
|
| |
Hello,
In 10gR2, we had a view with a four-table join that the optimizer used
to resolve with parallel processing when queried; we've added another
table to the FROM, and now a trace shows that there's no more parallel
execution whatsoever. I can't understand why: before giving further
details here I would like to hear if someone has any idea as to why... more »
|
|
|
( HOW DOES ISLAM DIFFER FROM OTHER FAITHS? (PART 1 OF 2
|
| |
Description: Some of the Unique Features of Islam not found in other
belief systems and ways of life.
B
Simplicity, Rationality and Practicality
Islam is a religion without any mythology. Its teachings are simple
and intelligible. It is free from superstitions and irrational
beliefs. The oneness of God, the prophethood of Muhammad, and the... more »
|
|
|
Dynamic query
|
| |
Hello People
I new in this forum and I have a question about a problem for build a dynamic statement. My problem is when try to run my code from ASP or any app I have a error, I don't know that is bad in code, please below my PL*SQL. I'm not expertise in oracle but I try. Basically my problem is in the LIKE statement maybe I declared bad this sentence.... more »
|
|
|
