LiveSQL isn't a database you can connect to.

It's a database running in the Oracle Cloud, that you can borrow for running any Oracle SQL or PL/SQL - via a browser/web interface.

If you want a local copy of Oracle to work with w/o having to install or maintain an Oracle Database, then our VirtualBox appliance will do the trick.

You just install VirtualBox, download the appliance, import it, and click the 'start' button.

When it's running, you'll have a copy of Oracle Database 12cr2 running, with some sample data, Oracle SQL Developer & APEX already installed and ready to go.

I talk about it here in more detail.

When you're done with it, just remove the files. No registry to clean up, nothing to uninstall.

And it's all free - for learning/educational purposes.

Try like below

    Insert into PET_OWNER (OwnerID, OwnerLastName , OwnerFirstName , OwnerPhone , OwnerEmail) 
    select 1, 'Downs' , 'Marsha' , 
    '555-537-8765' , 'Marsha.downs@somewhere.com' from dual
    union all
    select 2 , 'James' , 'Richard' , 
    '555-537-7654' , 'Richard.James@somewhere.com' from dual
    union all
    select 3 , 'Frier' , 'Liz' ,
   '555-537-6543', 'Liz.Frier@somewhere.com' from dual
    union all
    select 4 , 'Trent' , 'Miles' , 
    null,'Miles.Trent@somewhere.com'  from dual

Demo in fiddle

I am not aware of any such option available in Livesql. There are various other options to accomplish this.

CSV TO SQL Converter

http://www.convertcsv.com/csv-to-sql.htm

You can use this tool to convert CSV to SQL statements. You can choose a csv file from your local machine or an URL.There are various options to change the datatype, constraints (NOT NULL etc ).You can create DMLs for delete,insert,update,select.

SQLFIDDLE:

http://sqlfiddle.com/ In this website, you have an option "Text to DDL" .You can simply enter the text from a csv file and it will created the DDL to create and populate data in a table.

Use the DDLs, DMLs to livesql when you need to run them in Oracle 12c. Otherwise many other sql query execution tools are available online.