Feed aggregator

JSON object access using JSON_TABLE

Tom Kyte - Mon, 2017-08-28 21:26
Hi I have a JSON object containing complex MVA, and would like to have relational access to my JSON object using JSON_TABLE + View. The way I am doing it right now, gives me 4 rows when I query the View, and I would like the SQL to return two r...
Categories: DBA Blogs


Tom Kyte - Mon, 2017-08-28 21:26
Hello, I have a query, somehow (using no_index) I managed to make CBO produce the plan below. It suits my needs however I struggle to understand the hint in the outline (see bolted). <code> Plan hash value: 1166215027 -------------------...
Categories: DBA Blogs

Fast full scan with Index Organized Tables + Function Based Index + Insert

Tom Kyte - Mon, 2017-08-28 21:26
I've noticed I can't seem to force an index fast full scan of a function-based index on an IOT, when it's the source of data for an INSERT. Works fine if it's just a select, or if it's a function based index on a standard heap organized table. Is th...
Categories: DBA Blogs

PayWay interface

Jeff Kemp - Mon, 2017-08-28 21:22

This is just to document how my system (which was built quite a few years ago) handles credit card payments via PayWay. The interface is rather dated and the way my system uses it is a bit hackish but for what it’s worth:

Step 1. On the server, generate a unique transaction reference, e.g. id123456

Step 2. On the server, request a token via HTTP Post:


Data (all one line):


Make sure all the values are url encoded.

Some of the fields are optional. The “information_fields” is a list of custom attributes that you can add if you want.

Step 3. Read the response

The response data will be something like this:


If it doesn’t start with “token=”, I interpret it as an error message.

Step 4. On the client, redirect browser to this URL:


Step 5. After the user comes back to your site (or in a separate server job) you have to query PayWay’s system to find out the result of the transaction, using the payment reference you generated earlier. This is a REST-style interface.


This returns a JSON document listing one or more transactions for the given reference, including transactionid (e.g. 12345678901234567890), status, transactionType, paymentAmount, and settlementDate.

Step 6. For each transaction, query PayWay’s system again to get all the details, using the transactionid retrieved earlier.


This returns a JSON document with attributes including: receiptNumber, status, responseCode, responseText, transactionType, customerName, customerEmail, principalAmount, creditcard.cardScheme, creditCard.cardNumber, creditCard.expiryDateMonth, creditCard.expiryDateYear, creditCard.cardholderName, transactionDateTime, settlementDate, declinedDate, isRefundable

My system keeps track of the payment references generated in step #1, and periodically requeries PayWay to get the results (and I give up after about a day or two – this happens if the customer never completes the transaction).

Note that for all this to work, you have to first get the bank to enable both interfaces for your client – the token interface on http://www.payway.com.au) as well as the REST-style interface on api.payway.com.au. It took quite a few emails and phone calls before it was all working.

Filed under: Other

Infosys, NRN Murthy, and Vishal Sikka - No One's Smelling of Roses

Abhinav Agarwal - Mon, 2017-08-28 13:03


orporate sagas seem to come in twos. The mega-fracas that erupted in 2016 between Cyrus Mistry, then Chairman of Tata Sons, and the iconic Ratan Tata, Chairman Emeritus at Tata Sons,  was starting to come to a close by the second half of 2017 (though I fear the last words have yet to be written). Ratan Tata had annointed N Chandrasekaran, CEO of TCS, as thew Chairman of Tata Sons, and re-asserted his complete control over the sprawling Tata empire. Now comes the rather unexpected news that Vishal Sikka (@vsikka), CEO and MD of Indian IT behemoth Infosys, had tendered in his resignation, apparently unable to tolerate any longer the constant "drumbeat of distractions" from co-founder Mr. NRN Murthy, and, some speculated, a lack of support from some members of the Infosys Board itself.
Infosys' CEO has resigned, blaming its co-founders for meddling with the business https://t.co/Nhu4PBquCF pic.twitter.com/Zp85JgGbmQ
— Bloomberg Technology (@technology) August 18, 2017In particular, this is what Vishal Sikka wrote in his letter to the Board:
"Over the last many months and quarters, we have all been besieged by false, baseless, malicious and increasingly personal attacks. Allegations that have been repeatedly proven false and baseless by multiple, independent investigations. But despite this, the attacks continue, and worse still, amplified by the very people from whom we all expected the most steadfast support in this great transformation." [link]In this perhaps altogether avoidable saga, no one has come out smelling of roses - not the Infosys board, not Vishal Sikka, and not Mr Murthy.
A Retrospect for Vishal Sikkaimage credit: pexels.comLet me start off by revisiting what I had written in 2014 - "A 'Vishal' opportunity awaits Infosys" - at the time of Mr Sikka's appointment as CEO and MD of Infosys.To summarize, I had made the following points:

