Oracle Database Getting started with Oracle Database Hello world! from table

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

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';


Got any Oracle Database Question?