GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 241 of 244    Print  
Data Dictionary
How can we know the all tables and views that are given for the specific user(such as USER_VIEWS,USER_OBJECTS etc.)?


  
Total Answers and Comments: 1 Last Update: September 02, 2009     Asked by: bhanumurthy03 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
September 02, 2009 01:58:21   #1  
harshljica Member Since: August 2009   Contribution: 3    

RE: Data Dictionary
Open dba_objects in that open column name owner in that mention user name and it will display the list of tables and views of specific users.
 
Is this answer useful? Yes | No

 Related Questions

No. Only the DDL(Data Definition Language )statements like create,alter,drop,truncate are auto commit.But the DML statements are should be saved by giving the commit statement after execute the query 
Latest Answer : DDL is Data Definition Language. DDL commands work on the table directly or on the table structure. By default it has auto commit.DML is Data Manipulation language that affects the data present in the table. Any addition or modification of data has to ...
Read Answers (4) | Asked by : srinivasan

Hi,I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.Pls suggestThanks
Read Answers (2) | Asked by : vishnu

Is there a way/tool to automatically export data via forms. Kinda like Dataloader that is used to import data via forms?
Read Answers (1) | Asked by : Jarred Johnson

Suppose if we have load some data from source files to data warehouse n after a few months if we again want to add some more data into same data warehouse, then how can we implement that?
Read Answers (1) | Asked by : ramya

Hi All I am very new D2K There are lots questions but not the basic questions like Diff in Data block, Normal Block. Diff in Call_forms, New_forms,Open_forms?
Read Answers (1) | Asked by : Dhiren

What are the new features of Oracle 10g over Oracle9i?. What are the possible steps to be taken care while migrating data from 9i to 10g ?If possible please list out all the differences between Oracle 9i And 10g.
Read Answers (1) | Asked by : Ishwar Goudar

What is difference between data and informationrelated to ADBMS(advanced database management system) ! plz explain in detail !
View Question | Asked by : viral

I want to use a column as blob datatype incase of long raw datatype.what is the process of data insert into and retrive from this table .
View Question | Asked by : jagannath kar

How can i sort data in Oracle Forms at runtime after executing the query for specified critirion? i used set_block_property but when click on Sort button it fetches all the data again from the base table.Thanks in advanceTasleem
Read Answers (2) | Asked by : Tasleem

1)what is the archirecture of oracle?2)Different version and their difference from oracle 7.0.3)Roll of dba.4)Various way to secure data in database.5)Working difference between access and oracle.6)how query is being process in oracle?
View Question | Asked by : bhavin


 Sponsored Links

 
Related Articles

Breaking up XML into Relational Data

Breaking up XML into Relational Data While the preceding example shows how to construct an XML representation over relational data the example in this section illustrates how you can shred XML data back into relational data This reverse operation can be useful if your application works with relation
 

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat
 

Using Oracle XML DB Repository

Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository which is an essential component of Oracle XML DB mosgoogle NOTE Oracle XML DB repository also known as XML repository is a hierarchically organ
 

Retrieving XML Data

Retrieving XML DataTo retrieve XML data from an XMLType table you can use a SELECT SQL statement just as you would if you had to query a relational table For example to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section you might issue the
 

Using XMLType for Handling XML Data in the Database

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM
 

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per
 

XML Processing in PHP and Oracle Applications

Processing XML in PHP Oracle Applications As mentioned there are two alternatives when it comes to performing XML processing in your PHP Oracle application You can perform any required XML processing using either PHP s XML extensions or PEAR XML packages or Oracle s XML features mosgoogle In the fol
 

PHP Oracle Web Development

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax is a good starting b
 

ODP.NET - Techniques to Improve Performance while Retrieving Data

ODP NET Techniques to Improve Performance while Retrieving Data Performance tuning is a great subject in Oracle Volumes of books would not be enough to cover every aspect of performance tuning in Oracle However in this section we will only discuss the fundamental performance techniques while working
 

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape