I want to develop a reservation system database(just like at indian railways ticketing counters)using oracle in which i can connect 2 computers by networkingcan u plz suggest which languages in oracle i should useand what applications of those would help me
Hi This is Srini .i want backup datbase from tables for certain time . how to write query in sqlserver.
1. what is a reverse key index and it's real time usage 2. Difference Between Hash Join & Merge Join 3. Difference between Optimizer=ALL_ROWS and Optimizer=CHOOSE 4. What is the meaning of cost, card, Bytes? 5. What is syntax for dropping a procedure and a function .Are these operations possible? 6. How you were passing cursor variables in PL/SQL 2.2? 7. What should be the return type for a cursor variable.Can we use a scalar data type as return type? 8. What is use of a cursor variable? How
1. List all the employees who have atleast one person reporting to them List the employee details if and... 2. What is the data type of the column of Dual table? 3. what is a reverse key index and it's real time usage 4. What are the privileges that view does not have as compared to normal table? 5. How to see the existing constraints in a table? 6. how do you generate prime numbers in sql not in plsql 7. What is Local Index and Global Index in Partition Table?What is Prefix Index and Nonprefix
How to insert of only system time(hh:mi:ss) into table columnnot in the format of 'dd/mm/yyy hh:mi:ss' only system time not date.
How to display time with sysdate?
Latest Answer : select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') from dual ...
How to delete contents in two tables at a time? When you delete contents in one table then other table contents should also be deleted.
Latest Answer : You may also use triggers for this purpose. But specifying on delete cascade while defining foreign key constraint is better option. ...
How to get System time in SQL?
