What is default constraint? How we you apply it?
Latest Answer: A coulumn can be given a default value by using DEFAULT option. This option prevents null values from entering the column if a row is inserted with out a value in to the table.Ex: .......Hire_date DATE DEFAULT SYSDATE,....... ...
How do you get back into SQLPlus to disable restricted session if you enabled.
Latest Answer: "When database is in restricted mode only users who have restricted permissions can log on to database"Â To disable itALTERÂ SYSTEM DISABLE RESTRICTED SESSION ...
In how many ways can I delete all the contents of a table and the entire table. Explain with syntax ?
Latest Answer: Actually there are three ways to delete a table1. Delete: This is used to delete the one or all the records. The thing with this is that only data is been deleted but the table structure and the memory allocated to it is safe.2. Truncate: Truncate is ...
In which section of a PL/SQL block is a user defined exception waste?
Latest Answer: In exception block ...
List all customer (user id, name, and e-mail), number of charging, total charging,number of transaction and total number of transaction value?If u have these tables:1- 'Credit_card'columns: credit_number,type,value,Customer_ID.2-'Coupon'columns:
Latest Answer: Hi, One of the solution is as follow: select cust.customer_id,fname,mname,lname,e_mail,credit.tot_credit+coupan.tot_coup no_of_recharge,credit.tot_credit_val+coupan.tot_coup_val tot_recharging,tot_trans,credit.tot_credit_val+coupan.tot_coup_val-current_balance ...
Latest Answer: There is no restiction on number of datatypes allowed except for long and LOB.I table can contain only one long column. ...
How is the data inserted in the Index table when a new row is inserted into the main table on which the index is created ?
Latest Answer: select to_char(sysdate,'dd-mm-yy hh24:mi:ss')from dual; ...
Explian the 18 character long ROWID? How it gets constructed? How we will identify each part of ROWID?
Latest Answer: First of all I will tell Not null, unique, primary key are constraints.Not null:
When we are inserting record in the table, if we insert null values in the table then it should not accept the record for that purpose, we have to use not null constraint.
Unique: ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
