Example
Create a simple table
create table MY_table (
what varchar2(10),
who varchar2(10),
mark varchar2(10)
);
Insert values (you can omit target columns if you provide values for all columns)
insert into my_table (what, who, mark) values ('Hello', 'world', '!' );
insert into my_table values ('Bye bye', 'ponies', '?' );
insert into my_table (what) values('Hey');
Remember to commit, because Oracle uses transactions
commit;
Select your data:
select what, who, mark from my_table where what='Hello';
