Categories
5G Network
Agile
Amazon EC2
Android
Angular
Ansible
Arduino
Artificial Intelligence
Augmented Reality
AWS
Azure
Big Data
Blockchain
BootStrap
Cache Teachniques
Cassandra
Commercial Insurance
C#
C++
Cloud
CD
CI
Cyber Security
Data Handling
Data using R
Data Science
DBMS
Design-Pattern
DevOps
ECMAScript
Fortify
Ethical Hacking
Framework
GIT
GIT Slack
Gradle
Hadoop
HBase
HDFS
Hibernate
Hive
HTML
Image Processing
IOT
JavaScript
Java
Jenkins
Jira
JUnit
Kibana
Linux
Machine Learning
MangoDB
MVC
NGINX
Onsen UI
Oracle
PHP
Python
QTP
R Language
Regression Analysis
React JS
Robotic
Salesforce
SAP
Selenium
Service Discovery
Service Now
SOAP UI
Spark SQL
Testing
TOGAF
Research Method
Virtual Reality
Vue.js
Home
Recent Q&A
Feedback
Ask a Question
Write a query to display a list of tables owned by the user.
Home
>
Oracle
>
Write a query to display a list of tables owned by the user.
asked
Jul 29, 2020
in
Oracle
by
Hodge
Q:
Q. Write a query to display a list of tables owned by the user.
#oracle
Answer
1
Answer
0
votes
answered
Jul 29, 2020
by
Hodge
Ans is
SELECT tablespace_name, table_name FROM user_tables;
Click here to read more about Loan/Mortgage
Click here to read more about Insurance
Many hands make light work, Share it here
Facebook
Twitter
LinkedIn
Reddit
Related questions
0
votes
Q: Suppose a table A has an Alias named AL1. Which of the query is correct to drop the AL1 alias?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: What is meant by Joins in Oracle? List the types of Joins of Oracle?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
0
votes
Q: Which of the following can refer to both local as well as remote tables?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: Which of the following can refer only to local tables?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: How to display employee records who gets more salary than the average salary in the department?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
0
votes
Q: How many numbers of tables can be created inside a table space?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: What is a sub query and what are the different types of subqueries?
asked
May 11, 2020
in
Oracle
by
JackTerrance
#oracle
0
votes
Q: Which table space can have one or more tables and can have rows from multiple tables on a single page?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: How do we display rows from the table without duplicates?
asked
May 11, 2020
in
Oracle
by
JackTerrance
#oracle
0
votes
Q: Find the error from the below SQL Query?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
0
votes
Q: What is meant by RAW datatype in Oracle?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
0
votes
Q: What do you mean by GROUP BY Clause?
asked
May 11, 2020
in
Oracle
by
JackTerrance
#oracle
0
votes
Q: What are the constraints? How to add a named PRIMARY KEY constraint in SQL?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
#primerykey
+1
vote
Q: What is a database trigger in Oracle? How to create it?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
0
votes
Q: Collection of one or more DASD volumes creates a storage group. What is the maximum limit of DASD which can be used for a storage group?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: What is the maximum size of a VARCHAR data type in DB2?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: Which table space is divided into segments of 4 to 64 pages in increments of 4 and each segment holds data for only one table?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
+1
vote
Q: What is dynamic SQL? When to use dynamic SQL?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
#dyanmic
sql
0
votes
Q: How to handle errors in PL/SQL?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#pl
sql
#oracle
0
votes
Q: What is Semijoin? How to implement it in SQL?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#semijoin
#oracle
0
votes
Q: How many databases can a DB2 system manage?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: How many clustering index we can have for a single table?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: What is not a valid DB2 data type?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: Can a DB2 system have more than one databases?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: What is a cursor variable in Oracle?
asked
May 11, 2020
in
Oracle
by
JackTerrance
#oracle
0
votes
Q: What is a View?
asked
May 11, 2020
in
Oracle
by
JackTerrance
#oracle
+1
vote
Q: What is the data type of DUAL table in oracle?
asked
Jul 29, 2020
in
Oracle
by
Hodge
#dualtable
#oracle
0
votes
Q: Which of the following are physical objects?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: Which of the following are logical objects?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
0
votes
Q: What is the use of Aggregate functions in Oracle?
asked
May 11, 2020
in
Oracle
by
JackTerrance
#oracle
...