Search results for query: *

I don't think you can create a trigger directly in disable mode. You still need to use 'ALTER TRIGGER <trigger name> DISABLE'.

In Forms this will probably refers to a column in your block, meaning your column is referenced as :column_name, instead of :blockname.column_name, which is more readable. In SQL*Plus, this can be also a variable referring to the keyword 'OLD' and 'NEW' in creating database triggers.

Create a temporary variable that will hold the side dishes ordered. Try this pseudocode: declare side_dishes_ordered number; -- can be GLOBAL max_allowed number := 2; begin side_dishes_ordered := 0; customer orders side dishes if side_dishes_ordered + 1 > max_allowed then error...

Try this statement: Select * from schema2.table1 minus Select * from schema2.table1; If you got error, object does not exists, then you don't have any rights to select the tables. You must be grant select privileges in order to do this.

Sorry but as far as I know you cannot set the margins programmatically. You can only do this in Layout editor. Better create one template report and use this for when creating new one.

Try this one: If your layout looks like this: Invoice # Item Price Quantity Amount And your grouping should look like this Invoice Totals Item Price Quantity Amount Inclose your totals inside your a frame. 'set Print Object On' to 'Last page'. Put...

Try this one: select refcode1, refcode2, dist1 from (select a.refcode refcode1, distance dist1 from table1 a, table2 b where a.citycode = b.citycode1) a, (select a.refcode refcode2, distance dist2 from table1 a, table2 b where a.citycode =...

my meaning of creating package body is a database package body and not inside Forms. But its quite not a friendly approach to your program.

SEM, thanks for the correction, your solution works.

If you want to get the old and new values after you update, why not something like this: 1. select the record first and store to a variable say, &quot;old&quot; 2. your update statement 3. select again or assign the current value, then store it to another variable, say &quot;new&quot; 4. use...

try use DEFINE like: DEFINE var1 = 'sometext.txt' SPOOL @var1 Maybe others have the solution to add the date.

my mistake, the declaration should be SQL> VARIABLE var1 VARCHAR2(20)

Yup, you can use bind variables. Declare the bind variable like this: SQL> VARIABLE var1 VARCHAR2 Initial the bind variable: SQL> BEGIN 2 :var1 := 'file.txt'; 3 END; 4 / To use the bind variable in spool use this: SQL> spool &var1 Then to stop spooling SQL> spool off Is this what...

For the sake of inserting, yes you can, but when you select the inserted value, it will be returned as 0, +0.00 if you specify the format like 'S990.90'

Outer join cannot be used in arbitrary expression so I think what you can do is try this statement: Select Normalised_event_ID, A_Party_Id, B_Party_Id, Full_Path, Name from Normalised_event, tblOperator where Substr(B_Party_Id,1,length(code)) = code(+) and trim(full_path) = '107' order by...