Feed aggregator

More notes on the transition to the cloud

DBMS2 - Thu, 2017-08-17 04:11

Last year I posted observations about the transition to the cloud. Here are some further thoughts.

0. In case any doubt remained, the big questions about transitioning to the cloud are “When?” and “How?”. “Whether”, by way of contrast, is pretty much settled.

1. The answer to “When?” is generally “Over many years”. In particular, at most enterprises the cloud transition will span multiple CIO’s tenure in their positions.

Few enterprises will ever execute on simple, consistent, unchanging “cloud strategies”.

2. The SaaS (Software as a Service) vs. on-premises tradeoffs are being reargued, except that proponents now spell SaaS C-L-O-U-D. (Ali Ghodsi of Databricks made a particularly energetic version of that case in a recent meeting.)

3. In most countries (at least in the US and the rest of the West), the cloud vendors deemed to matter are Amazon, followed by Microsoft, followed by Google. And so, when it comes to the public cloud, Microsoft is much, much more enterprise-savvy than its key competitors.

4. In another non-technical competitive factor: Wal-Mart isn’t the only huge company that is hostile to the Amazon cloud because of competition with other Amazon businesses.

5. It was once thought that in many small countries around the world, there would be OpenStack-based “national champion” cloud winners, perhaps as subsidiaries of the leading telecom vendors. This doesn’t seem to be happening.

Even so, some of the larger managed-economy and/or generally authoritarian countries will have one or more “national champion” cloud winners each — surely China, presumably Russia, obviously Iran, and probably some others as well.

6. While OpenStack in general seems to have fizzled, S3 compatibility has momentum.

7. Finally, let’s return to our opening points: The cloud transition will happen, but it will take considerable time. A principal reason for slowness is that, as a general rule, apps aren’t migrated to platforms directly; rather, they get replaced by new apps on new platforms when the time is right for them to be phased out anyway.

However, there’s a codicil to those generalities — in some cases it’s easier to migrate to the new platform than in others. The hardest migration was probably when the rise of RDBMS, the shift from mainframes to UNIX and the switch to client/server all happened at once; just about nothing got ported from the old platforms to the new. Easier migrations included:

  • The switch from Unix to Linux. They were very similar.
  • The adoption of virtualization. A major purpose of the technology was to make migration easy.
  • The initial adoption of DBMS. Then-legacy apps relied on flat file systems, which DBMS often found easy to emulate.

The cloud transition is somewhere in the middle between those extremes. On the “easy” side:

  • Popular database management technologies and so on are available in the cloud just as they are on-premise.
  • Major app vendors are doing the hard work of cloud ports themselves.

Nonetheless, the public cloud is in many ways a whole new computing environment — and so for the most part, customer-built apps will prove too difficult to migrate. Hence my belief that overall migration to the cloud will be very incremental.

Categories: Other

Using SQLLDR

Tom Kyte - Wed, 2017-08-16 16:26
Dear Sir, I have a problem using sqlldr where I need to add a value that does not exist in the user text file but this value is needed in the table once the data from that text file is inserted into the table. For example: User text file has value...
Categories: DBA Blogs

creating a table with columns longer than 30 characters

Tom Kyte - Wed, 2017-08-16 16:26
Hi All, I am creating a table dynamically whose one column name exceeds more than 30 characters.So i am not able to create the table . I tried by keeping the column name within double quotes( " "). But it throw me the same error. is ther...
Categories: DBA Blogs

How to unload table data to csv file - fastest way for millions of records

Tom Kyte - Wed, 2017-08-16 16:26
I have a table with 100 million rows. Table size is around 25 GB in the DB. I need to unload this data to a csv file. What is the best fastest way to do this. I was reading about external tables to do this by using CTAS but I dont think there is...
Categories: DBA Blogs

Export pivot data with a pipeline function or procedure

Tom Kyte - Wed, 2017-08-16 16:26
I need to create a function (or stored procedure???) that takes pivoted data and outputs it. An external process needs to call the function/procedure and receive the data. The amount of data rows always varies; there is no set limit. However, th...
Categories: DBA Blogs

