A PHP Error was encountered
Severity: Notice
Message: Object of class SimplePie could not be converted to int
Filename: forums/home.php
Line Number: 309
| how do I nest a CASE statement in an INNER JOIN |
Hello,
I am trying to nest some CASE statements into INNER JOINs (one CASE per INNER JOIN).
The current code is:
SELECT
a.zone, a.ifield, a.iwhse, a.idesc, a.iposition
FROM schema.itable a
<---This is where I would like to place the INNER JOIN w/ CASE |
|
| Problem with pl/sql report |
Hi there!
Ive been working on my relational schema for a while now and just recently managed to implement it. I wanted experiment a little with it so ive decided to produce a report displaying relevant information. At the moment my schema only consists of 3 tables : a 'student' table, a 'course'... |
|
| problem with update |
I have written my simple query using update and in a file with a .sql extension. However, I cant seem to update my table and yet at the end of the input it shows me 1 row updated I would also want to know how I can do 2 updates simultaneously. Thanks. Here is the code
|
|
|
| Subtracting a negative value |
Does anyone know how Oracle's PL/SQL handles subtraction with a negative number? Really what I need to know is, given the following: (NOTE: this is NOT the code I'm working with. It's just an example to give and idea of what I'm trying to do.)
|
|
| import & export |
Sorry for the simple question...
But please i need help from you guys...
How to import and export the database in oracle..iam have been using oracle 8i in my computer...
im completely new to this environment...
please help on this..
Thanks in advance...
Shanti. |
|
|
| Toad query problem |
I have created my tables in a database using a .bat file but when I try to insert data/values into it using toad there is prompt occurring that says that table i just created does not exist but when you look at the schema browser tab the table is there.. Did I miss something? What do you think is... |
|
| Autogenerated Primary Key.. Pls Help !! |
When some datas are inserted in to a DB table from a jsp page, how do i get the primary key in my table autogenerated?? finiding out the highest value for the primary key in the table? Pls help me wid the coding in JAVA or HTML.. I use SQL*PLus. |
|
| Writing Unicode to Oracle |
Hi All,
I am having problems trying to write unicode characters to a version 10 Oracle database, using C++ and OLE DB (the same code works with MS SQL). If I insert a unicode string directly from PL SQL it works, otherwise I get nonsense when trying from my code. I have set... |
|
| advise me !! |
how are you every one??
I am student and i just started to study SQL,and now i will start studyabout Oracal . so i want ur advice to be a good student. |
|
| what is the max no of record for int Db type? |
what is the maximum limit for int in data type.suppose in our table im specifying ID as int
type and assigning it as auto increment.After the int limit what will happen?what we will be
auto increment? |
|
|
| Bind Variable Not Declared?? |
Ok, so I'm learning about procedures and functions in Oracle and I'm stuck here with my procedure. I have the function part down pretty good, but the whole returning variables with procedures through OUT mode is confusing me. My task is this: "Write a procedure that accepts a zipcode & returns the... |
|
 |