Was Sikka a "trophy CEO"? I had written, "There will be more than one voice heard whispering that Sikka's appointment is more of a publicity gimmick meant to save face for its iconic co-founder, Narayan Murthy, who has been unable to right the floundering ship of the software services giant." This is still a pertinent question. Once the excitement of the "trophy CEO" wore out, did Mr Murthy's interest in Vishal Sikka also wane? Conversely, once the excitement of the CEO's crown wore off for Mr Sikka, did the thorns of leading and growing a company, with close to two-hundred thousand employees, in a difficult business environment, start to prick?

Mr Murthy's return to Infosys had brought with it a controversy and questions of corporate governance as a result of his son Rohan Murthy's inclusion in the Chairman's office - "The presence of his son Rohan Murthy was seen to grate on several senior executives, and also did not go down too well with corporate governance experts." More on this later, because there is enough mud of poor corporate governance to be thrown at all parties here.

Products-vs-services. I wrote "...there is no company, with the arguable exception of IBM, that has achieved excellence in both services and products. Not Microsoft, not Oracle, not SAP." Infosys, under Vishal Sikka, had a decidedly uninspiring record in this area. Infosys, in early 2014, carved out EdgeVerve, a subsidiary, to focus on building "products and platforms." This continued with Vishal Sikka, and SAP veterans like Michael Reh, Anirban (Andy) Dey, Venkatesh Vaidyanathan, and others were brought in to. Even though EdgeVerve claimed to pay salaries on par with Google (and this link), it was however staffed at the middle-management layers mostly with veterans from the services side of its parent company, Infosys. The results were unsurprising - Michael Reh resigned in March 2016, Andy quit in July 2017, Venky in August 2017. EdgeVerve is rumoured to have cut its staff by as much as a fourth. Clearly, this was an area where Vishal Sikka was expected to make a substantial impact, but failed.

Vishal Sikka also had a tough time retaining talent. His record was decidedly mixed in this regard also. First, he hired as many as sixteen executives from SAP after joining Infosys. Several of them were hired at million-dollar salaries, prompting a similar raise for some of the senior executives at Infosys. Second, several Infosys veterans left, or were asked to leave, during Sikka's tenure. Eventually, several of Sikka's hires from SAP also quit, whether for personal, performance-related, or cultural-misfit reasons is not clearly known. Wherever Vishal Sikka lands next - and it is clear he is too talented, too bright a star to fade away into semi-retirement at some marquee VC firm in Silicon Valley - he will find it at least somewhat difficult to get the best and brightest to follow him.
The Board Games
[image credit: pexels]The Infosys board will go, sooner or later. It has failed its shareholders - utterly and completely. It failed to retain its CEO. It failed to address the concerns of an angry co-founder. It failed to adequately address in time the cloud of corporate governance hanging over the company.

If the board believed in Sikka, if they had investigated the corporate governance issues (more on this later) and found everything to be above board, then why were they unable to predict or prevent Vishal's resignation? Clearly, the Infosys board was a house divided against itself, with some members rooting for Mr Murthy, and some for Vishal Sikka.

