Agador Paloi

Ranch Hand
+ Follow
since Jan 24, 2006
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Agador Paloi

Without code to look at , I think you are not setting your textfield size

-Agad
7 years ago
Hello jolly ranchers -

I am trying to compile some java programs with ant and I am getting errors without any detail .

I have tried using -v on the ant command as well as verbose="yes" on the target without much help.


this is part of the output - its too big for the entire thing:



any clues would be appreciated
Agad
7 years ago
Sorry , missed the sql + reference in your Q.

If your going to execute these queries a zillion time you may want to create a function for each in a pl sql package.

Agad
8 years ago
I would put the sql into a single class if this is all the sql you have. I usually put all sql into separate classes for each object type I need to persist in the database.

Agador
8 years ago
Sounds like you want to join table1 with table2 to get a status from table2.
Query would be
SELECT
t2.id ,
t2.status
FROM
table1 t1,
table2 t2
WHERE
t1.id = t2.id


Agad
9 years ago
might want to check out Apex - Application Express.


Agad
9 years ago
Amit -
I ran your first query and got a different result :




agad
9 years ago
Eshwar -

Your query would look something like this:




Agad
9 years ago
Alsoumahi -

I think you query would look something like this



- Agad
9 years ago
Matt -
you can also code EXIT WHEN conition to accomplish the same thing.


Agad
I would agree with Paul . Maybe have your country code as a seperate column from your sequence.

Agad
10 years ago
signed on to the HR schema?
10 years ago
Could be duplicate wbt_id in table 1 or table 2?

Agad
10 years ago
Anuj -
I would read the books 'Beginning Oracle Programming' and 'Learning Oracle PL/SQL' .
You should also set up a test schema to play with and try things out.

Good luck.


Agad
10 years ago
Anuj -

I would write the DAO as a seperate class(es) . I useally design the DAO classes around the object classes I need in my application not so much the tables. A DAO class can instanciate or persist an instance of an object in my application.

Agad