topic Re: Creating Oracle table in Administration and Deployment

Creating Oracle table

kajal_30 — Wed, 26 Feb 2020 01:24:28 GMT

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

Re: Creating Oracle table

fdsaaaa — Wed, 26 Feb 2020 01:31:34 GMT

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

Re: Creating Oracle table

AnandVyas — Wed, 26 Feb 2020 02:21:22 GMT

Here some examples - https://documentation.sas.com/?docsetId=acreldb&docsetTarget=n05b4mygsvt845n1vnr6r5kchbjf.htm&docsetVersion=9.4&locale=en

Re: Creating Oracle table

kajal_30 — Thu, 27 Feb 2020 13:09:15 GMT

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

Re: Creating Oracle table

fdsaaaa — Thu, 27 Feb 2020 20:39:49 GMT

Obviously a table needs to be created .

You can use SAS to achieve this .

Check out the examples .