How can we debug in PL/SQL?
No Answer is Posted For this Question
Be the First to Post Answer
Can a foreign key be null?
How you will create Toad Function?
Explain what is a view?
what are the different index configurations a table can have? : Sql dba
1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins
Explain what is dbms?
What is insert command in sql?
Can a view be updated/inserted/deleted?If Yes under what conditions?
What is the diff between Truncate table / delete <table name> purge
what will be the output: select 1 from emp union all select 2 from emp;
What are the types of operators available in sql?
How many functions are there in 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)