大数据

一、简介 记录一下模糊查询 分组查询以及子查询的使用 二、使用 假设有数据库中员工表employee(e_id,e_name,d_id,e_salary) 和部门表department(d_id,d_name), 2.1 分组查询 GROUP BY   按部门分组,筛选条件为部门…

  1还原数据库时出现了介质集有2个介质簇但只提供了1个的错误提示     2解决方案： 数据库备份时目标只有一个路径即可，多个路径则需要提供多个路径的备份文件。 重新备份 备份地址选一个而非多个即可

psql官方文档-12 如果在当前shell 下，如果设定 export PGPASSWORD='postgres密码' 环境变量，可以不用每次执行sql 语句或者导入一个sql 文件都输入一次密码的麻烦了。 1.设置输出结果边框 默认:/pset border 0 tes…

by Shiva Molabanti Whew.. The wait is over. Oracle finally released an Oracle BI (OBIEE) Mobile application for Android devices.  It is downloadable from Google Play at https://play.google.com/s…

by Keith Mascarenhas As part of KPI's web series on Examining Oracle BI Applications 11g, Keith Mascarenhas from KPI Partners provides an introductory look at Oracle GoldenGate.  In th…

by Nancy Hamilton Join me as I will be representing KPI University at KScope 2013, the Oracle Development Tools User Group (ODTUG) Conference, June 23 – 27 in the exciting city of New Orleans. &…

by Shiva Molabanti In general, the recommended approach for uploading the metadata repository is to use the Repository tab of the Deployment page. But you might encounter specific situations in which…

一、数据库的好处1、持久化存储数据2、可以实习结构化查询，方便管理 二、数据库概念DB：数据库（database），存储数据的“仓库”，它保存了一系列有组织的数据。DBMS：数据库管理系统（database management system）…

by Nancy Hamilton Join me as I will be representing KPI University at KScope 2013, the Oracle Development Tools User Group (ODTUG) Conference, June 23 – 27 in the exciting city of New Orleans. &…

by Shiva Molabanti In general, the recommended approach for uploading the metadata repository is to use the Repository tab of the Deployment page. But you might encounter specific situations in which…