Alfresco – Unable to see the content of folders with ‘+’ in the name

Yann Neuhaus - Wed, 2017-08-16 15:23

As you might now if you are following our blogs (see this one for example), we are using Alfresco Community Edition internally for some years now and we also have a few customers using it. Today, I will present you a small issue I faced with Alfresco which wasn’t able to display the content of a few – very specific – folders… As you will see below, it was actually not related to Alfresco but that’s a good example.

 

For some background on this issue, an end-user contacted me, saying that he wasn’t able to see the content of three folders in which he was sure there were at least some PDFs. So I checked and yes, even as an Alfresco Admin, I wasn’t able to see the content of this folder using Share. The only common point I could see with these three folders is that they all contained a “+” in their name. I recently upgraded and migrated this Alfresco environment so I was kind of sure this was somehow linked (since the folders existed and were working before the upgrade+migration). For this blog, I will use a test folder named “Test+Folder” and I’m using an Apache HTTPD as a front end. I put this folder under the Shared folder:

//alfresco_server_01/share/page/context/shared/sharedfilesURL: https://alfresco_server_01/share/page/context/shared/sharedfiles

 

Clicking on this folder’s name from the central screen or from the browsertree on the left side will result in the following screen:

Folder2URL: https://alfresco_server_01/share/page/context/shared/sharedfiles#filter=path|%2FTest%2BFolder|&page=1

 

As you can see above, the URL accessed is the correct one, it contains the “/Test+Folder” path so that’s correct (%2F is “/” and %2B is “+”). However, the screen is empty, just like if this path would not exist and on the breadcrumb, it is shown “Shared Files” while it should be “Shared Files > Test+Folder”. So in summary, the Share UI isn’t able to display the content of this folder. For testing purpose, I accessed this folder using WebDAV and AOS and these clients were able to see the content of the folder but not Share. Like I mentioned above, this Alfresco environment is using Apache HTTPD as a front-end and then mod_jk for the communication with the Tomcat. You can take a look at this blog or the official documentation for more information on this setup.

 

Since other clients were working properly, I tried to access Alfresco Share without going through the front-end (so accessing Tomcat directly) in order to ensure that the issue isn’t with Alfresco itself. By doing so, I was able to see the PDFs. If the issue isn’t with Alfresco, then it should be with the front-end and in particular with the mod_rewrite and mod_jk, in this case. The idea here is to check what are doing these two mods and then compare the outcome with the initial request and what is being transferred to the Tomcat using the access logs.

 

While doing this analysis, I found out that the mod_jk was most probably the root cause of this issue. When mod_jk is doing its job, it will decode the URL’s encoded characters like %2F for “/”, like %2B for “+”, like %20 for a space, aso… Then once the rules have been processed, it will, by default, re-encode these special characters before transmitting the request to Tomcat. However in the Tomcat access logs, it appeared that the other special characters were indeed present in their encoded format but it wasn’t the case for the “+” sign which was shown like that (so no %2B anymore).

This is an example (it’s not the real requests in the background but this is the URL on a Web browser so it gives a good example):

  • URL accessed:                    https://alfresco_server_01/share/page/context/shared/sharedfiles#filter=path|%2FTest%2BFolder|&page=1
  • URL decoded by mod_jk:  https://alfresco_server_01/share/page/context/shared/sharedfiles#filter=path|/Test+Folder|&page=1
  • URL sent to Tomcat:          https://alfresco_server_01/share/page/context/shared/sharedfiles#filter=path|%2FTest+Folder|&page=1

 

For some reasons (it looks like a bug), the mod_jk does not re-encode the “+” sign and this prevents the Tomcat in the back-end to complete the request properly. The behavior of mod_jk related to the URIs is managed using the JkOptions. This property can have the following values regarding the Forwarded URI:

  • JkOptions     +ForwardURIProxy
    • Default value in version > mod_jk 1.2.23
    • The forwarded URI will be partially re-encoded after processing inside Apache and before forwarding to Tomcat
  • JkOptions     +ForwardURICompatUnparsed
    • Default value in version = mod_jk 1.2.23
    • The forwarded URI will be unparsed so no decoding nor re-encoding
  • JkOptions     +ForwardURICompat
    • Default value in version < mod_jk 1.2.23
    • The forwarded URI will be decoded by Apache
  • JkOptions     +ForwardURIEscaped
    • The forwarded URI will be the encoded form of the URI used by ForwardURICompat

 

I’m using a fairly recent version of mod_jk on this Alfresco environment so the default value is “ForwardURIProxy”. Therefore on the paper, it should work properly since URIs will be decoded and re-encoded… However we saw above that this is working but not for the “+” sign which is not re-encoded.

 

To workaround this issue, I just updated the JkOptions to have “JkOptions     +ForwardURICompatUnparsed” in my Apache HTTPD configuration and after a reload of the conf, I was able to access the content of the folder:

Folder3URL: https://alfresco_server_01/share/page/context/shared/sharedfiles#filter=path|%2FTest%2BFolder|&page=1

 

Please note that “ForwardURICompatUnparsed” will always forward the original request URI, so rewriting URIs with mod_rewrite might not work properly, it all depends how you configured the rewrite rules and what you need to do with it. Honestly, I don’t think this issue is linked to all mod_jk versions above 1.2.23 since I was using a version 1.2.40 on RedHat before and I never noticed such issue so this might be linked to a specific mod_jk version on a specific OS (Ubuntu?). So basically if you don’t have this issue, I would suggest you to use the default JkOptions.

 

 

Cet article Alfresco – Unable to see the content of folders with ‘+’ in the name est apparu en premier sur Blog dbi services.

Oracle Java Cloud Service - Scaling and Cluster Setup for ADF

Andrejus Baranovski - Wed, 2017-08-16 12:10
Last couple of weeks I was busy preparing to my OOW'17 session about estimating Java Cloud Service performance for ADF application. I was running stress tests against various JCS instance configurations to be able to create performance estimation methodology. I will describe this methodology on OOW, but here today will list key steps required to scale up JCS instance.

Let's assume you are running single cloud node with 1 CPU and 7.5 GB RAM. This node contains WLS admin and managed server:


To scale up cloud node, simply invoke Scale Up command from the menu. Select new compute shape and confirm scale up operation:


Scale up completed:


Now go to WebLogic console and update Managed Server startup parameters, to adjust heap size to higher value:


Managed server memory can be increased up to certain amount. If more resources will be needed, at some point you will need to create multiple managed servers and connect them into cluster. This would require to define Load Balancer instance (to have single entry point to the cluster):


Cluster node must run in dedicated cloud node. If cluster is based on two managed servers, there must be two cloud nodes:


Managed servers from cloud nodes can be connected into single cluster, this can be done in WebLogic console:


Once cluster is defined, deployment becomes easy - you can deploy ADF application into cluster and it will be propagated to all nodes:


Traffic director running in load balancer instance will be automatically configured to route traffic to cluster nodes:

PurCotton Teams with Oracle Retail to Support Aggressive Annual Growth

Oracle Press Releases - Wed, 2017-08-16 12:00
Press Release
PurCotton Teams with Oracle Retail to Support Aggressive Annual Growth Renowned Chinese Retailer Builds a Solid Foundation for Continued Omnichannel Success

Redwood Shores, Calif.—Aug 16, 2017

Today, Oracle announced that PurCotton has deployed Oracle Retail Merchandise Operations Management Suite, Oracle Retail Planning and Optimization and Oracle Retail Insights to support the growth of its retail business. As a wholly-owned subsidiary of Winner Medical Group Inc., PurCotton inherits the parent company’s 20-year technology and manufacturing expertise in medical-grade cotton-based products. PurCotton is devoted to providing safe, comfortable and eco-friendly cotton products to meet consumer needs with a focus on quality life, mother and baby care, feminine care and medical care.

