Subscribe to this list via RSS Blog posts tagged in Oracle
How to connect to Oracle DB from Ubuntu Linux. How to connect to Oracle DB using Delphi FireDAC. Delphi uses Linux(64). and Linux is ubuntu. I used "Oracle SE One" of AWS(RDS).   [Instant Client download] Download 12.2 Instant Client.  http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html I downloaded instantclient-basic-linux.x64-12.2.0.1.0.zip http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html#ic_x64_inst   Unpack it after placing it on Linux.  # unzip instantclient-basic-linux.x64-12.2.0.1.0.zip Create a directory and place the decompressed file.  instantclient_12_2 directory is made. # mkdir /opt/oracle mv instantclient_12_2 /opt/oracle/ Move this to the directory created. Create a link. # ln -s libclntsh.so.12.1 libclntsh.so ln -s libocci.so.12.1 libocci.so   Setting environment variables. # export LD_LIBRARY_PATH=/opt/oracle/instantclient_12_2:$LD_LIBRARY_PATH export PATH=/opt/oracle/instantclient_12_2:$PATH
AWS Oracle SE One FireDAC接続TFDConnection[JAPAN] 毛利です。   AWSのRDSでOracle SE Oneデータベースを作成し接続するまでを試しました。 「開発/テスト」用に関しては無料枠があるようです。 インスタンスの仕様とセキュリティ、データベースの設定をします。 全ての設定を終えて数分待てばオラクルDBのインスタンスができます。   C++Builder 10.2 Tokyoを起動しVCLで新規プロジェクトを作成します。 TFDConnectionコンポーネントを使って接続してみます。
Using FireDAC Unidirectional property for fast, low memory selection set processing I often do large Oracle database queries using FireDAC to analyze registration data about our products and customers. Most of the time I am only processing through millions of rows to create a report or chart. One of the FDQuery properties that I forget to set True is the TDFQuery's "Unidirectional" sub-property found under the FetchOptions (TFDFetchOptions) property.  By default Unidirectional is set to false as some developers will want to put the data into a grid or other container and u...
Setting up Oracle for Embarcadero ER/Studio - Part 1 In this blog post, I will be covering how easy it is for one to setup Oracle, in order to successfully work with Embarcadero's leading Enterprise Data Modeling Tool, ER/Studio. [Pre-requisites] Oracle Database 32 / 64 bit Server Edition ER/Studio Data Architect 32 / bit  DBMS Client versions for the necessary ER/Studio product installed (if on a separate machine) You may download the above software from the following location http://www.oracle.com/technetwork/database/enterprise-e...
FireDAC - universal enterprise database connectivity for iOS, Android, Windows and OSX With the release of Delphi XE5 developers now can use the advanced capabilities of FireDAC to build apps that connect with local and remote databases (via DataSnap) that run on iOS, Android, Windows and OSX. C++Builder developers can currently use FireDAC for their Windows and OSX applications (the RAD Studio Roadmap shows C++Builder support for iOS and Android coming later this year). With its powerful universal architecture FireDAC enables direct access from your application from your Android,...
FireDAC - universal enterprise database connectivity for iOS, Android, Windows and OSX With the release of Delphi XE5 developers now can use the advanced capabilities of FireDAC to build apps that connect with local and remote databases (via DataSnap) that run on iOS, Android, Windows and OSX. C++Builder developers can currently use FireDAC for their Windows and OSX applications (the RAD Studio Roadmap shows C++Builder support for iOS and Android coming later this year). With its powerful universal architecture FireDAC enables direct access from your application from your Android,...
Сколько DBA вам нужно?.. Один из "стандартных" вопросов, который мы слышим: "Зачем нам дополнительные инструменты, кроме тех, что поставляет производитель СУБД, мы и так справимся?" Я расскажу, а дальше вы думайте и решайте сами. В ИТ индустрии, как и в многих других, принято опираться на аналитические обзоры, исследования и мнения аналитиков-экспертов. Компании Gartner и Forrester, надеюсь, представлять не надо. Многие журналисты ведущих зарубежных и отечественных компьютерных изданий пристально следят за аналитичес...

Posted by on in Blogs
Want more...Platforms Platform is one the most overloaded terms in computer technology. When someone talks about supporting a platform they might be referring to an operating system platform, hardware platform, mobile platform, database platform, graphics hardware and software platform, service based platform, application based platform, a framework, or an architecture.  Operating system platforms in use today include Windows (desktop, server, and Mobile), Linux, OS X, iOS, Android, Blackberry OS, Unix (and it's vari...

Posted by on in Blogs
Special product offers for Developers during March 2011 I continue to hear from developers who tell me that they either didn't hear about previous Embarcadero product  special offers or couldn't take advantange of them at the time.   Here is a month of opportunities for all of you. There are four special offers that are available until the end of March 2011 for developers using Embarcadero  tools.  Thirty one days to take advantage of savings on our developer and database tools. Here are the currently available offers that end March 31st. Up...
Almost TSP!! : Travelling Salesman Problem Solution through PL/SQL Hi!!!!   /* PROBLEM STATEMENT Here, the salesman is given the distance chart by his/her manager based on which (s)he has to cover all the cities in the distance chart but ensure that (s)he covers the MINIMUM DISTANCE. For better text, read http://en.wikipedia.org/wiki/Travelling_salesman_problem. */         / drop table salesmans_scrambled_dist_chart; create table salesmans_scrambled_dist_chart (       source      varchar2(5),       destination varchar2(5),       distan...

Check out more tips and tricks in this development video: