INSERT INTO TEST_LINK
  (h_id, h_person_id, pr_code)
  (SELECT P_id, 'P', 'l'
   FROM P_LINK_COUNT
  );

INSERT INTO TEST_LINK(h_id,h_person_id,pr_code)
((SELECT P_ID FROM P_LINK_COUNT),'PANDI','laksh')
;


Error starting at line : 99 in command -
INSERT INTO TEST_LINK(h_id,h_person_id,pr_code)
((SELECT P_ID FROM P_LINK_COUNT),'PANDI','laksh')
Error at Command Line : 100 Column : 45
Error report -
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 -  "missing right parenthesis"
*Cause:    
*Action:

INSERT INTO TEST_LINK(h_id,h_person_id,pr_code)
(SELECT P_ID FROM P_LINK_COUNT,'PANDI','laksh')
;
Error starting at line : 99 in command -
INSERT INTO TEST_LINK(hie_id,hie_person_id,practice_code)
(SELECT PATIENT_ID FROM PATIENT_LINK_COUNT,'PANDI','laksh')
Error at Command Line : 100 Column : 54
Error report -
SQL Error: ORA-00903: invalid table name
00903. 00000 -  "invalid table name"
*Cause:    
*Action:

INSERT INTO TEST_LINK(h_id, h_person_id, pr_code)
(SELECT P_id, 'P', 'l' FROM P_LINK_COUNT)
;

INSERT INTO TEST_LINK(h_id,h_person_id,pr_code)
((SELECT P_ID FROM P_LINK_COUNT),'PANDI','laksh')
;

INSERT INTO <table_name> (<column_list>) <select_query>;

INSERT INTO <table_name> (<column_list>) VALUES (<expression_list>);