INVENTORY table has 3 columns -- Id_Number Number (primary key)Description varchar2(30)Supplier_id numberYou want to create a query that for each session allows the user to input a value for DESCRIPTION
Latest Answer: HI if u want to get the same table structure which is already existing in ur database then SQL QUERY IS create table as select * from where 1 = 2; If u want data also then create table ...
Latest Answer: The large pool is created to avoid contention in the shared pool in the case of shared server environment..The UGA process takes place in the shared pool in the case of shared server environment..so to avoid contentions all the user processes are shifted ...
Latest Answer: Row Cache is also known as the Dictionary Cache in the Shared Pool. ...
Latest Answer: Thanks for ur reply Vikas. ...
Hi FriendsI Completed Oracle OCP For DBA.Now I Want Upgrade or I Want to Do OCM Certification Can Any one Help Me...
Latest Answer: You can use the oraenv script to ensure that user accounts are updated and to switch between databases. ...
How can you create tablespaces of non-standard block sizes by using the CREATE TABLESPACE statement ?
What will be the output of the following query? select replace(substr((dump(ename)),(instr((dump(ename)),' ',-1,1))),',',' ') "Value of ENAME" from emp;
value of ename---------------------- 83 77 73 84 72 65 76 76 69 78
View page [1] 2 3 4 5 6 7 Next >>
Go Top