Since its founding in December of 2009, PurCotton has grown quickly managing 114 stores in shopping malls across China. In addition PurCotton also operates an online business to meet the demands of omnichannel consumers. PurCotton sales at TMALL.com and JD.com, two of China’s largest ecommerce platforms, have doubled for four consecutive years. Singles’ Day 2016, China’s largest online shopping festival, is an example of PurCotton’s growth with 1,180,000 on-line orders and sales of over 260 million RMB. PurCotton chose Oracle Retail for solutions that could scale and serve as a foundation for continued omnichannel growth.   

“We plan to open between 30 and 40 stores every year, with a goal of increasing our total revenue 100% annually. Our core customer base has grown to about 6 million,” said Li Jianquan, Managing Director of PurCotton Group. “We needed a strong foundation to run our retail business.  Oracle Retail has the industry experience and retail specific solutions to support our growth strategy.”

“Oracle Retail provides a complete and integrated suite of solutions from planning to execution,” said He Kaifeng, Chief Information Officer, PurCotton Group. “We needed a solution which could support our strategy, which includes our brick-and-mortar stores driving sales through multiple channels. With better visibility, insight and planning, PurCotton can better meet high customer demands.”

With the help of Accenture, PurCotton Group deployed Oracle Retail Merchandising System, Oracle Retail Merchandising Insight, Oracle Retail Merchandise Financial Planning, Oracle Retail Assortment Planning and Oracle Retail Allocation.

“Oracle Retail has built end-to-end process capabilities within our suite of applications and cloud services that can deliver individually or collectively to achieve Empowered Commerce,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “We are impressed by the growth trajectory and achievements of PurCotton and look forward to playing a role in their continued success.”

Contact Info
Matt Torres
Oracle
415-595-1584
matt.torres@oracle.com
About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Matt Torres

  • 415-595-1584

New OA Framework 12.2.6 Update 5 Now Available

Steven Chan - Wed, 2017-08-16 11:31

Web-based content in Oracle E-Business Suite Release 12 runs on the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and infrastructure. Since the initial release of Oracle E-Business Suite Release 12.2 in 2013, we have released a number of cumulative updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.6 is now available:

Oracle Application Framework (FWK) Release 12.2.6 Bundle 5 (Patch 26382210:R12.FWK.C)

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

All Oracle E-Business Suite Release 12.2.6 users should apply this patch.  Future OAF patches for EBS Release 12.2.6 will require this patch as a prerequisite. 

What's new in this update?

This bundle patch is cumulative: it includes all fixes released in previous EBS Release 12.2.6 bundle patches.

In addition, this latest bundle patch includes fixes for the following issues:

  • OA Framework pages scroll to the top of the screen when a value is selected from LOV in IE11 browser.
  • Attributes set up as a read-only text area get misaligned with other components on the page.
  • KFFLovUpdateEvent is not getting fired on selecting a value from Key Flexfield window in IE11 browser.
  • Exporting table data fails when the View Object has view links associated with it and has a different number of bind parameters and bind values.
  • tzOffset and tzId parameters are not recognized by inline date picker on switching between months.

Related Articles

Categories: APPS Blogs

Podcast: Are Microservices and APIs Becoming SOA 2.0?

OTN TechBlog - Wed, 2017-08-16 10:54

When I sent out a call for suggestions for podcast topics, one of the first to respond was Phil Wilkins,  an Oracle ACE Associate and a senior consultant at Capgemini specializing in iPaaS. Among the list of topics Phil sent is the title you see above.

The panel for this program, which includes Phil, of course, tackles that question, discusses whether monolithic applications are really an anti-pattern, and also covers polyglot microservices, governance, and other issues. So, yeah, you really should listen.

This program is ArchBeat podcast #343. It was recorded at 12:30pm EDT on Tuesday  August 1, 2017. 

Click here to listenClick here to listen The Panelists

(In alphabetical order)

Chris Richardson

Chris Richardson
Founder/CEO, Eventuate, Inc., Java Champion
GitHub

Boris Scholl

Boris Scholl
Vice President, Product Development, Oracle Cloud
GitHub

