Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
0% Quality Score
Upvotes Received
0
Posts with Upvotes
0
Upvoting Members
0
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
0 Endorsements
Ranked #4K

18 Posted Topics

Member Avatar for narendra_jntu

[QUOTE=narendra_jntu;428910]plz... some give me the answer for this . this was asked in an interview.[/QUOTE] in 10g - g stands for grid computing.. in 9i i stands for internet with it's built in java virtual machine..

Member Avatar for Mandava PavanKumar
0
8K
Member Avatar for shapam

i have a doubt.. once i created new user called user1 in oracle database with default tablespace say user1, if i import data from user tablespace, after that the data will occupy space user tablespace only. i want to know how to move data from user tablespace to user1 tablespace. …

Member Avatar for Member #952511
0
147
Member Avatar for shapam

Hi in my database data stored in the below format. r{iq7, z|th{op, xzqiiu. i want to know the which type of format is this one and how to get orginal data using these texts... Thanks in adv.. ..

Member Avatar for adam_k
0
86
Member Avatar for maverick420

select * from all_policies; (gives all_database policies) or select * from DBA_POLICIES;(gives only dba users policies) or select * from user_policies;(gives only the particular user policies). use any of the above query u'l get the policies which ever exitsts in database

Member Avatar for shapam
0
91
Member Avatar for shapam

just now i have changed my standby database ip so now inp primary database archivelog log showing error like unable to connect standby database. so i checked in init.ora file there everything is fine. so pls suggest me how to fix this one.

0
67
Member Avatar for shapam

I am facing problem in database. i want to select tables which have been updated from last one week..

Member Avatar for seslie
0
175
Member Avatar for Majestics

actually default open_cursors are set to 300 in oracle database so you can change it to how much open_cursors you want so try the following query sql>alter system set open_cursors=500 scope=BOTH(as your wish how much open_cursors you want you just specify next to open_cursors column)

Member Avatar for shapam
0
186
Member Avatar for cricguru
Member Avatar for shapam
0
169
Member Avatar for sudheer506

[QUOTE=sudheer506;1723255]what is BCNF?[/QUOTE] boyce code normal form.. combtination of 4th and 3rd normal form..

Member Avatar for GrowTaller01
-1
217
Member Avatar for shapam

please convert this below query to plsql format select (select count(*) from cadastredefunct t where t.areacode= 'PTH01' AND T.SECTIONNUMBER = 'D' and t.defunctnumber <> 'ONGD') as total, (select count(*) from cadastredefunct t where t.areacode = 'PTH01' AND T.SECTIONNUMBER = 'D' and t.status = 'COMP' and t.defunctnumber <> 'ONGD') as completed, …

Member Avatar for Member #647493
-1
180
Member Avatar for shapam

i want to know tht how to overwrite data(Tables) with existing tables in oracle database. first i imported some tables using .dmp file then some table_names was in tht .dmp file. then again i run tht import command with tht same syntax now tht showing some tables are already exist …

Member Avatar for debasisdas
0
85
Member Avatar for shapam
Member Avatar for pritaeas
0
2K
Member Avatar for shapam

Hey buddies i want to know tht How can i redirect my sql query result to text file using sql command.

Member Avatar for Member #647493
0
114
Member Avatar for shapam

i have lots of .vob files and i want to write all those files into dvd but i don't have .ifo files and .bup files.. so pls anyone suggest me how to make new .ifo files for .vob files

Member Avatar for BTCG07
0
158
Member Avatar for shapam
0
82
Member Avatar for shapam

how can i open .java extension file in jdk software.. i used edit keyword to open the .java file but jdk is not allowing me to open the .java file.. please any one fix this problem...

Member Avatar for stultuske
0
104
Member Avatar for pokemonlegend
Member Avatar for shapam

The End.