Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
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.
+1
vote
asked
Jul 29, 2020
in
Oracle
by
Hodge
Q. Write a query to display a list of tables owned by the user.
#oracle
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jul 29, 2020
by
Hodge
Ans is
SELECT tablespace_name, table_name FROM user_tables;
Related questions
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 do we display rows from the table without duplicates?
asked
May 11, 2020
in
Oracle
by
JackTerrance
#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
+1
vote
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 many numbers of tables can be created inside a table space?
asked
May 13, 2020
in
Oracle
by
AdilsonLima
#oracle
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 a sub query and what are the different types of subqueries?
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
...