Stored Procedures Interview Questions
| Stored Procedures Interview Questions |
|
|
Can someone provide an example of calling an Oracle stored procedure that accepts a DATE parameter. I want to call it using SQL from DB Visualizer.
|
|
|
|
I have a select query:
select member_id from Members
where created_by = @memberId and created_by != 0
and this query returns like 8 rows of result:
I want something like this:
I want to store these 8 results and pass it to another SELECT query in the same stored procedure....
How do i do that??
|
|
|
|
I want to call the created temporary stored procedure from within my base stored procedure. Is this possible?
|
|
|
|
I Wrote a Stored Procedure,but it has error an i don't know how can I slove it,Can I trace it?
|
|
|
|
I am writing a stored procedure to pass a comma separated list of values ,on char values like'ewinst'.does anyone have ideas how do approach this??
|
|
|
|
I need to write a stored procedure that will accept as parameters two dates and an employee ID value and that will list the Order Dates and customer company names of all orders placed by the specified employee between the two dates (including orders placed on the start and end dates).
Please help? Thanks!!
|
|
|
|
I want to return Tasks by ID if a Task ID is supplied, if not supplied I want to return all Tasks. How do I accomplish this using a SQL stored procedure?
|
|