<< < 44 45 46 47 48 49 50 51 52 53 54 > >>   Sort: Date

How To Rebuild an Index
How To Rebuild an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you want to rebuild an index, you can use the "ALTER INDEX ... REBUILD statement as shown in the following SQL script: SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME T...
2007-04-27, 5302👍, 0💬

Do you know Use Case points
Do you know Use Case points? In CD we have a complete free PDF tutorial of how to prepare software quotation. It has all the estimation technology that today’s software industry uses.
2007-10-30, 5301👍, 0💬

How to use a checkbox in a datagrid
How can I track event in checkbox which is one of the columns of a datagrid ? Note: - This is normally asked when the interviewer want to see that have you really worked practically on a project. Following are the steps to be done :- 1. In ASPX page you have to add Itemtemplate tag in datagrid. &...
2007-10-24, 5301👍, 0💬

What Is Atom 1.0 Standard
What Is Atom 1.0 Standard? - RSS FAQs - Atom Feed Introduction and File Generation Atom is an XML-based document format that describes lists of related information known as "feeds". Feeds are composed of a number of items, known as "entries", each with an extensible set of attached metadata. For exa...
2007-05-12, 5301👍, 0💬

How Many Cookies Can You Set
How Many Cookies Can You Set? - PHP Script Tips - Understanding and Managing Cookies How many cookies can you set in your PHP page? The answer is depending what is the Web browser your visitor is using. Each browser has its own limit: Internet Explorere (IE): 20 Mozilla FireFox: 50 If you want to te...
2007-04-24, 5301👍, 0💬

Why Do You Use JUnit to Test Your Code?
Why Do You Use JUnit to Test Your Code? This is a commonly asked question in a job interview. Your answer should have these points: I believe that writing more tests will make me more productive, not less productive. I believe that tests should be done as soon as possible at the code unit level. I b...
2008-01-03, 5298👍, 0💬

How To Run the Anonymous Block Again
How To Run the Anonymous Block Again? - Oracle DBA FAQ - Introduction to PL/SQL If you have an anonymous block defined in your session, you can run it any time by using the "/" command as shown in the following script: SQL> set serveroutput on; SQL> begin 2 dbms_output.put_line('This is a PL/SQL FAQ...
2007-04-25, 5297👍, 0💬

How To Pass Parameters to Procedures
How To Pass Parameters to Procedures? - Oracle DBA FAQ - Introduction to PL/SQL Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQ...
2007-04-26, 5296👍, 0💬

What Is "mysqlcheck"
What Is "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqlcheck" is a command-line interface for administrators to check and repair tables. Here are some sample commands supported by "mysqlcheck": "mysqlcheck databaseName tableName" - Checks the specified table in the ...
2007-05-11, 5295👍, 0💬

Can you give a practical implementation of FAÇADE patterns
Can you give a practical implementation of FAÇADE patterns? Façade pattern sits on the top of lot of subsystems and makes access easy to interfaces of these subsystems. Basic purpose of Façade is to make interfacing between many modules and classes manageable. Above is a simple live application of ...
2007-10-24, 5293👍, 0💬

How To View the Dropped Tables in Your Recycle Bin
How To View the Dropped Tables in Your Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables You can look what's in your recycle bin through the predefined view called RECYCLEBIN. You can use the SELECT statement to list the dropped tables as shown in the following script: SQL> connect HR/...
2007-05-04, 5293👍, 0💬

What is XML
What is XML? XML (Extensible markup language) is all about describing data. Below is a XML which describes invoice data. &lt;?xml version="1.0" encoding="ISO-8859-1"?> &lt;invoice> &lt;productname>Shoes &lt;qty>12 &lt;totalcost>100 &lt;discount>10 &lt;/invoice> An XML tag...
2007-10-31, 5292👍, 0💬

What is denormalization
What is denormalization ? Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance.The sacrifice to performance is that you increase redundancy in database.
2007-10-25, 5292👍, 0💬

How To View User Privileges
How To View User Privileges? - MySQL FAQs - Managing User Accounts and Access Privileges If a regular user wants to see his/her own granted privileges, he/she can use the "SHOW GRANTS" command. If the "root" user wants to see other user's granted privileges, he/she can use the "SHOW GRANTS FOR userN...
2007-05-10, 5291👍, 0💬

How To Generate a Form
How To Generate a Form? - PHP Script Tips - Processing Web Forms Generating a form seems to be easy. You can use PHP output statements to generate the required &lt;FORM> tag and other input tags. But you should consider to organized your input fields in a table to make your form looks good on th...
2007-04-23, 5291👍, 0💬

How To Loop through an Array without Using "foreach"
How To Loop through an Array without Using "foreach"? - PHP Script Tips - PHP Built-in Functions for Arrays PHP offers the following functions to allow you loop through an array without using the "foreach" statement: reset($array) - Moves the array internal pointer to the first value of the array an...
2007-04-14, 5291👍, 0💬

What are the steps to create a webservice and consume it
What are the steps to create a webservice and consume it ? Note :- For this question this book will make a attempt by creating a simple webservice and explaining steps to acheive it. A simple webservice will be created which takes two number and gives addition result of the two number. In CD sample ...
2007-10-23, 5290👍, 0💬

How To Break a File Path Name into Parts
How To Break a File Path Name into Parts? - PHP Script Tips - Working with Directoris and Files If you have a file name, and want to get different parts of the file name, you can use the pathinfo() function. It breaks the file name into 3 parts: directory name, file base name and file extension; and...
2007-04-23, 5289👍, 0💬

What Is a Dead Lock
What Is a Dead Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks the other transaction as shown in the following diagram: (transaction 1) (transaction 2) update row X to create loc...
2007-04-17, 5288👍, 0💬

What Is Rollback
What Is Rollback? Rollback causes work in the current transaction to be undone.
2007-04-15, 5288👍, 0💬

What is SIX sigma
What is SIX sigma? Sigma means deviation in Greek language. Deviation means how much variations exist in a set of data. For instance let’s say in a software maintenance project out of 100 defects 68 defects are rectified to the mark and remaining bounce back that means your bug fixing process is on ...
2007-10-30, 5285👍, 0💬

How To Do Clean Up If CREATE DATABASE Failed
How To Do Clean Up If CREATE DATABASE Failed? - Oracle DBA FAQ - Creating New Database Instance Manually To better organize data files, you should create a dedicated directory for each Oracle database. This can be done by using Windows file explorer to create the \oraclexe\oradata\fyi\ directory. Tr...
2007-04-23, 5284👍, 0💬

How To Force the PHP Engine to Use Cookies to Transfer Session IDs
How To Force the PHP Engine to Use Cookies to Transfer Session IDs? - PHP Script Tips - Understanding and Using Sessions If you want to force your PHP engine to use cookies to transfer session IDs instead of URL parameters, you can open the PHP configuration file, php.ini, and make the following cha...
2007-04-18, 5284👍, 0💬

How To Reformat a Paragraph of Text
How To Reformat a Paragraph of Text? - PHP Script Tips - PHP Built-in Functions for Strings You can wordwrap() reformat a paragraph of text by wrapping lines with a fixed length. Here is a PHP script on how to use wordwrap(): &lt;?php $string = "TRADING ON MARGIN POSES ADDITIONAL RISKS AND IS NO...
2007-04-21, 5283👍, 0💬

<< < 44 45 46 47 48 49 50 51 52 53 54 > >>   Sort: Date