create table?

Question

Guys i'm really confused here.

How do i create table named MANAGERS which contains only empno,ename and job columns of the original emp table for all the employess who are mangers?

Thanks

sql....oracle

Answer 1

I would suggest creating a view rather than a separate table. You can then query the view as you would a table:

create or replace view MANAGERS
AS
select empno,ename,job
from emp
where ......... (however you determine if someone is a manager)

Answer 2

CREATE TABLE managers AS
SELECT enpno, ename, job
FROM emp
WHERE upper(job) = 'MANAGERS';

By the way, capitalizations are not critical to the functions. It's just standard to capitalize commands.

Answer 3

If you are in Word go to "tables" then "insert." It will ask you how many columns and rows. Just put in the amount you need or more if you just want to fill the page. Then put in the headings you need.

Hope that helps.

Answer 4

In MS-sq. Server Integer's don't have sizes as such. this is labored out from the records style. in case you pick to alter the dimensions use Bigint, smallint or tinyint. you may wish the not NULL in case you have not have been given a default value...

Answer 5

what application are you using? i mean programming language. there are different steps depending on what language you are using.

Answer 6

what program are u useing and what are u trying to do help us