KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I've seen discussions about this in the past, such as here . But I'm wondering if somewhere along the line, maybe 10g or 11g (we are using 11g), ORACLE has introduced any better support for "parameterized views", without needing to litter the database with all sorts of user-defined types and/or cursor definitions or sys_context variables all over. I'm hoping maybe ORACLE's added support for something that simply "just works", as per the following example in T-SQL: CREATE FUNCTION [dbo].[getSomeData] (@PRODID ROWID) RETURNS TABLE AS RETURN SELECT PRODID, A, B, C, D, E FROM MY_TABLE WHERE PRODID = @PRODID Then just selecting it as so: SELECT * FROM dbo.getSomeData(23)
Tags (comma-separated)
Save Edits
Cancel