+ 2

What is the sql query to list the databases?

sql query for 10g edition

3rd Apr 2017, 6:05 PM
Bharat
Bharat - avatar
12 Answers
+ 6
show databases;
3rd Apr 2017, 6:06 PM
Meharban Singh
Meharban Singh - avatar
+ 6
Bro, I have also tried it, it works, make sure you spelled that right
3rd Apr 2017, 6:11 PM
Meharban Singh
Meharban Singh - avatar
+ 6
Which software are you using?
3rd Apr 2017, 6:11 PM
Meharban Singh
Meharban Singh - avatar
+ 5
I tested in MySQL
3rd Apr 2017, 6:13 PM
Meharban Singh
Meharban Singh - avatar
+ 4
Found it, Bro, its not possible in oracle 10g Source :- http://dba.stackexchange.com/questions/27725/how-to-see-list-of-databases-in-oracle
3rd Apr 2017, 6:15 PM
Meharban Singh
Meharban Singh - avatar
+ 3
yeah it works in mysql but not in sql yaar...
3rd Apr 2017, 6:14 PM
Bharat
Bharat - avatar
+ 3
thanks alot bro.. for ur ans
3rd Apr 2017, 6:15 PM
Bharat
Bharat - avatar
+ 3
thanks for the help
3rd Apr 2017, 6:17 PM
Bharat
Bharat - avatar
+ 2
#meharban . i have tried i did not get the answer.
3rd Apr 2017, 6:08 PM
Bharat
Bharat - avatar
+ 2
oracle 10g edition..
3rd Apr 2017, 6:13 PM
Bharat
Bharat - avatar
+ 2
okay bro..i will try it..
3rd Apr 2017, 6:14 PM
Bharat
Bharat - avatar
+ 1
show databases;
3rd Apr 2017, 7:34 PM
Santosh Pothina
Santosh Pothina - avatar