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 |
how to show all tables with 'mysql'? : Sql dba
what is a sub query?how will you calculate working days in a month using sub query?
What is cold data?
Enlist the advantages of sql.
Define implicit and explicit cursors.
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Define sql delete statement.
what is dbms? : Sql dba
What are wait events. Describe the wait event tables.
what is index? : Sql dba
How will we see framework of a table?
Is sql database free?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)