How to display databases in Oracle 11g using SQL*Plus

You can think of a MySQL “database” as a schema/user in Oracle. If you have the privileges, you can query the DBA_USERS view to see the list of schemas:

SELECT * FROM DBA_USERS;

Related Posts:

  1. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  2. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  3. SQL Error: ORA-00942 table or view does not exist
  4. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
  5. SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
  6. ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
  7. Oracle SQL Developer: Failure – Test failed: The Network Adapter could not establish the connection?
  8. Hibernate dialect for Oracle Database 11g?
  9. Query to display all tablespaces in a database and datafiles
  10. SQL error “ORA-01722: invalid number”
  11. how to fix oracle ORA-01722 invalid number error
  12. QL Error: ORA-00933: SQL command not properly ended
  13. ORA-28040: No matching authentication protocol exception
  14. ORA-00984: column not allowed here [duplicate]
  15. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  16. How to resolve ORA 00936 Missing Expression Error?
  17. SQL not a single-group group function
  18. PLS-00201 – identifier must be declared
  19. issue ORA-00001: unique constraint violated coming in INSERT/UPDATE
  20. ORA-30926: unable to get a stable set of rows in the source tables
  21. PLS-00103: Encountered the symbol “CREATE”
  22. Oracle client ORA-12541: TNS:no listener
  23. SQL error “ORA-01722: invalid number”
  24. No more data to read from socket error
  25. ORA-12899: value too large for column
  26. Oracle startup not possible – ORA-00845: MEMORY_TARGET not supported on this system – but memory size seems to be fine
  27. Oracle date format picture ends before converting entire input string
  28. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  29. SQL Error: ORA-00913: too many values
  30. UTL_FILE.FOPEN() procedure not accepting path for directory?
  31. ORA-01653: unable to extend table by in tablespace ORA-06512
  32. SQL Error: ORA-01861: literal does not match format string 01861
  33. ORA-28001: The password has expired
  34. Oracle “SQL Error: Missing IN or OUT parameter at index:: 1”
  35. Oracle SQL query for Date format
  36. sqldeveloper error : no ocijdbc11 in java.library.path on windows 7
  37. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  38. ORA-01747: invalid user.table.column, table.column, or column specification
  39. SQL Queries “00904. 00000 – “%s: invalid identifier”
  40. Convert timestamp to date in Oracle SQL
  41. grant select on view
  42. ‘NOT LIKE’ in an SQL query
  43. ORA-20002: YOU ARE NOT ALLOWED TO CHANGE THE PASSWORD FOR CRITICAL SCHEMAS
  44. How can I set a custom date time format in Oracle SQL Developer?
  45. How to copy files into a virtual box oracle box
  46. Find out the history of SQL queries
  47. Run Oracle SQL script and exit from sqlplus.exe via command prompt
  48. ORA-00904: invalid identifier
  49. ORA-00979 not a group by expression
  50. ORA-00907: missing right parenthesis
  51. error: ORA-65096: invalid common user or role name in oracle
  52. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  53. ORA-01843 not a valid month- Comparing Dates
  54. ORA-00918: column ambiguously defined in SELECT *
  55. Error ORA-00054 resource busy and acquire with NOWAIT specified or timeout expired in oracle11g
  56. Oracle error : ORA-00905: Missing keyword
  57. What does SQL Select symbol || mean?
  58. How do I limit the number of rows returned by an Oracle query after ordering?
  59. Oracle SELECT TOP 10 records
  60. Can a foreign key be NULL and/or duplicate?
  61. How to Select Top 100 rows in Oracle?
  62. ORA-12560: TNS:protocol adaptor error
  63. What does the following Oracle error mean: invalid column index
  64. ORA-00972 identifier is too long alias column name
  65. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  66. What does the following Oracle error mean: invalid column index
  67. Oracle Apex column link from LOV values
  68. PLS-00103: Encountered the symbol when expecting one of the following:
  69. ORA-00918: column ambiguously defined in SELECT *
  70. ORA-00918: column ambiguously defined in SELECT *
  71. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  72. ORA-29913: error in executing ODCIEXTTABLEOPEN callout when inserting csv into oracle
  73. ORA-01861: literal does not match format string
  74. Is there a combination of “LIKE” and “IN” in SQL?
  75. What is it exactly a BLOB in a DBMS context
  76. SQLRecoverableException: I/O Exception: Connection reset
  77. How do you create a temporary table in an Oracle database?
  78. Oracle “Partition By” Keyword
  79. How to insert date values into table
  80. Oracle SQL: Update a table with data from another table
  81. PCI\VEN_10EC&DEV_522A&SUBSYS_837D103C&REV_01
  82. ORA-12518, TNS:listener could not hand off client connection
  83. How to execute an oracle stored procedure?
  84. What is the Oracle equivalent of SQL Server’s IsNull() function?
  85. Error while trying to retrieve text for error ORA-01019
  86. SQL selecting rows by most recent date with two unique columns
  87. Comparing Dates in Oracle SQL
  88. How do I reset a sequence in Oracle?
  89. Update statement with inner join on Oracle
  90. MySQL equivalent of DECODE function in Oracle
  91. How do I use CREATE OR REPLACE?
  92. Oracle: If Table Exists
  93. DATEDIFF function in Oracle
  94. How to create id with AUTO_INCREMENT on Oracle?
  95. What is the difference between Views and Materialized Views in Oracle?
  96. How do I view the Explain Plan in Oracle Sql developer?
  97. ORA-01779: cannot modify a column which maps to a non key-preserved table
  98. ORA-01735: invalid ALTER TABLE option – Toad
  99. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  100. PLS-00049 bad bind variable While using :OLD

Leave a Comment

error code: 523