Posts by debasisdas

4 6 6

466

466.

466

4 4 4

444

do you have any code that you are working on ?

442

442

440

Try generating the connection string using an UDL file.

4 4 0

440

Any specific reason, why your queries are rejected ?

442

446

use this

SELECT column_name FROM cols@SrcDatabase WHERE Table_name = UPPER('Emp');
or
select column_name from user_tab_cols@SrcDatabase WHERE Table_name = UPPER('Emp');

450

450

450

450

454

456

else use this

select 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)

Make proper data entry into the table, query will work.

I have already tested that.

try this

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)

that will not work , you need to sub query to fetch the data.

4.6.8

468.

what is staff_number in your query ?

468

Better get it reinstalled and try.

That is not a SQL.

You need to show effort to get any help here.

Are you getting any error message ?

you did not answer 2nd part of my question.

what is the query that you are working on ?

please read this and this.

can any body help with this?

Sure

What is the table structure and what is the query that you are working on ?

and you returned after 2 and 1/2 months to say this.

have you tried to use the above provided link ?

you need to create trigger on each of the events on the base tables.

468

470

474

472

474

474

478

482

484

488

492