Click here to Skip to main content
15,867,594 members
Home / Discussions / Database
   

Database

 
QuestionRoelf Pin
floris rudolf vieira22-Dec-21 6:58
floris rudolf vieira22-Dec-21 6:58 
AnswerRe: Roelf Pin
jschell23-Dec-21 6:12
jschell23-Dec-21 6:12 
AnswerRe: Roelf Pin
0x01AA5-Jan-22 4:44
mve0x01AA5-Jan-22 4:44 
QuestionSQL SERVER Pin
ali khan Dec202118-Dec-21 22:36
ali khan Dec202118-Dec-21 22:36 
AnswerRe: SQL SERVER Pin
Richard MacCutchan19-Dec-21 6:57
mveRichard MacCutchan19-Dec-21 6:57 
AnswerRe: SQL SERVER Pin
0x01AA5-Jan-22 4:46
mve0x01AA5-Jan-22 4:46 
Question2 queries from Oracle Pin
_Flaviu15-Dec-21 1:41
_Flaviu15-Dec-21 1:41 
AnswerRe: 2 queries from Oracle Pin
scottgp15-Dec-21 2:01
professionalscottgp15-Dec-21 2:01 
In Oracle, the equivalent for SQL Server's information_schema or sys tables would be the DICTIONARY and dynamic performance views - (https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCPT002)

Your first query doesn't make sense in an Oracle context since in Oracle you only connect to one database at a time.

The second could be (to list the tables in the connected database):

SELECT * FROM ALL_TABLES;

SELECT * FROM DBA_TABLES;
depending on your rights. See the link for the difference.

modified 15-Dec-21 8:07am.

GeneralRe: 2 queries from Oracle Pin
_Flaviu15-Dec-21 2:41
_Flaviu15-Dec-21 2:41 
GeneralRe: 2 queries from Oracle Pin
scottgp15-Dec-21 3:05
professionalscottgp15-Dec-21 3:05 
QuestionHow does google classrooms classroom code works? Pin
Member 1546436511-Dec-21 19:43
Member 1546436511-Dec-21 19:43 
AnswerRe: How does google classrooms classroom code works? Pin
CHill6013-Dec-21 1:07
mveCHill6013-Dec-21 1:07 
QuestionData Warehouse vs Transaction Log tables Pin
Member 100956563-Dec-21 0:28
Member 100956563-Dec-21 0:28 
AnswerRe: Data Warehouse vs Transaction Log tables Pin
CHill606-Dec-21 6:46
mveCHill606-Dec-21 6:46 
GeneralRe: Data Warehouse vs Transaction Log tables Pin
Member 100956567-Dec-21 21:32
Member 100956567-Dec-21 21:32 
GeneralRe: Data Warehouse vs Transaction Log tables Pin
CHill607-Dec-21 21:57
mveCHill607-Dec-21 21:57 
AnswerRe: Data Warehouse vs Transaction Log tables Pin
Mycroft Holmes8-Dec-21 11:59
professionalMycroft Holmes8-Dec-21 11:59 
QuestionAbout Delphi 11 Professional Edition Pin
Member 1543566318-Nov-21 2:52
Member 1543566318-Nov-21 2:52 
AnswerRe: About Delphi 11 Professional Edition Pin
#realJSOP24-Nov-21 23:49
mve#realJSOP24-Nov-21 23:49 
AnswerRe: About Delphi 11 Professional Edition Pin
Eddy Vluggen6-Dec-21 9:04
professionalEddy Vluggen6-Dec-21 9:04 
AnswerRe: About Delphi 11 Professional Edition Pin
0x01AA6-Jan-22 9:34
mve0x01AA6-Jan-22 9:34 
QuestionConnecting DB tables Pin
MekaC31-Oct-21 20:48
MekaC31-Oct-21 20:48 
AnswerRe: Connecting DB tables Pin
David Mujica1-Nov-21 3:28
David Mujica1-Nov-21 3:28 
GeneralRe: Connecting DB tables Pin
MekaC1-Nov-21 15:59
MekaC1-Nov-21 15:59 
AnswerRe: Connecting DB tables Pin
Member 153296131-Nov-21 3:53
Member 153296131-Nov-21 3:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.