Need your help, I am trying to create a table so that I can build the analytical/calulated view over it. I am using sql editor and this is the script which I wrtie is given below:
Now the problem which I am facing it is neither giving any success or error message whether table is created or not. What it shows is just red coloured 'X' not sure what does that mean?
question 1) Where to see the error?
question 2) what is the statement to create a table ? I have also tried with create column table sl_extract, it also didnot work.
question 3) Do we need to create a schema first and then create the table?
create type SL_EXTRACT as table(