hi, 
  i am creating a table like
CREATE TABLE EMRLoginConfigInfo(        
    GROUP_ID                          NUMBER(20,0) , 
    MAX_PASSWORD_LENGTH                  NUMBER(1,0) Default 8, 
    MIN_CHAR                          NUMBER(1,0)  default 4, 
   MIN_ALPHANUM_CHAR                  NUMBER(1,0) default 2,
  LOGIN_ATTEMPT                          NUMBER(1,0) default 3,
  LOGIN_LOCKING_PERIOD                  NUMBER(2,0) default 30,
   LAST_PW_NOTREUSE                 NUMBER(2,0) DEFAULT 5,
  PASSWORD_EXPIRY                    NUMBER(2,0) DEFAULT 30,
   CREATED_DATE                    DATE  NOT NULL,
   MODIFIED_DATE                    DATE   NOT NULL
)
/

and i am having a second table like Emrgroupmaster which is having some values in it.
select * from Emrgroupmaster;

group_id  group_name  status logo_id
1501	CCHITTES	1	
1518	NiClinic	1	
1505	00000amj	1	
1506	Columbia	1	
1509	prvshash	1	
1502	00pvtlic	1	
1503	Aksh_New	1	
1504	0PvtOrcl	1	
1512	PrivatLi	1	
1514	00aaaaaa	1	
1508	privalli	1	
1507	000000NP	1	
1513	gp_pri_k	1	
1515	00000pvt	1	
1516	peacocks	1	
1517	000pecos	1	
1511	00AshPvt	1	
1510	00emrpvt	1	

Now i have to insert the values into the above table dynamically using a single query.how is it possible?

INSERT INTO EMRLOGINCONFIGINFO
(GROUP_ID,MAX_PASSWORD_LENGTH,MIN_CHAR,MIN_ALPHANUM_CHAR,
LOGIN_ATTEMPT,LOGIN_LOCKING_PERIOD,LAST_PW_NOTREUSE,
PASSWORD_EXPIRY) 
SELECT GROUP_ID FROM EMRGROUPMASTER
/

SQL> INSERT INTO TEST_TAB(col_1, col_2, col_3)
  2    SELECT 'A' FROM Dual;
INSERT INTO TEST_TAB(col_1, col_2, col_3)
            *
ERROR at line 1:
ORA-00947: not enough values


SQL> INSERT INTO TEST_TAB(col_1)
  2   SELECT 'A' FROM Dual;

1 row created.

insert into EMRLOGINCONFIGINFO(group_id) select group_id from Emrgroupmaster

insert into EMRLOGINCONFIGINFO(group_id, CREATED_DATE, MODIFIED_DATE)
Select group_id, sysdate, sysdate from Emrgroupmaster