mysql - How can I insert data in oracle sql developer from already created tables -


i trying input data 1 of tables links table in database, code below have found keeps putting in null, missing or doing wrong?

insert volunteer(volunteerid,membershipid,membername,memberdaytimeno) values (1,         (select membershipid membership membername = 'frances'),        (select membername membership membername = 'frances'),        (select memberdaytimeno membership membername ='frances') ); 

i using oracle sql database.

insert volunteer(volunteerid, membershipid, membername, memberdaytimeno)    select                       1, membershipid, membername, memberdaytimeno       membership membername = 'frances'; 

Comments

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -