What is default constraint? How we you apply it?
Latest Answer: It specifies a default value for a new column or a new default for an existing column. Oracle assigns this value to the column if a subsequent INSERT statement omits a value for the column. A DEFAULT expression cannot contain references to other ...
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: To delete the records in a table , there are 2 ways . 1.Using the delete statement2.using the truncate statement . To delete the entire table drop statement is used . Deleting a record from a table :use the following statement. delete from table_name ...
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 hh:mi:ss') from dual; ...
Explian the 18 character long ROWID? How it gets constructed? How we will identify each part of ROWID?
Latest Answer: In addition to all this,unique key along with Not NULL constraint has got a name i.e. "candidate key".So a table having a column which is unique as well as not null apart from primar key is known as a candidate key.Thanks... ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
