Can dml statements be used in pl/sql?
No Answer is Posted For this Question
Be the First to Post Answer
When we give SELECT * FROM EMP; How does oracle respond?
24 Answers Accenture, HCL, Infosys,
How do I copy a table in sql?
Explain the difference between 'between' & 'and' operators in sql
What is an Integrity Constraint?
if a table is getting updated what happens if a function is called from sql query?
What are the types of index in sql?
What is trigger in pl sql?
what eliminate duplicate without using roenum and not
i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....
If the base table structure is changed what will happen to join index????
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
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)