How is use pl and sql?
No Answer is Posted For this Question
Be the First to Post Answer
i don't want the message as 14 rows updated just it should update what it will do
What is the use of index in hive?
using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.
what are all types of user defined functions? : Sql dba
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
Are sql connections encrypted?
what is sql in mysql? : Sql dba
Explain raise_application_error.
4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;
What is left join example?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
If a cursor is open, how can we find in a pl/sql block?
Oracle (3253)
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)