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 5819acname 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 5609Create 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 7263ur 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
2345Post New Oracle General Questions
How will you differentiate between varchar & varchar2?
How to define a cusotmer as a supplier in ORACLE R12
How to upsert (update or insert into a table)?
What is rich query?
How to download oracle database 10g xe?
Is the After report trigger fired if the report execution fails ?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How to insert multiple rows with one insert statement in oracle?
What is oracle rowcount?
How to start your 10g xe server from command line?
How to drop a stored function?
What are joins, explain all types of joins?
What is a cursor variable?
How would you change old and new values in an insert, delete and update triggers?
how to clone 9i Database on to 10g Database.