ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..1566
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?2 5171
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?13 15334
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
How do you run a query?
What is an implicit commit?
How do I view tables in mysql?
Is record in pl sql?
What is Materialized View? In What Scenario we Use Materialized View?
What are the advantages of sql? Explain
What are schema-level triggers?
What has stored procedures in sql and how we can use it?
Explain the commit statement.
What type of database is cloud sql?
What is the primary key?
how can we know the number of days between two given dates using mysql? : Sql dba
Write an sql query to select all records from the table?
What is pl sql architecture?