How to display time with sysdate?
Latest Answer: select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') from dual ...
How to desc table data without using desc command
Latest Answer: select column_name name,data_type typefrom user_tab_columnswhere table_name = ...
How to print the number of columns in a particular table also the column names without using JDBC Result set meta data using pure SQL code.
Latest Answer: select count(column_name),column_name from user_tab_columns where table_name='tablename'; ...
How to get field names from empty table by using SELECT statement;
Latest Answer: SELECT cnameFROM COLWHERE Tname ='EMP'/*Any table can be used here*/; ...
How many types of databases are there? What are they?
Latest Answer: These days when we talk abt database we are mainly talking about 2 databases namely : Analytical DatabaseOperational DatabaseAnalytical Database : Like OLTP( On Line Analytical Processing) are primarily static, read only database which store historical ...
In which manner the SQL commands access the data from database?
Latest Answer: Accessing data from a database depends on its implementation.consider the follwing statement select empname from emp where empid=100;(Oracle)1:first the server process of oracle checks whether the data is present in the dbbuffer cache2:if not ...
How data is stored in database?
Latest Answer: Data in database is logically stored in table space and physically stored in data files of database. ...
Can you provide any security for SQL queries? If Yes, How?
Latest Answer: thru views,or stored procedures so that the underlying query is abstracted ...
What is the disadvantage of using "BETWEEN" for date feilds
Latest Answer: It won't work to selecting data in between months ...
What is the difference between SQL & PLSQL?
Latest Answer: Sql is a non procedural language i.e. we say what to do not how to do . Oracle sql engine itself decides how to do.Where as pl sql is procedural language. We write program logic and control the execution sequence. ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
