|
Please stop reposting this message. You have been told more than once what you need to do to resolve this.
|
|
|
|
|
|
Hello all. If you own an Oracle DB, could you provide me two queries?
First, get database_id and name for every database, something like this (in MSSQL):
SELECT database_id, name FROM sys.databases ORDER BY 2
and the second one, that provide every table from a database, something like that (in MSSQL):
SELECT table_name FROM %s.information_schema.tables ORDER BY 1
where %s is the database name taken from the first query.
Thank you.
|
|
|
|
|
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.
|
|
|
|
|
Thank you Scott, so, in Oracle it is not possible to list all databases ?
|
|
|
|
|
I confess I use SQL Server more these days than Oracle, but the only possible option I can find that would let you see multiple databases seems to be if you're using something like Enterprise Manager Cloud Control - https://www.mydbaworld.com/extract-databases-server-os-version-of-oem-repository/]">Extract the list of all databases with server and OS version of Oracle Enterprise Manager Cloud Control repository - My DBA World
|
|
|
|
|
I'm a new Dev.
I wanted to learn more about how google classrooms database works, Like when a student enters a Code it will then proceed to the classroom and displays all the data on that classroom? I want to learn, how does that work. Would love to hear some suggestions on where to learn more about how it works.
|
|
|
|
|
|
Good day,
How could I go about justifying a Data Warehouse for the business when there are already detailed transaction log tables in the OLTP database.
I would need to give examples of why a Data Warehouse would give more and better answers when there is already a history of all updates done on "Product" as an example.
In other words. What do I put in the Data Warehouse which is not already in the transaction log tables.
Maybe someone can provide some valuable answers.
|
|
|
|
|
I think the first thing to point out would be ..."how do you intend to get that information back out of the transaction log tables in a timely and usable way?"
There are many many resources on line that will present the argument for you e.g. Top 10 Benefits of a Data Warehouse | Datamation[^] amongst millions of others[^]
|
|
|
|
|
Thank you for the reply and for the link ....
Yes, I understand. One of the most popular arguments for having Data Warehouse is that it should enable the user to access data/information faster.
I have been thinking about these points (Benefits of having a data Warehouse) for a long time now. At the moment we do not have a very large business or production database. The largest of tables transaction log) consist of around 8 million records with 40 fields. So, I don't think speed of access is our problem however, I do agree with some of the other benefits like:
2. Enhances Conformity And Quality Of Data
3. Boosts Efficiency "to have to gather data from multiple sources"
In our case we have many different types of databases (data islands) most of them SQL Server... So, I think that the DW would solve the challenge of bringing everything together in order to give the user a better view of how the business when all data is brought together into one view ("to have to gather data from multiple sources").
Again, thank you for the reply and the information ....
|
|
|
|
|
Quote: Boosts Efficiency "to have to gather data from multiple sources"
It also lowers frustration! 
After I had posted my reply I had to spend (waste?) quite some time combining data from 3 different sources (oh - and we do have a DW here, it's just not comprehensive. So we've introduced a second one on a different platform - you couldn't make this up really)
It's "doable", especially with modern connectors and tools, but a real PITA - I seem to waste more time sourcing data to then be merged, than I do actually doing the analysis to gain insight. Like I said - frustrating.
Perhaps then that is your most compelling argument ... A DW makes it easier and quicker to bring real insight to the business, turn data into information, to drive down costs and raise profitability.
(I'm starting to sound like an advert so I will stop there  )
|
|
|
|
|
One of the primary reasons for a DW is so reports and data analysis does not impact the production (relational database) system.
I hope your "data islands" are compatible, mapping disparate systems to a single platform can be a stone cold bitch!
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
I have Delphi 11 Alexandria Professional edition.
This edition includes Firedac but I can only access local databases (hosted on the same machine that the application executable).
Can I access to MySQL or SQL databases both local or remote using UNIDAC with my Delphi edition?
|
|
|
|
|
Their homepage states that it can.
Universal Data Access Components (UniDAC) for Delphi[^]
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Yes.
Bastard Programmer from Hell 
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Looks like a license issue 
Professional editions usually support Firedac without problem (at least on my side, still on Berlin version)
|
|
|
|
|
Hey
Ive tried the INNER, LEFT, RIGHT join but it doesnt seem as if my tables are connecting. I have tables with different names and none match. I also have a main table(login/register) and want the rest to connect to that. How do I go about doing this?
Thank ya
|
|
|
|
|
Post your SQL code and table definitions and you should get some help here.
|
|
|
|
|
Hey there I just posted my tables!!
|
|
|
|
|
MekaC wrote: How do I go about doing this?
There is no way for anyone to tell you without seeing your tables. However, a generic answer is like this.
SELECT table1.*, table2.*
FROM table1
INNER JOIN table2 ON table1.field1 = table2.field1
MekaC wrote: I have tables with different names and none match.
If no tables match then you can't connect them with your login code, but why would you want to anyway?
I don't think you are using the right words to expain youself.
|
|
|
|
|
Hey there I just posted my tables!!
|
|
|
|
|
OK, but what is the question now?
|
|
|
|
|
Table structure for table `categories`
--
CREATE TABLE `categories` (
`id` int(30) NOT NULL,
`name` varchar(250) NOT NULL,
`description` text NOT NULL,
`date_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`id` int(30) NOT NULL,
`topic_id` int(30) NOT NULL,
`user_id` int(30) NOT NULL,
`comment` text NOT NULL,
`date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`date_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `forum_views`
--
CREATE TABLE `forum_views` (
`id` int(30) NOT NULL,
`topic_id` int(30) NOT NULL,
`user_id` int(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `friendship`
--
CREATE TABLE `friendship` (
`friend_id` int(11) NOT NULL,
`receiver` varchar(30) NOT NULL,
`sender` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- Table structure for table `member`
--
CREATE TABLE `member` (
`member_id` int(11) NOT NULL,
`username` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL,
`sex` varchar(100) NOT NULL,
`password` varchar(30) NOT NULL,
`day` varchar(100) NOT NULL,
`month` varchar(30) NOT NULL,
`year` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- Table structure for table `messages`
--
CREATE TABLE `messages` (
`messageid` int(11) NOT NULL,
`sender_id` int(11) NOT NULL,
`receiver_id` int(11) NOT NULL,
`message` varchar(5000) NOT NULL,
`date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `myfriends`
--
CREATE TABLE `myfriends` (
`friend_id` int(11) NOT NULL,
`myid` varchar(30) NOT NULL,
`myfriends` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- Table structure for table `output_images`
--
CREATE TABLE `output_images` (
`imageId` int(11) NOT NULL,
`imageType` varchar(255) NOT NULL,
`imageData` longblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `output_images`
--
EDIT: CHill60 - Hex Dump removed for readability
-- --------------------------------------------------------
--
-- Table structure for table `replies`
--
CREATE TABLE `replies` (
`id` int(30) NOT NULL,
`comment_id` int(30) NOT NULL,
`reply` text NOT NULL,
`user_id` int(11) NOT NULL,
`date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`date_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_member`
--
CREATE TABLE `tbl_member` (
`id` int(11) NOT NULL,
`username` varchar(255) NOT NULL,
`password` varchar(200) NOT NULL,
`email` varchar(255) NOT NULL,
`create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`comment` text NOT NULL,
`image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_member`
--
INSERT INTO `tbl_member` (`id`, `username`, `password`, `email`, `create_at`, `comment`, `image`) VALUES
(1, 'meka', '$2y$10$J/echPaDjmOaPWswI.z9BOZ21D7kaylVDvK.zAL4hhRXS8qxhcrIW', 'coti032@gmail.com', '2021-08-27 21:10:05', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `topics`
--
CREATE TABLE `topics` (
`id` int(30) NOT NULL,
`category_ids` text NOT NULL,
`title` varchar(250) NOT NULL,
`content` text NOT NULL,
`user_id` int(30) NOT NULL,
`date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(30) NOT NULL,
`name` text NOT NULL,
`username` varchar(200) NOT NULL,
`password` text NOT NULL,
`type` tinyint(1) NOT NULL DEFAULT '3' COMMENT '1=Admin,2=Staff, 3= subscriber'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
modified 2-Nov-21 6:01am.
|
|
|
|
|
Please remove all that hexdump which serves no purpose.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