At the root of this corporate governance fracas is Infosys' decision to acquire Israeli startup, Panaya, in 2015, for $200 million (it paid $230 million, but Panaya had $30 million in cash; the net cost of the acquisition therefore was $200 million). Panaya is (or was) an Israeli start-up founded in 2010 as a cloud-based quality management service provider to enterprise applications. In the years leading to its acquisition, Panaya had "laid off more than 25% of the company. In 2016, Panaya shut down their Israeli-based sales development and moved them to Boston and the United Kingdom and replaced their CEO." [link] More pertinently, in 2013, Panaya's 4th funding round included an investment from HPV - Hasso Plattner Ventures. Hasso Plattner is a co-founder and currently Chairman of SAP. Hasso Plattner had been a friend and mentor to Vishal Sikka. This was most likely the reason for a whistleblower's letter in Feb 2017, which alleged that the deal was overpriced, that the then-CFO, Bansal, had walked out of the board meeting convened to vote on the acquisition, that there had been conflicts of interest since SAP owned a 7% stake in Panaya, and so on. The Infosys board got the allegations investigated by its internal Audit Committee as well as by Gibson Dunn and Control Risks and no issues were found. Yet the board did not make public this report.

Some basic questions remain unanswered. When Panaya emerged as a potential acquisition, the board should have asked Vishal Sikka to recuse himself from all further dealings on the matter. Neither the board nor Sikka did.

When Rajiv Bansal, then CFO of Infosys, allegedly walked out of the board meeting convened to vote on the Panaya acquisition, the board should immediately have convened a committee to look into the matter. It did not.

When co-founder Mr N.R.N. Murthy started to make allegations of corporate governance lapses at Infosys, the board should have engaged with him and put an end to the matter. It did not. The board allowed the matter to fester.

Even the letter the board released to the public after Vishal Sikka's resignation comes off as immature. It reads like a rant, a peevish outburst.

A substantial number of members of the Infosys board will go. They are on borrowed time. Who stays and who goes will be determined by who is the most astute politician.
How Do You Solve a Problem Like Mr. Murthy?
Having broken eggs, what is the omelette Mr Murthy has in mind
[image credit: Pexels.com]Mr N.R.N. Murthy is a legend of the Indian software industry. He has been called one of India's most influentials, one of the 12-greatest entrepreneurs of our times, and a recipient of India's second-highest civilian honour, the Padma Vibhushan.

It was Mr Murthy who came out of retirement to head Infosys as its Chairman in 2013, and in an almost magical act lured Vishal Sikka to becomes Infosys' first non-founder CEO and MD, in 2014.

Mr Murthy's ire at Infosys has been directed mostly at the board, but also, indirectly, at Vishal Sikka also. It were partly his public criticisms that prompted the board to investigate the alleged lapses in the Panaya acquisition? What makes this saga curious is that, as per the Infosys board's letter, "Mr. Murthy was interviewed as part of the investigation by Gibson Dunn and Crutcher LLP in pursuance of the investigation in the Panaya acquisition, and was invited and welcomed to provide any information or evidence he believed would support the allegations being investigated. He did not provide any evidence since none exists."

Since corporate governance lapses are what have pained Mr Murthy, it would remiss to not remind people of two incidents where Mr Murthy's judgment in matters related to corporate governance seems to have erred.

First, Mr Murthy was an independent director at media house NDTV till Sep 2009. NDTV, as may be known to people, has been in the news on account of allegations of tax fraud. Most recently, in July 2017, the Income Tax Appellate Tribunal (ITAT) upheld the Income Tax department's finding that "NDTV used their own shell companies to round-trip investments of Rs 642 crore during 2009-10, making them liable for recovery of tax and penalty." [source] NDTV's founder, Prannoy Roy, and others, were charged by the Central Bureau of Investigation under the Prevention of Corruption Act as far back as 1998. It may be an inconvenient but certainly a pertinent question if Mr Murthy were to be asked what he did, or not do, as an independent director on the board of NDTV, around these allegations and issues of corporate governance.

Second, closer to home, when Mr Murthy came back to head Infosys a second time as Chairman, in June 2013, his son, Rohan Murthy joined his father in the newly-formed Chairman's office as Executive Assistant to the Chairman. At that point Mr Murthy had emphatically stated that his son would have no leadership role in the company. Less than three months later, Mr Rohan Murthy was designated Vice President, a title that few people usually earn, and that too after fifteen or more years in the industry.

Mr Murthy's concern over corporate governance seems to be somewhat newfound. It seems conveniently expedient.

A question that does need to be asked is this - has Mr Narayan Murthy become the obsessive mother-in-law that cannot bring herself to step back? After all, Mr Murthy's once described Infosys as his "middle child". Taking that analogy one step further, Vishal Sikka was like the bride he brought home for his child. Like the stereotypical "saas" (mother-in-law) in Indian movies, Mr Murthy however could not step back and allow the "child" and "bride" to find their own way.

