开发者

Oracle dual query

开发者 https://www.devze.com 2023-01-09 05:58 出处:网络
I have a query like this: SELECT X.Y( \'p1\', \'p2\', \'p3\', \'p4\', \'100\') FROM dual I kn开发者_如何学Pythonow what dual is but this part X.Y( \'p1\', \'p2\', \'p3\', \'p4\', \'100\') really m

I have a query like this:

SELECT X.Y( 'p1', 'p2', 'p3', 'p4', '100') 
  FROM dual

I kn开发者_如何学Pythonow what dual is but this part X.Y( 'p1', 'p2', 'p3', 'p4', '100') really makes me wonder. What does this syntaxis mean?

Are X and Y tables or what?


Well, I can see three possibilities:

  1. X is a schema, and Y is a function within X's schema.
  2. X is a package, either with a public synonym or in the current schema, and Y is a function defined in that package.
  3. X is a type, either with a public synonym or in the current schema, and Y is a function defined in the type.

What does the SQL*Plus command DESCRIBE X or DESCRIBE X.Y return?

0

精彩评论

暂无评论...
验证码 换一张
取 消