Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
No Answer is Posted For this Question
Be the First to Post Answer
Is id a reserved word in sql?
Is a view faster than a stored procedure?
Can we use more than one null value for unique key?
31 Answers A1 Technology, Wipro,
How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 Answers IBM, TCS, UHD,
what is user defined functions? : Sql dba
I want to execute a piece of code before calling a procedure. How to achieve it?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How do I create a sql script?
What kind of join is join?
how will you find out the last three records in a table with n no of records and delete them
What is pessimistic concurrency control? : Transact sql
What is the use of & in pl sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)