Mr Murthy has a legion of admirers in the industry. This battle is far from over. In this battle between Mr Murthy and Infosys - its board and ex-CEO - it is only the Infosys brand that will suffer. It would be a tragedy if Mr Murthy lets his legacy end on this sour note.

This post first appeared in LinkedIn on Aug 22, 2017.

© 2017, Abhinav Agarwal. All rights reserved.

Hadoop for Database Professionals – St. Louis (7. Sep)

Tanel Poder - Mon, 2017-08-28 12:07

Here’s some more free stuff by Gluent!

We are running another half-day course together with Cloudera, this time in St. Louis on 7. September 2017.

We will use our database background and explain using database professionals terminology why “new world” technologies like Hadoop will take over some parts of the enterprise IT, why are those platforms so much better for advanced analytics over big datasets and how to use the right tool from Hadoop ecosystem for solving the right problem.

More information below. See you there!

Hadoop for Database Professionals – St. Louis

Also, Michael Rainey will deliver a SQL-on-Hadoop overview session in Portland, OR on 6. Sep 2017

NWOUG Portland Training Day 2017



NB! If you want to move to the "New World" - offload your data and workloads to Hadoop, without having to re-write your existing applications - check out Gluent. We are making history! ;-)

Oracle Hiring Five-Thousand Cloud Professionals in the United States

Oracle Press Releases - Mon, 2017-08-28 07:00
Press Release
Oracle Hiring Five-Thousand Cloud Professionals in the United States

Redwood Shores, Calif.—Aug 28, 2017

This year, Oracle is hiring more than five-thousand new engineers, consultants, sales and support people into its rapidly growing cloud business. This injection of talent will help Oracle sustain the momentum in what is already the world’s fastest growing multi-billion dollar cloud business.

“Central to Oracle’s success is our empowered, inspired and engaged workforce,” said Joyce Westerdahl, Oracle Executive Vice President, Human Resources. “We’re hiring experienced sales and engineering professionals eager to contribute to Oracle’s cloud growth and champion our products. We are also recruiting high-performing recent college graduates and offering them a world-class training program to prepare them for a career in the technology industry.”

This year, Oracle has already hired more than 2,650 cloud sales professionals and 1,500 cloud developers in the United States.

To learn more about careers at Oracle and apply for open positions, please visit https://www.oracle.com/corporate/careers/.

Contact Info
Deborah Hellinger
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.


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

Talk to a Press Contact

Deborah Hellinger

  • +1.212.508.7935

Video: Introduction to Platform Agnostic Hybrid App Development

OTN TechBlog - Mon, 2017-08-28 06:00

The way in which apps are being built is significantly changing; now even more so with the cloud and various platforms and devices that must be supported across organizations. Why write code for each platform or device when you can write once and deploy anywhere? In this on-demand Oracle Code Online session replay Oracle ACE John Sim, a consultant at Fishbowl Solutions, demonstrates how to use Oracle JET to build platform agnostic, re-usable HTML5 applications that can be run as a Desktop / Mobile App or within a browser.

This session was part of the Mobile Development track in the Oracle Code Online event held in June 2017. Other on-demand sessions in this track include:

Oracle Code Online also featured a Full Stack Web Development track, which included the following sessions, also now available for on-demand replay:





Error when using DBLINK to SQL Server from Oracle : does not support SYS_OP_C2C in this context

Tom Kyte - Mon, 2017-08-28 03:06
Helloo , I've a problem with read and save data into Oracle Database form SQL Server using DBLINK DG4ODBC. The problem is where clause condition must harcoded. Spec of Table in SQL Server is t_link (NOS NVARCHAR(10), DETAIL_SPEC NVARCHAR(M...
Categories: DBA Blogs

Order by dbms_random.value

Tom Kyte - Mon, 2017-08-28 03:06
Hi tom, To display the random order of rows every time , I give SQL> select object_id from user_objects order by dbms_random.value It displays what I wanted. but if I give SQL> select object_id from user_objects order by .88439942 -...
Categories: DBA Blogs

About show error 'PLS-00103: Encountered the symbol "_" when expecting one of the following' ?

Tom Kyte - Mon, 2017-08-28 03:06
Hi,Chris When i solve Oracle DataGuard physical standby database about GAP's problem,due to most of archived logs have not existed in dynamic performance view 'v$archived_log' and also existed in OS,therefore i need to register these archived logs m...
Categories: DBA Blogs

Handling REP-0108 in Reports runtime. Returning Image based on ID

Tom Kyte - Mon, 2017-08-28 03:06
Respected Sir, i am facing a problem. i have folder which contains .jpg pictures of employees. and in reports i am showing their pictures against their IDs. i am using this function formula. <code> function CF_2Formula return Char is DIRX VARCHA...
Categories: DBA Blogs

Anydata Performance / wrong usage?

Tom Kyte - Mon, 2017-08-28 03:06
Dear AskTOM-Team, It would be great if you can share your opinion on anydata-datatype. Background to my question is, I'm using anydata-Type in conjunction with dbms_sql. To handle a dynamic-sql with their correct datatypes. After a few tests ...
Categories: DBA Blogs

how to send email where email body more than 32 K

Tom Kyte - Mon, 2017-08-28 03:06
Hi, am using utl_smtp.data package and i have some emails where body size more than 32 K, is there any way to send these email in one email? Best Regards
Categories: DBA Blogs

SQL Loader and NLS_LANG

Tom Kyte - Mon, 2017-08-28 03:06
Hi, I need to load into oracle a text file with some decimal number in it. My database recognize the decimal separator as "." and in the flat file numbers are in the format 19.89 The problem is that the pc that I use for the import uses the "," as...
Categories: DBA Blogs

The amazing ANSI join syntax quirk

Flavio Casetta - Mon, 2017-08-28 02:39
Categories: DBA Blogs

Oracle JET Nested Data Grid for presenting Hierarchical Data Sets – with cell popup, collapse and expand, filter and zoom

Amis Blog - Mon, 2017-08-28 01:27

As part of a SaaS Enablement project we are currently working on for a customer using Oracle JET, a requirement came up to present an hierarchical data set – in a way that quickly provides an overview as well as allows access to detail information and the ability to focus on specific areas of the hierarchy. The data describes planning and availability of employees and the hierarchy is by time: months, weeks and days. One presentation that would fit the requirements bill was a spreadsheet like data grid with employees in the rows, the time hierarchy in [nested]columns and the hours planned and available in the cells. A popup that appears when the mouse hovers over a cell will present detail information for the planned activities for that day and employee. Something like this:



This article will not describe in detail how I implemented this functionality using Oracle JET – although I did and all the source code is available in GitHub: https://github.com/lucasjellema/jet-nestedheader-datagrid-planandresource .

This article is a brief testament to the versatility of Oracle JET [and modern browsers and the JavaScript ecosystem]and the strength of the Oracle JET UI component set as well as its documentation – both Cookbook for the Components and the JS API documentation. They allowed me to quickly turn the requirements into working code. And throw in some extra functionality while I was at it.

When I first looked at the requirements, it was not immediately clear to me that JET would be able to easily take on this challenge. I certainly did not rush out to give estimates to our customer – depending on the the shoulders we could stand on, this could be a job for weeks or more. However, browsing through the Oracle JET Cookbook, it did not take too long to identify the data grid (the smarter sibling of the table component) as the obvious starting point. And to our good fortune, the Cookbook as a recipe for Data Grid with Nested Headers: http://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=dataGrid&demo=nestedHeaderDataSource:

imageWith this recipe – that includes source code – as starting point, it turned out to be quite straightforward to plug in our own data, rewrite the code from the recipe to handle our specific data structure and add custom cell styling. When that was done – rather easily – it was very seductive to start adding some features, both to take on the challenge and to further woo (or wow – but not woe as I had mistyped originally) our customer.

Because the data set presented in the grid is potentially quite large, it is convenient to have ways to narrow down what is shown. An intuitive way with hierarchical data is to collapse branches of the data set that are currently not relevant. So we added collapse icons to month column headers; when a month is collapse, the icon is changed to an expand icon. Clicking the icon has the expected effect of collapsing all weeks and days under the month or expanding them. From here it is a small step to allow all months to be collapsed or expanded by single user actions – so we added icons and supporting logic to make that happen.


