What is a shared pool?
Answer / nishi
Memory area of oracle which consists of Library cache (recently executed sql and pl/sql statements) and Data Dictionary cache(recently used tables and indexes).
| Is This Answer Correct ? | 0 Yes | 0 No |
How to create index-by table in oracle?
What do you mean by redo log file mirroring?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
How does one get the view definition of fixed views/tables?
How to create an oracle database manually?
How to update a table row with a record?
How to add another datafile to a tablespace?
What is the function of Redo Log ?
what is null value?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c