What is the difference between having clause and where clause?
No Answer is Posted For this Question
Be the First to Post Answer
What is pl sql in dbms?
explain the advantages and disadvantages of stored procedure? : Sql dba
Explain the difference between 'between' & 'and' operators in sql
Is sqlite free?
What is t sql used for?
Can we use distinct and group by together?
I want to know last five transactions or records from emp table, from now?
what are tables and fields? : Sql dba
How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).
can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
Does sql*plus also have a pl/sql engine?
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)