Also intuitive is the ability to drill down or zoom into a specific column – either a month or a week. We added that feature too – by allowing the month name or week number in the column header to be clicked upon. When that happens, all data outside the selected month and week are hidden.



Finally, and very rough at present, we added a search field. The user can currently enter a number; this is interpreted as the number of the month to filter on. However, it would not be hard to interpret the search value more intelligently – also filtering on cell content for example.



Did we not have any challenges? Well, not major stumbling blocks. Some of the topics that took a little longer to deal with:

  • understand the NestedHeaderDataGridDataSource code and find out where and how to customize for our own needs
  • create a custom module and use require to make it available in our ViewModel (see http://requirejs.org/docs/api.html#jsfiles)
  • use of Cell template and knock out tag for conditional custom cell rendering
  • capture the mouseover event in the cell template and pass the event and the cell (data) context to a custom function
  • generate a unique id for span element in cell in order to have an identifiable DOM element to attach the popup to
  • programmatically notify all subscribers to KnockOut observables that the observable has been updated (and the data grid component should refresh) (use function valueHasMutated() on observable)
  • programmatically manipulate the contents of the popup
  • take the input from the search field and use it (instantly) to filter and refresh the data grid
  • include images in a ReadMe.md in GitHub (yes, that is a very different topic from Oracle JET)
  • create an animated gif (and that too) – see the result below, using http://gifmaker.me/

I hope to describe these in subsequent blog posts.


This animated gif gives an impression of what the prototype I put together does. In short:

– present all data in an hierarchical grid

– show a popup with cell details when hovering over a cell

– collapse (and expand) months (by clicking the icon)

– drill down on (zoom into) a single month or week (by clicking the column header)

– collapse or expand all months and weeks

– filter the data in the grid by entering a value in the search field





Final Words

In the end, the customer decided to have us use the Gantt Chart to present the hierarchical data. Mainly because of its greater visual appeal (the data grid looks too much like Excel) and the more fluid ability to zoom in and out. I am sure our explorations of the data grid will come in handy some other time. And if not, they have been interesting and fun.


Source code for the article (and the nested header data grid component): https://github.com/lucasjellema/jet-nestedheader-datagrid-planandresource

Oracle JET JavaScript API Documentation

– Popup – http://www.oracle.com/webfolder/technetwork/jet/jsdocs/oj.ojPopup.html

– Datagrid – http://www.oracle.com/webfolder/technetwork/jet/jsdocs/oj.ojDataGrid.html

Oracle JET Cookbook:

– Popup Tooltip – http://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=popup&demo=tooltip

– Nested Headers with Data Grid – http://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=dataGrid&demo=nestedHeaderDataSource

– CRUD with Data Grid – http://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=crud&demo=CRUDGrid

Documentation for KnockOut – http://knockoutjs.com/documentation/introduction.html

Documentation for RequireJS – http://requirejs.org/docs/api.html#jsfiles

The foundation of JS Fiddles for JET 3.2 – https://jsfiddle.net/peppertech/a593LL2r/

Blog Article on AMIS Blog – Oracle JET – Filtering Rows in Table with Multiselect and Search Field Filters

The post Oracle JET Nested Data Grid for presenting Hierarchical Data Sets – with cell popup, collapse and expand, filter and zoom appeared first on AMIS Oracle and Java Blog.

Partner Webcast - Private Cloud Appliance & Exalogic

Join us to learn more about Oracle Systems, Engineered Systems and Storage. Learn what we understand by “Cloud Insurance” through our Systems Webcast Series for EMEA...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Whether or not to partition tables

Tom Kyte - Sun, 2017-08-27 08:46
My application has tables that are 30-40 GB (130M to 480M records) and indexes (indices) that are 10-25 GB. There is potential for significant growth. Oracle documentation recommends considering partitions when tables grow to 2GB, so I am trying ...
Categories: DBA Blogs

function data type

Tom Kyte - Sat, 2017-08-26 14:26
Hi Tom, I need to create such a function just like, create or replace function (p_name in varchar2(10), p_col1 in varchar2(10), p_col2 in varchar2(10)) is begin select p_col1, p_col2 from p_name; end; / now i need to modify the functio...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator