Latest Answer: Owner of a table is the schema name which holds the table. To change the owner just recreate the table in the new schema and drop the previous table ...
Latest Answer: Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to construct a data warehouse. ...
Latest Answer: Autonomous transactions are independent transactions that can be called from within another transaction. An autonomous transaction lets you leave the context of the calling transaction, perform some SQL operations, commit or undo those operations, and ...
Latest Answer: haiwhy equality condition does'nt work with rownum, i'm giving my explanation herethe query select * from emp where rownum=25;it fetches first record makes it rownum 1 as it does'nt match the where criteria, the record discardedit fetches 2nd record makes ...
Latest Answer: Can u please give more explanation on this NOCOPY parameter ...
Latest Answer: We can overload functions/procedures inside packages. ...
Latest Answer: Group functions returns one result per each group of the result setWhere as analytical functions returns multi rows per each group i.e. using analytical functions we may display group results along with individual rows. ...
Latest Answer: Triggers on system events can be defined at the database or schema level. A trigger defined at the database level fires for all users, and A trigger defined at the schema or table level fires only when the triggering event involves that schema or ...
Latest Answer: Hi,Database Server:It's contains the collection of objects (Table,procedure,trigger,sequence,index,etc)it's also contains the Schema and user detailswe can view the details which are in the Database serverDB dictionary:It's contains the ...
Hi, How do we display the column values of a table using cursors without knowing the column names inside the loop?
View page << Previous 7 8 9 10 [11] 12 13 14 15 16 Next >>
Go Top
