Can we create table in function?



Can we create table in function?..

Answer / Km.priti

No, you cannot directly create a table inside a function because functions are defined within the scope of a schema and do not have the necessary privileges to create tables. You should create the table first, then define the function.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

how to show all tables with 'mysql'? : Sql dba

1 Answers  


what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,


What is cold data?

1 Answers  


Enlist the advantages of sql.

1 Answers  


Define implicit and explicit cursors.

1 Answers  


how can we destroy the session, how can we unset the variable of a session? : Sql dba

1 Answers  


Define sql delete statement.

1 Answers  


what is dbms? : Sql dba

0 Answers  


What are wait events. Describe the wait event tables.

1 Answers   CTS,


what is index? : Sql dba

1 Answers  


How will we see framework of a table?

2 Answers   Accenture,


Is sql database free?

1 Answers  


Categories