in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
3 5810acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
2 5607Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
2 6511What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
1 7260ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
2343Post New Oracle General Questions
What is ordinary table in oracle?
What happens if the update subquery returns multiple rows?
What is a procedure in oracle?
Explain the difference between sql and oracle?
List out the difference between commit, rollback, and savepoint?
How to manage transaction isolation level?
How to define a variable of a specific record type?
How to convert a date to char in oracle? Give one example.
What is the parameter mode that can be passed to a procedure?
How is it different from a normal table?
What is Redo Log Buffer in Oracle?
How to define an anonymous procedure with variables?
How to compare dates in oracle sql?
What is hot backup and logical backup?
How to export data to a csv file?