Luis Weir

Luis Weir
Oracle ACE Director; Chief Architect, Capgemini UK PLC

Phill Wilkins

Phil Wilkins
Oracle ACE Associate; Senior Consultant, Capgemini

  Additional Resources Coming Soon

In the next ArchBeat podcast Oracle ACE Leon Smiers of Capgemini, Matt Hornung from Fishbowl Solutions, and Martin Deh, a member of the Oracle Intelligent Bots Cloud Service (IBCS) team, discuss first steps and lessons learned in chatbot development. (Coming in Sept)

ROLI Harmonizes Its Global Business with NetSuite OneWorld

Oracle Press Releases - Wed, 2017-08-16 08:00
Press Release
ROLI Harmonizes Its Global Business with NetSuite OneWorld Music and Technology Innovator Positioned for Accelerated Growth with Agility, Scalability of Cloud ERP

London—Aug 16, 2017

Oracle NetSuite, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, today announced that ROLI, a music technology innovator and maker of the award-winning Seaboard instrument, has implemented NetSuite OneWorld to manage critical business processes including financials, inventory management, order management, CRM, multi-currency management for the British pound, Euro and US dollar, and multi-subsidiary management for three subsidiaries in the UK and two in the US. As a result of its implementation of NetSuite OneWorld in September 2016, ROLI is better positioned to take advantage of rapid sales growth as innovative products like the Seaboard Block and Lightpad Block become more popular to music-makers.

Founded in 2009 in London, ROLI has revolutionized the world of musical instruments. Its newest product, Seaboard Block, is the most portable and versatile model of the multi-award-winning Seaboard, a digital instrument that is an evolution of the piano keyboard. Seaboards replace the white and black keys of a piano with a pliable, touch-responsive surface that lets musicians control sound in far more ways than they can on acoustic or electronic instruments. Last year ROLI also launched BLOCKS, a modular music-making system that allows musicians to connect musical Blocks together and build their instrument as they go. As demand for its products took off, ROLI determined that it needed more comprehensive and professional business systems to meet the opportunities of its next phase of growth.

ROLI selected NetSuite OneWorld due to its 360-degree customer view, inventory management and cloud-based architecture. NetSuite OneWorld provides the flexibility, agility and scalability ROLI needed for continued growth and a real-time view of business performance.

“As a company, ROLI is focused on innovation, growth and delivering world-class experiences for its customers and music lovers everywhere,” said Mark Woodhams, Managing Director, EMEA for Oracle NetSuite. “NetSuite OneWorld is an ideal fit for those goals, as a flexible, scalable solution with global reach that can serve as the foundation to continue to build upon its success.”

NetSuite OneWorld supports 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries; customer transactions in more than 200 countries; and enables businesses to streamline their mission-critical business processes. NetSuite OneWorld supports ROLI’s worldwide growth and innovation by providing:

  • Real-time global financial consolidation. NetSuite OneWorld gives ROLI real-time visibility across all its subsidiaries, with a single financial system of record.
  • Superior inventory management that enables ROLI to plan for how much inventory it needs, track the movement of goods, and meet customer demand much more quickly.
  • Centralized order management that meets and exceeds rising customer expectations for omnichannel fulfillment across multiple sales channels by eliminating manual bottlenecks, preventing errors and establishing a smooth flow from sales quote to order fulfillment ensuring timely invoicing and payment.
  • 360-degree view of its customers allowing the company to provide better customer support and service across telephone and email channels.
  • Breadth of functionality designed for modern businesses, enabling the company to streamline mission-critical business processes and improve operational efficiency.
  • A highly scalable system with the ability to quickly and easily add functionality as a business evolves.
  • Built-in business intelligence that provides real-time insights into key business performance indicators for a unified view of the organization, and delivers a single version of truth.
  • A flexible and agile platform that enables the company to customize NetSuite to meet its business requirements and to integrate with other third-party systems to meet its specific needs with NetSuite’s SuiteCloud Platform.
Contact Info
Christine Allen
Public Relations, Oracle NetSuite
PR@netsuite.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.com.

