plsql - Oracle dual query -


I have a query:

  SELECT XY ('p1', 'p2 doubles From  

I know that's double but this part is XY ('p1', 'p2', 'p3', 'p3', 'p4', '100') ',' P4 ',' 100 ') Actually I'm surprised that X and Y are tables or what?

OK, I can see three possibilities:

  1. X one There is a schema, and there is a function within the Y-X schema.
  2. X is a package, either with a public pattern or in the current schema, and Y is the function defined in that package.
  3. X is a type, either with a public pattern or currently schema, and Y is a function defined in a type.

SQL * plus command DESCRIBE X or DESCRIBE XY What does the return?


Comments

Popular posts from this blog

paypal - How to know the URL referrer in PHP? -

oauth - Facebook OAuth2 Logout does not remove fb_ cookie -

wpf - Line breaks and indenting for the XAML of a saved FlowDocument? -