I am making a test. I have all tests in rows, so my rows looks like this; ID|TEST ----------------------------------
I writing an application using Oracle 10g. I am currently facing this problem. I take in \"filename\" as parameter of type varchar2.
It looks like #temptables created using dynamic SQL via the EXECUTE string method have a different scope and can\'t be referenced by \"fixed\" SQLs in the same stored procedure.
I want to create backup SQL tables using variable names. something along the lines of开发者_如何学Python
I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this directly in SQL?
I have a stored procedure which is returning me about 50 columns. I want to write a query, where I will be able to select a particular column from the list of column returned by the SP.
Here is my scenario, I\'m creating a dynamic query using a select statement which uses functions to generate the query. I am storing it into a variable and running it using exec. i.e.
I\'m in the course of doing some schema migrations, and would like to know if it\'s possible or advis开发者_StackOverflow社区able to run every stored procedure, view and function in my database as an
At work we have a number of databases that we need to do the same operations on.I would like to write 1 SP that would loop over operations and set开发者_StackOverflow中文版 the database at the beginni
I am trying to use a strong ref cur with dynamic sql statment but it is giving out an error,but when i use weak cursor it works,Please explain what is the reason and please
加载中,请稍侯......