Posts by debasisdas

What the link contains is code only and that to exactly AS PER YOUR REQUIREMENT.

But if you do not understand the code all codes will be ambiguous for you.

.440.

because that is not practical for a technical forum where most of the people post code.

440.

440

444.

4.4.4

444

Have you gone through the previously provided link ?

That is good if coach is not a member.

do you have the required drivers installed on your system ?

Does a team colleague or moderator have more authority in daniweb?

yes , they have a red hot heavy hammer.

446

448

446

yes you need to create the commands using a script.

to conform, this can't be done in a single line command.

try this

select u1.* from user_cons_columns u1 ,user_constraints u2
where u1.table_name = u2.table_name
and u1.owner = u2.owner
and u1.table_name = upper ('table_name')
and u2.constraint_type = 'P'

what about this

SELECT distinct employee_id, last_name
      FROM employees
      WHERE employee_id IN (SELECT manager_id
      FROM (SELECT manager_id, COUNT(employee_id)
      FROM employees
      WHERE manager_id IS NOT NULL
      GROUP BY manager_id
      ORDER BY COUNT(employee_id) DESC)
      WHERE ROWNUM < 9)

444

446

4/4/6

446

If you still insist, try this sample.

446

446.

you are new here.

ask the other guy :)

444

4.4.4

4.4.4

444

Let me tell you databases are not created at run time, for what ever reason.

450

Please check your connection string.

434

428

428

428

428

428

432

422

426..

426

.428.

but my question is if you want to merge data why are you looking into dictionary objects ?

428

430

this will work if only one manager has max number of employees reporting to him

SELECT employee_id, last_name
    FROM employees
    WHERE employee_id = (SELECT manager_id
    FROM (SELECT manager_id, COUNT(employee_id)
    FROM employees
    WHERE manager_id IS NOT NULL
    GROUP BY manager_id
    ORDER BY COUNT(employee_id) DESC)
    WHERE ROWNUM < 9)

.428.

428.

428