This is one of those \"there\'s gotta be a better way\" questions. Let me set up the problem, then I\'ll give you my hacked solution, and perhaps you can suggest a better solution. Thanks!
I have to generate PL-SQL code, with some common code(invariable) and a variable code. I don\'t want to use any external tools.
Here is my simple PL/SQL program: DECLARE CURSOR c1 is SELECT typ, specifikacia_typu, spz FROM Auta WHERE (substr(spz, 1, 2) = \'KE\' OR substr(spz, 1, 2) = \'KS\') AND ROWNUM <= 2;
Similar question, but for Oracle. Why would I not always want to choose V开发者_StackOverflow中文版ARCHAR(MAX)?Because it doesn\'t work in Oracle!You could declare all columns as VARCHAR2(4000) if yo
I have a cursor that is used to get some preliminary information for some other processing. It is possible that the query backing the cursor may not return any rows, and in these rare cases, we want t
I have a PL/SQL statement that uses EXECUTE IMMEDIATE to execute a query.However, I\'m having difficulty figuring out how to even get the text of the query that\'s being executed.I can\'t use dbms_out
Given three tables: a car table, an extras table and a link table, something like: table_car --------- int car_id
I\'ve got the following small Groovy script that just does a count of rows in the database for a specific date.
i\'m a pl/sql newbie. now i have a question about oracle type. i saw there are two types of type : CREATE OR REPLACE TYPE \"TYPE_NAME1\" AS OBJECT
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
加载中,请稍侯......