Follow Oracle NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Apex Plugin: Password Strength Estimator

Jeff Kemp - Tue, 2017-08-15 23:26

I needed a simple password strength prompt for users when they need to create or change their password on my website. After a bit of Googling I found the “Low-Budget Password Strength Estimator” which is supposedly used by Dropbox, so you know it’s good :)

This simple javascript library runs entirely within the client’s browser, and when presented with a candidate password, gives a score from 0 (very poor) to 4 (very good). It can also return extra feedback, including a warning message for poor passwords, as well as suggestions for making a password more secure.

preview-verypoor

So I’ve created a very simple Dynamic Action plugin (try the demo here) that allows you to add this functionality to any item on your page. You can specify a minimum length for the password, and can override the default messages for each score. You can also select whether or not the feedback warnings or suggestions are shown.

preview-poor

It seems to catch a lot of poor passwords, including ones comprising common words and names, and ones involving a simple sequence or repetition.

preview-good

preview-strong

Obviously it’s only really useful for password entry fields; but don’t use it on your Login page!

Download from: https://github.com/jeffreykemp/jk64-plugin-passwordstrength


Filed under: APEX, Oracle Tagged: APEX, passwords, plug-ins

extproc, database characteset and server characterset

Tom Kyte - Tue, 2017-08-15 22:26
I am testing an external procedure on a shared database environment on a Linux cluster using LANG UTF8, all at 12.1.0.2 When calling a C library using extproc from a database using AL32UTF8 the call works as expected. When calling a C library us...
Categories: DBA Blogs

The Oracle Cloud user experience

Tom Kyte - Tue, 2017-08-15 22:26
For passed 2 years, I had noticed the Oracle Cloud has been added many many services to the end users compare with AWS and Azure, that's great. But somehow, my experience to use the Oracle Cloud is not that great, I feel it is difficult to use in som...
Categories: DBA Blogs

Generate missing dates from a given date.

Tom Kyte - Tue, 2017-08-15 22:26
I have a table as below: CREATE TABLE FACT ( AS_OF_DATE DATE NOT NULL, F_TYPE varchar2(50) , F_VALUE NUMBER(23,10) ); With this data into it: INSERT INTO FACT (AS_OF_DATE, F_TYPE,F_VALUE) VALUES (TO_DATE('2017/03/31','yyyy/mm/dd'), 'A...
Categories: DBA Blogs

Opposite of INTERSECT in SQL

Tom Kyte - Tue, 2017-08-15 22:26
hi TOM, please tell me, what is the opposite for INTERSECT?
Categories: DBA Blogs

Display Chinese Character

Tom Kyte - Tue, 2017-08-15 22:26
I have a test db from the client that allows you to see Chinese characters if you copy and paste them, but if I run a insert query I see "?????". I have this configuration: NLS_CHARACTERSET WE8MSWIN1252 NLS_NCHAR_CHARACTERSET AL16UTF16 The old ...
Categories: DBA Blogs

How to retrieve bidirectional parent-child dependencies of a given table

Tom Kyte - Tue, 2017-08-15 22:26
Hello Oracle Masters, I'm trying to retrieve the column-table dependencies using the primary key/foreign key relations of a given table, but with another table as stop clause. I've been trying my luck with the recursive subquery factoring method m...
Categories: DBA Blogs

Oracle FullText - classifying PDF/DOCX file

Tom Kyte - Tue, 2017-08-15 22:26
I want to use the Oracle Classifying Documents over a PDF/DOCX files. Is it possible that, as the PDF/DOCX are kept into database as BFILEs or BLOBs? I did that for CLOBs but I couldn't do it for BLOBs or BFILEs. Can anyone give me a hint, plea...
Categories: DBA Blogs

Store a query result in a variable and use in another query

Tom Kyte - Tue, 2017-08-15 22:26
I'm trying to store the result of a query in variable and then use the value in another query. The simplified script below works if I select all and hit F5. However, the result goes to the script output screen. If I select all and run statement to ge...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator