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

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -