my problem is tempdb
tempdb(dbname) 77752.95 MB(db size) 25345.03 MB
(unallocated size)
suppose i increased temp db size 10 gb . after increase the
temp db showing
87 gb (dbsize) 25346.03MB(unallocated
size)--unallocated size is showing same .please clarify.
hi,
the following are the outputs of sp_spaceused and
sp_tempdbspace
sp_spaceused
------------
database size unallocated size
tempdb 77752.95 MB 28026.99 MB
sp_tempdbspace
-------------
database size spaceused
tempdb 77752.945312 1.007812
the unused space in sp_spaceused is nearly 28 Gb and in
sp_tempdbspace is nearly 76 Gb
cany any one explain about this output and why its giving
different results.
How we can able to import our own template (users designed
MS-Word templates) which has many tabular columns; need to
pass some values generate by Oracle-reports9i?
Actually need to import more than 400 MS-Word templates into
Oracle Reports-9i to minimize layout design in Reports.
sequence of firing triggers for text-item is:
1)key_next_item,
2)when_validate_item,
3)post_text_item
Now i change sequence of firing triggers like
when_validate_item,key_next_item...
Is it possible to change sequence? How?
suppose there are two textfields t1,t2 in form and we have
some value in textfield t1.now the question is that how can
we copy the value of the t1 to textfield t2?
Hello All, Could any well write a query for the following
scenario.
Account(table name)
No Name Amount
1 ABCD 2000.00
2 DEFG -2000.00
3 GHIJ 3000.50
4 JKLM 4000.00
5 MNOP 6000.00
O/p Should be in this format
No Name Credit Debit
1 ABCD 2000.00 0
2 DEFG 0 -2000.00
3 GHIJ 3000.50
4 JKLM 0 -4000.00
5 MNOP 6000.00 o
could any one give appropriate query for this
Thnks in Advance
Suneel Reddy
Hello All,
Could any well write a query for the following scenario.
Account(table name)
No Name Amount
1 ABCD 2000.00
2 DEFG -2000.00
3 GHIJ 3000.50
4 JKLM 4000.00
5 MNOP 6000.00
O/p Should be in this format
No Name Credit Debit
1 ABCD 2000.00 0
2 DEFG 0 -2000.00
3 GHIJ 3000.50
4 JKLM 0 -4000.00
5 MNOP 6000.00 o
could any one give appropriate query for this
Thnks in Advance
You have just had to restore from backup and do not have
any control files. How would you go about bringing up this
database?
114
what is data access layer?
33
How would you determine who has added a row to a table?
81
Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answer:select length(trim('ram charan singh')) - length
(replace
(trim ( 'ram charan singh'),' ','')) +1 from dual
The above query working properly when space between the
words is only one &similar
But ,If the space between the words is nonuniform.
Ex:'ram charan singh is good' ans:5
i am not getting this answer using above query.
i use few third party softwares. they r all having their
own databases .
but the data is repeated in all these databases - say a
person is in all the three databases, but his name is
stoared in diff format in all databases
i want to create a centralised database ,and i dont want to
re-enter the records .
using the exisating records how can i build a centralised
database?
normally database take to refresh time 2 hours. but client
asked iwant to refresh with in 5 min that same database. do
you have any option in BO and Oracle? explain me briefly...kavi
Site Map