Here is a snippet of my OR schema: CREATE TYPE artist_table_type AS TABLE OF REF artist_type; / CREATE TYPE track_type AS OBJECT (
I\'m trying to write a recursive function of sorts in PL/SQL. The problem is: So say table A has rows: {B, C},
I need to compare two tables in different databases and check whether the data in both tables are matching or not.
I\'m currently implementing CRUD for a project. I have a lot of many-to-many relationships. Some of them are table1_id, table2_id, and some of them have additional columns (price, amount, etc).
i want to pass a whole sql query as a lexical parameter to a stored procedu开发者_开发百科re and then execute it. Any suggestions how to do that?you may try this:
I am trying to write to a local file from a PL/SQL script. In order to do this, I am attempting to use the TEXT_IO package in PL/SQL.
I am creating a temp table in pl/sql using execute immediate & also inse开发者_开发百科rting in the table why create table.
I want to convert following function from plsql into tsql.But i am not good at in tsql and also swisssql couldnt convert it correctly.Can u look at it?Thanks
I want to test sync/async call to a procedure named pro1. For that purpose, I want to put lock call in pro1.
trigger error:=ORA-04079: invalid trigger specification the code causing that error is below: CREATE OR REPLACE TRIGGER TRGBILLINGADDRESS
加载中,请稍侯......