Creating Oracle table

[kajal_30]

Hi Team,

I am working on a task and want to create a table in oracle data base.Is it possible for me to use explicit SQL pass through query and create table or I need to create table in oracle using oracle commands and can only access(like insert data or update table using SAS) it using SAS? 

Thanks

Kajal  

[fdsaaaa]

Yes, you can use explicit SQL pass through to create an Oracle table from SAS

[kajal_30]

so we actually don't need to create the actual physical table ? SAS will create the physical table it self ?

[fdsaaaa]

Obviously a table needs to be created  . 

You can use SAS to achieve this  . 

Check out the examples . 

[AnandVyas]

Here some examples - https://documentation.sas.com/?docsetId=acreldb&docsetTarget=n05b4mygsvt845n1vnr6r5kchbjf.htm&docset...