Latest Answer: "Force" option used to create a view without existance of Table in the databaseSyntax: Create or replace FORCE VIEW as select * from Thanks&RegdsRamki,TCS,Hyd 9989018508 ...
A table has following layout ; CITY, NAME , SEXHow do you write a query to get the count of Male, count of female in a given city XXX.Query result should be in a single row with count of male , count of female as columns?
Latest Answer: For DDL commands, We cannot do autocommit off. It is modify structure of database object such as table, view and these commands have automatically commit.Set autocommit on/off is used for DML. ...
Latest Answer: SELECT * FROM (SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME LIKE 'TEST');Above query will give the result as TEST.If you dont want to use the table name directly in the query, you can create synonym for that table and can use that synonym in your ...
Latest Answer: by using alter table we can alter only column not the rows. by using alter command we write query like this........alter table table_name add column_name datatype;for drop that column ;alter table table_name drop column_name datatype;it's ...
Latest Answer: COMMIT:it is used to make the manipulations ENABLE permanently on the table where as ROLLBACK is used to DISABLE the effect of the queries(which were typed a bit above it) on the table. one ROLLBACK statement is sufficient ...
Latest Answer: The startup of database depends on the nature of Oracle server :Incase Of Enterprise Server and Unix Environment :Go to Unix and type the following commands :sqldba lmode=yconnect internalstartupThis will start the Oracle Instance.Incase Of Workgroup ...
Latest Answer: In Oracle 9i instead of snapshot we can use meterialized views which can act as snapshot.Diff between view & snapshot is view is not a table its a virtual table to join one or more table or to prevent access from users on complete data on table. whenever ...
Latest Answer: if DEFINE is isqlplus command then how do u define ACCEPT command. what is difference between them?i think define is a command in sql *plus which works same in isqlplus with ACCEPT.pls do forward the argument. ...
i don no
Latest Answer: Hi,Implementing a project from the begining to the production and maintenance stage.(1) System Planning: (Scope & Budget of the Project)(2) Business Analysis: (Business ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
